I have encountered a wiered problem.
I am using visual studio 2005, Oracle 8.1 and OracleClient.

ADO.NET works fine even for batch statement, but for some reason, it
hangs-up and never comes back, when executing the statement like this.

BEGIN
RDS.GENERATE_FORMULA_BATCH('2395589','100','02-Aug-2007','02-Aug-2007','HSDEMO5',NULL,NULL,1,46,NULL,NULL);
RDS.GENERATE_FORMULA_BATCH('2395605','100','02-Aug-2007','02-Aug-2007','HSDEMO8',NULL,NULL,1,46,NULL,NULL);
END;

when i execute in SQL navigator it comes back with Error(that is generated
by trigger as business logic error), but i expect AD.NET as well to return me
an error, instead it never comes back.

Cmd.Connection = Cn
Cmd.CommandType = CommandType.Text
Cmd.CommandText = SQL
Cmd.ExecuteNonQuery

Just wanted me highlight, that i have several such SQL Statements which runs
fine, but this fails & hangup .

Any help is appreciated