How to supress an error in Oracle Stored Procedure 
Author Message
 How to supress an error in Oracle Stored Procedure
My stored procedure creates an error.  I want to suppress the error
message.  How can I do that.  I am using Oracle 8.1.7.

Thanks
SM



Wed, 24 Mar 2004 00:24:22 GMT
 How to supress an error in Oracle Stored Procedure


Quote:
> My stored procedure creates an error.  I want to suppress the error
> message.  How can I do that.  I am using Oracle 8.1.7.

> Thanks
> SM

This suppresses *all* exceptions (as you don't specify *which* error you
want to ignore.
Exception when others then null
This is however generally speaking *extreemly bad* programming practice.
To ignore a specific error
your_error exception;
pragma exception_init (your_error, -<error number>)

exception when your_error then null

This should be documented in the PL/SQL manual

Please also try to refrain as much as possible from excessive crossposting
as you won't get a bigger audience. This topic belongs in .server only

Regards,

Sybrand Bakker, Senior Oracle DBA



Wed, 24 Mar 2004 01:13:29 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Supress error message in stored procedure

2. How do I supress Oracle Error Messages from being dispalyed from a PL?SQL progm

3. Supress Display of Oracle Error Messages in SQL*PLus

4. Error at obtaining output parameters of the stored procedure, calling other stored procedure

5. How to call an Oracle Stored procedure from MSSQL Server Stored Procedure

6. Tool for converting Store Procedure in SQL Server to Oracle Store Procedures

7. Calling Oracle Stored Procedure from within SQL Server Stored Procedure

8. Generate an error to an error log on a stored procedure error

9. Calling a Java Stored Procedure from another Java Stored Stored Procedure

10. Calling remote Stored Procedure on oracle.. ODBC error

11. ODBC API error when calling Oracle stored procedure

12. Error calling Oracle store procedures using ADO


 
Powered by phpBB® Forum Software