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

From: Lyndon Tiu <ltiu@xxxxxxxxxxxxx>
To: "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>, rjamya@xxxxxxxxx
Date: Mon, 06 Dec 2004 11:46:11 -0800

OK. Changed it but still same error message.

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=> 20001,
        msg=> 'Duplicate query by default for layer fk = ' || 
:new.xdb_layer_type_fk);
     end if;
END;

Any other suggestions?

Thanks.

--
Lyndon Tiu
--
http://www.freelists.org/webpage/oracle-l

Follow-Ups:

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

References:
- RE: Trigger - Missing IN or OUT parameter at index: 1
  - From: Mercadante, Thomas F

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

Other related posts: