Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Trigger error: Too many open cursors
Carlos schrieb am 19.01.2006 in
<1137655832.211478.86980_at_g43g2000cwa.googlegroups.com>:
Hi Carlos,
>>> why should I use exception_init?
> For example, if you want to capture certain exception (other than a
> predefined PL/SQL exception) you use:
> DECLARE
> deadlock_detected EXCEPTION;
> PRAGMA EXCEPTION_INIT(deadlock_detected, -60);
> BEGIN
> ...
> ...
> EXCEPTION
> WHEN deadlock_detected THEN
> -- handle the error
> END;
> Cheers.
If I understand correctly so it is useful inside the oracle- system, if
I want to cath non oracle exceptions.
But if I like in my case have a trigger that sometimes detects an
exception so it is not really useful, because if somebody f.e. go to the
database by ODBC or something els he will get an errorcode w/o
explaination.
Is it right?
> Carlos.
Thank you
Andreas
-- wenn email, dann AndreasMosmann <bei> web <punkt> deReceived on Thu Jan 19 2006 - 13:01:46 CST