Trigger - Missing IN or OUT parameter at index: 1
- From: Lyndon Tiu <ltiu@xxxxxxxxxxxxx>
- To: Oracle-L <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 06 Dec 2004 08:22:51 -0800
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
