Not a Java topic.
Don't cross-post.

^heLen
(Mail Witch)

At 09:02 AM 1/09/2003 +0000, you wrote:

>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
>
>
>
>
>To unsubscribe from this group, send an email to:
>Firebird-Java-unsubscribe@yahoogroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/