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@(protected) > 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
