Re: Trigger - Missing IN or OUT parameter at index: 1

plus you shouldn't raise -1 as error message, the valid values for
raise_application_error are 20000 to 20999 (or somewhere around
there).

Raj


On Mon, 06 Dec 2004 08:22:51 -0800, Lyndon Tiu <ltiu@xxxxxxxxxxxxx> wrote:
> Hello guys,
> 
> Could use some help here.
> 
> 1) Below is a trigger body:
> 
> declare cnt number;
> BEGIN
> select count(*) into cnt from xdb_record_types where query_by_default =
> 1 and xdb_layer_type_fk = :new.xdb_layer_type_fk;
>     if cnt > 1 then
>     RAISE_APPLICATION_ERROR (
>         num=> -1,
>         msg=> 'Duplicate query by default for layer fk = ' +
> :new.xdb_layer_type_fk);
>      end if;
> END;
> 
> 2) I am getting error:
> 
> "Missing IN or OUT parameter at index : 1"
> 
> Thank you for any suggestions.
> 
> --
> Lyndon Tiu
> --
> http://www.freelists.org/webpage/oracle-l
> 


-- 
------------------------------
select standard_disclaimer from company_requirements where category =
'MANDATORY';
--
http://www.freelists.org/webpage/oracle-l

Other related posts: