Problem with ExecuteNonQuery in oracle

Question

0.00/5 (No votes)

See more:

Hi Folks,

I am facing a problem with ExecuteNonQuery method in Oracle.

C#

oraConnection = new Oracle.DataAccess.Client.OracleConnection(_connectionString);

Oracle.DataAccess.Client.OracleCommand cmd= new Oracle.DataAccess.Client.OracleCommand("Update tableA set Name='Anand' where Id=25005', oraConnection);

      orda.UpdateCommand = cmd;
      cmd.CommandType = CommandType.Text;
      cmd.CommandTimeout = 0;
      oraConnection.Open();
      rowAfected = cmd.ExecuteNonQuery();

On ExecuteNonQuery my application got hanged looks like operation is still in progress.

Any help is appreciated.

Posted 11-Jun-14 1:25am

vickyanand25005

Updated 11-Jun-14 1:29am

CHill60

v2

Add a Solution

Comments

[no name] 11-Jun-14 7:30am

Try setting your time out to something other than waiting infinitely. Or get rid of it altogether.

CHill60 11-Jun-14 7:34am

Is that your code exactly as it appears? Because you are missing the closing quotes on your command string

[no name] 11-Jun-14 7:42am

You should go back to "Hawkeye" ;-) Good catch.

ZurdoDev 11-Jun-14 7:41am

As mentioned, your code as posted is incorrect syntactically. However, I would suggest running the statement directly in Oracle to see what happens. Also, a CommandTimeout of 0 is dangerous. You may need to set it to 5 minutes or something high but I would not set it to 0.

Updates depend on indexing and how long it takes Oracle to find the record.

vickyanand25005 11-Jun-14 8:12am

I have tried the same script in oracle it is working fine and If i set timeout then query execution stops after that time with error execution canceled by User.My connection is also getting close it just a code snippet where the problem is.

ZurdoDev 11-Jun-14 8:40am

How long does it take in oracle directly?

vickyanand25005 11-Jun-14 8:58am

few sec like 2 3 sec and it fetch the result

ZurdoDev 11-Jun-14 9:16am

Then I would debug the code. It's hard to believe that executing the code you showed would actually hang. My guess is you have something else causing it. I would also remove the line CommandTimeout = 0. I believe it defaults to 30 seconds anyway.

Chris875 11-Jun-14 8:38am

What is that line "orda.UpdateCommand = cmd;" for? Are you issuing the same sql from OracleDataAdapter and cmd.ExecuteQuery?

GuyThiebaut 11-Jun-14 10:34am

oraConnection.Open();
Where is the close directive?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

GuyThiebaut · Answer 1 · 2014-06-11T04:41:00

Solution 1

You are missing a close directive:

oraConnection.Open();
rowAfected = cmd.ExecuteNonQuery(); 
oraConnection.Close();

Posted 11-Jun-14 4:41am

GuyThiebaut