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
Volker Hetzer - 14 May 2008 16:41 GMT
Prasanta schrieb:
> Hello,
>
[quoted text clipped - 16 lines]
> 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

Signature
For email replies, please substitute the obvious.