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