Trigger - Missing IN or OUT parameter at index: 1 2004-12-06 - By Mercadante, Thomas F
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@(protected)]
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
|
|
