--- In firebird-support@yahoogroups.com, Robert martin <rob@c...> wrote:

> Hi
>
> I am a stored procedure novice (in the extreme). I have the following

...

> Any suggestions ?

...

>
> CREATE PROCEDURE BackOrderedItems (DrTransRef Numeric(11) )
> RETURNS (

...

> WHERE d.DrTransRef = :DrTransRef
> AND d.Subrank = 999

...
.Itemref = :i_ItemRef

> INTO Avail, Due;

INTO :Avail, :Due

>
> SUSPEND;
> END
>
>
>

note :

mick