> 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

It looks like you don't have spaces between parameters in your SET TERM
lines

You need:
SET TERM ## ;
not
SET TERM ##;