Oracle and .NET


P

Prasanta

Hello,

I have an SP, which is calling from .NET code using ODP.

In that SP i have few update table statement followed by Insert
statement and then delete statement.

When I am executing its not updating the table. means the code flows
are:

Update <statement>
Update <statement>
Update <statement>
Insert <statement>
Commit
Delete <statement>
Commit

In this scenario, update statements are not working. do i need to put
commit after every update statement.

Cheers,
Prasanta
 
Ad

Advertisements

V

Volker Hetzer

Prasanta said:
Hello,

I have an SP, which is calling from .NET code using ODP.

In that SP i have few update table statement followed by Insert
statement and then delete statement.

When I am executing its not updating the table. means the code flows
are:

Update <statement>
Update <statement>
Update <statement>
Insert <statement>
Commit
Delete <statement>
Commit

In this scenario, update statements are not working. do i need to put
commit after every update statement.
No you don't.
How do you check this?
Are you using a connection pool and switch in the middle of the update statements?

Lots of Greetings!
Volker
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Oracle and .NET 0
.NET with Oracle 8.1.7 1
Oracle FGAC and .NET 0
Oracle Cursors with .Net 3
.NET to Oracle issue 3
.net Connecting to Oracle 2
MS .Net provider for Oracle 1
.Net Reporting against Oracle 3

Top