Re: How to capture Oracle Error

Erika,

        The runtime doesn't get that far. The procedure aborts immediately on the first statement.

On Mon, 09 Jul 2001 17:39:47 +0200, Erika Grondzakova <Erika.Grondzakova_at_cern.ch> wrote:

>Hello,
>
>You can try this
>
>CREATE OR REPLACE PROCEDURE SP_LOAD_REVEXP_TBL
>(IN_Inv_Per CHAR DEFAULT NULL,
> IN_Prj_Id NUMBER DEFAULT NULL,
> IN_Cust_Id CHAR DEFAULT NULL)
>IS
>begin
>
> if IN_Inv_Per is null and IN_Prj_Id is null and IN_Cust_id is null
>then
> raise_application_error(-20101, 'Here follows your error text...');
> end if;
>
>end;
>/
>
>Hth,
>
>Erika
>
>
>NeedaHoliday wrote:
>>
>> 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)
>> IS
>>
>> 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:51:44 CDT