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

From: Mercadante, Thomas F <thomas.mercadante_at_labor.state.ny.us>
Date: Mon, 6 Dec 2004 11:54:09 -0500
Message-ID: <C9995D8C5E0DDA4A8FF9D68EE666CE0702A970D3@exchsen0a1ma>

Lyndon,

I've never seen the + sign used in a call to a procedure (but that doesn't mean it's incorrect).

Could you try this:

RAISE_APPLICATION_ERROR (
num=> -1,
msg=> 'Duplicate query by default for layer fk = '

   || :new.xdb_layer_type_fk); <=== changed the + to double pipes.

Tom

-----Original Message-----

From: Lyndon Tiu [mailto:ltiu_at_alumni.sfu.ca] Sent: Monday, December 06, 2004 11:23 AM To: Oracle-L
Subject: Trigger - Missing IN or OUT parameter at index: 1

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
--

http://www.freelists.org/webpage/oracle-l Received on Mon Dec 06 2004 - 10:56:28 CST