OraFAQ Forum: Server Administration » Re: What is use of 'raise' command in pl/sql

Home » RDBMS Server » Server Administration » Re: What is use of 'raise' command in pl/sql

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: What is use of 'raise' command in pl/sql [message #374256]

Sun, 03 June 2001 02:39

Suresh Vemulapalli
Messages: 624
Registered: August 2000

Senior Member

Hi,
you can use raise statement to raise user defined exceptions

Ex:
Declare
ex exception;
begin

if ...

raise ex;
end if;

exception
if ex then
....

end if;
end;

Suresh

Report message to a moderator

Re: What is use of 'raise' command in pl/sql [message #374266 is a reply to message #374256]

Mon, 04 June 2001 01:15

Rajee
Messages: 17
Registered: June 2001

Junior Member

Hi,
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;

Regards,
rajee

Report message to a moderator