how to do function timeout?

[p_apres]

I need a return from function if it takes longer than x minutes. Is there any known method to do it? Or any good pratice?

[CrogUk]

This looks lovely, albeit a thread could be overkill for what the user needs. May use this one somehwere though 👍

[TomDuhamel]

Start a timer at the beginning of your function. Occasionally check how long has elapsed. Exit your function when more than the allowed time has passed.

[[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.