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

Other related posts: