SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

RAISE_APPLICATION_ERROR -- Suppress unwanted messages

250902Apr 17 2002

Hi,
I have used raise_application_error(-20001,'No data found in database'); in my pl/sql block.
But when this is executed , i get following lines:

DECLARE
*
ERROR at line 1:
ORA-20001: No data found in database
ORA-06512: at line 35

Is there any way to suppress other messages coming from stack.
I just want to display: ORA-20001: No data found in database

Any help would be appreciated.

Thanks and Regards

Vinod.

Locked Post

New comments cannot be posted to this locked post.

Locked on May 16 2002

Added on Apr 17 2002

4 comments

797 views