Also - don't put the ; char at the end of the END statement within the
procedure
Alan
END ##
not
END ##;

> -----Original Message-----
> From: Nigel Weeks [mailto:nigel@...]
> Sent: Tuesday, 2 September 2003 2:54 PM
> To: firebird-support@yahoogroups.com
> Subject: RE: [firebird-support] Re: Problem in stored procedure for
> multiple deletes/multiple times use of i/p vari.
>
>
> > hi,
> > Thanx for the reply i tried the changes you told me but still it
> > is giving an error.
> >
> > changed code is -
> >
> > SET TERM ##;
> > CREATE PROCEDURE Z2(
> > CALAPP_ID INTEGER
> > )
> > AS
> > BEGIN
> > delete from calappparams where caid = :calapp_id;
> > delete from hostedapps where caid = :calapp_id;
> > END ##;
> > SET TERM ;##
> >
> > error message after commit; is
> > ->
> > Statement #1:
> > invalid request BLR at offset 90
> > bad parameter number
> >
> > My firebird version is -> FireBird 1.0.2
> > I am using MiTeC Interbase/Firebird administartive tool as a query
> > analyser.
> > If you get any hint/solution plese let me know.Thank you.
> >
> > sudarshan
>
>
> It looks like you don't have spaces between parameters in your SET TERM
> lines
>
> You need:
> SET TERM ## ;
> not
> SET TERM ##;
>
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>