The fact that you are using the same input parameter in two places is not
the problem.

Try commenting out the line that works, and see if it still breaks.
/* Use slash-star to begin the comment, and star-slash to end */

Tried a backup/restore?

> -----Original Message-----
> From: Sudarshan Wad [mailto:sudan5757@...]
> Sent: Tuesday, 2 September 2003 16:39
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] Re: Problem in stored procedure
> for multiple
> deletes/multiple times use of i/p vari.
>
>
> hi,
> There are no triggers/stored procedures righ now.this is the
> first stored procedure i amgong to write.I am not getting why it
> works when i use one more input parameter and when i use it i second
> delete statement?
> Why it is not working when i use same input parameter in 2
> different delete statements?
>
> sudarshan
>
> --- In firebird-support@yahoogroups.com, "Nigel Weeks" <nigel@e...>
> wrote:
> > Have you got any 'ON DELETE' triggers on the table 'hostedapps'
> >
> > Could it be that the delete call is working, it's firing a
> trigger, and a
> > procedure being called from the trigger is failing?...
>
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~-->
> Buy Ink Cartridges or Refill Kits for Your HP, Epson, Canon or Lexmark
> Printer at Myinks.com. Free s/h on orders $50 or more to the
> US & Canada. http://www.c1tracking.com/l.asp?cid=5511
> http://us.click.yahoo.com/l.m7sD/LIdGAA/qnsNAA/67folB/TM
> --------------------------------------------------------------
> -------~->
>
> 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/