At 05:38 PM 7/05/2005 +0200, you wrote:

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

>Has anyone an idea what the issue could be?

What is the data type of "KeywordID" in the database definition?

./heLen