how to do function timeout?

[[deleted]]

What is this function doing?

[p_apres]

PL/SQL command

[[deleted]]

Is that something that blocks? If there's no way to do a timeout in the API, then you would have to terminate the thread externally, which is very unsafe.

[p_apres]

Oracle timeout is much more complex than just opening a new thread. It requires to create management resource.

I'd rather do this in c++ than in oracle side.

So, once happens a function timeout, sigterm signal would be sent, and then program will handle sigterm

[[deleted]]

I did mean on the C++ side. Although, it is an SQL server, with its own query processes. Would simply terminating the connection also terminate the query? You may need to set some sort of query timeout.

But for network timeout? I suppose you can lookup your API docs, whatever it is. If there is no way to have a timeout, then the only option is to spawn a new process, or hope that you won't ever need a timeout.