PC Review


Reply
Thread Tools Rate Thread

ADO.NET Hangs-up(does not return) when executing SQL Batch Satetme

 
 
=?Utf-8?B?TiBT?=
Guest
Posts: n/a
 
      2nd Aug 2007

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


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
executing batch files using VBA srkumar Microsoft Excel Programming 2 21st Apr 2006 04:27 PM
Error 732 while executing batch with PM8 Patrick E. King Storage Devices 0 30th Apr 2005 09:27 PM
Executing a Batch job on a different server. BasicQ Microsoft VB .NET 1 20th Apr 2005 06:42 PM
Executing a Batch file. James Microsoft Access VBA Modules 2 10th Sep 2004 01:33 PM
Executing BATCH files in VB.NET Danel Microsoft VB .NET 3 10th Sep 2003 10:54 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:33 AM.