PC Review Forums Newsgroups Microsoft DotNet Microsoft ADO .NET Problem with oracle transaction

Reply

Problem with oracle transaction

 
Thread Tools Rate Thread
Old 01-05-2008, 01:38 PM   #1
Prasanta
Guest
 
Posts: n/a
Default Problem with oracle transaction


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
  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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off