hi,
Can any one tell me how to write a store procedure in
firebird,which will have many delete statements.Why i am asking this
question is because,i have written a stroed procedure to delete from
two tables ,it gets compiled and when i say commit; it gives an
error.

Example which is not working 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 after commit is -->
statement 1:
invalid request BLR at offset 88
bad parameter number.


If any one can give a good working example of stored procedure
which will have many delete statements ,i will be thankful to
him/her.

sudarshan

ps :- Helen Borrie,i have framed this question in general format.