Oracle Tips #5 [Exception on the fly]

to raise an Exception from a Trigger, Stored Procedure or Function without needing anything you can use the function : raise_application_error.

Syntax : raise_application_error(<your exception integer code>, <your string description>);

Leave a Reply

 

 

 

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>