Catch exception in Oracle/plsql--from Cyber

PL/SQL Exception throwing and handling

1. Get Exception Specific information:

1 Dbms_output.put_line (‘Error code is:‘||sqlcode); 2 -- output exception number 3 dbms_output.put_line ( "error message is:  ' 

2. Exception throws

(1) Raise

Declare

Exception_1 exception

Begin

If True Then

Raise exception_1;

End If;

Exception when Exception_1 then

...

End

Or you don't have to throw it yourself.

Declare

Exception_1 exception

pragma exception_init (exception_1,-2292);

Begin

Exception when Exception_1 then

...

End

(2) Raise_application_error

Raise_application_error ( -10020, ' my exception ');

3. Handling of exceptions

exception

When exception 1 Then

When exception 2 Then

...

When others then

End

Catch exception in Oracle/plsql--from cyber