RAISE_APPLICATION_ERROR [message #40795] |
Thu, 07 November 2002 02:30 |
ray park
Messages: 7 Registered: September 2002
|
Junior Member |
|
|
I have an error for the following piece of code.
i am trying to raise an expectation with the following code.
however when it comes to compile the code oracle says that i have to declare the RAISE_APPLICATION_ERROR. i have looked in books however they say that i am doing it right.
if (:cwk_mark >=0) then
RAISE_APPLICATION_ERROR(-20100,'No');
end if;
any help would be grautfully welcomed
|
|
|
Re: RAISE_APPLICATION_ERROR [message #40832 is a reply to message #40795] |
Thu, 07 November 2002 09:29 |
Todd Barry
Messages: 4819 Registered: August 2001
|
Senior Member |
|
|
Your code snippet looks fine - no idea why you would get that error on compiling.
What happens if you run this in SQL*Plus?
exec raise_application_error(-20000, 'Test')
|
|
|
|