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