How to set query timeout in DB?

[Mnemonical]

There's a way of doing it if you are using Oracle Advanced Queuing. There's an exception numbered -25228.

declare
eTimeOut Exception;
pragma exception_init(eTimeOut, -25228);

begin
....

exception
when eTimeOut then
null;
end;


I'm not sure but I believe this exception error, that occurs when time is out, is only used for job queue processes ...

I hope I have helped.
F.