hi,
Nigel and Alan ,i accept your suggestion.I made the changes as you
specified and i will follow that from today on,but it didn't solved
my problem.
I have given explaination in previous mail about what happens if i
try one statement and more than one statements which use same input
parameters.
Thank you for your replies.but still help is needed.

sudarshan

--- In firebird-support@yahoogroups.com, Alan McDonald <alan@m...>
wrote:

> 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@e...]
> > 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/

> >
> >
> >