Home » RDBMS Server » Server Administration » Re: What is use of 'raise' command in pl/sql
Re: What is use of 'raise' command in pl/sql [message #374268] Mon, 04 June 2001 01:50
Rajee
Messages: 17
Registered: June 2001
Junior Member
Hi,
If 'raise' command in exception block re-raise the exception, what is the use of it.

Original
--------
Sorry. I am not asking about raising user-defined exceptions. What i trying to ask is 'We can use raise command within the exception block itself without giving any exception names.
Example:
Begin
...
raise exp;
...
exception
when exp then
dbms_output.put_line('Invalid data');
raise;
end;

Reply from suresh
-----------------
It will re-raise the exception
Previous Topic: updating table with another table
Next Topic: Re: Sending mail in PL/SQL.
Goto Forum:
  


Current Time: Thu Jul 04 03:01:02 CDT 2024