hi,
Thanks,that solved the problem,but for only one delete query.if in
my procedure i am using many deletes,then proceduure query gets
executed correctly but when i say commit i encounter an error.

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 ##;
SET TERM ##

//this gets compled but when i say commit;
error is -
Statement #1:
invalid request BLR at offset 90
bad parameter number

I am not getting this message.I tried by using a local
vaiable ,asigning calapp_id to it and using.But fails.I have to do
many complex deletes through the procedure.

If you have the solution please let me know.And than you for that
advice .as i have moved forward because of your help.

sudarshan