Hi

I try to store the proc below but get always a "bad parameter number" error.
If I remove >> or "KeywordID" = :holdingSub << then I do not get an error
but this is not what I need.
I am using Firebird 1.5.2

Has anyone an idea what the issue could be?

Thanks
Daniel Putra
----------------------------------------------------------------------------
set term ^;
create procedure "getAllHoldingSubs" (holdingSub numeric(18))
returns (keyword numeric(18)) as
begin
for
select "KeywordID" from "HoldingSub"
where ("HoldingSubID" = :holdingSub or "KeywordID" = :holdingSub)
into keyword
do
suspend;
end ^
commit work ^
set term ; ^