Hi,

> I am writting stored procedure which will fire many delete queries
> on the basis of the number as a input parameter.When in the stored
> procedure i use only one delete statement and use :calapp_id in
> it .it gets created and committed.but if i use more than one delete
> statement which use same variable in where clause,then create
> procedure query gets executed bt commit gives an error.I have given
> the code ->

Is the below part your actual code that you're trying to run? If so,
I would change the following:

> eg:-
>
> SET TERM ##;
> CREATE PROCEDURE Z(
> CALAPP_ID INTEGER
> )
> AS
> BEGIN
> delete from calappparams A where A.caid = :calapp_id;
> delete from hostedapps where caid = :calapp_id;
> END ##;

END##

> SET TERM ##

SET TERM ; ##


And then do a COMMIT.


With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com