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_at_alumni.sfu.ca> 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