How to capture Oracle Error

Could someone tell me how to capture the following;

I have a procedure with the following parameters;

CREATE OR REPLACE PROCEDURE SP_LOAD_REVEXP_TBL

(IN_Inv_Per  CHAR,
 IN_Prj_Id   NUMBER,
 IN_Cust_Id  CHAR)

If I execute this without parameters I get

ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'SP_LOAD_REVEXP_TBL'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

What I want to do is, override the Oracle error and put my own.

Is there a way ?

THanks in advance Received on Mon Jul 09 2001 - 10:22:30 CDT