Problem with oracle transaction

Prasanta

Guest

Posts: n/a

1st May 2008

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

« TransactionScope and Concurrency? | Oracle and .NET »

Thread Tools
Show Printable Version Email this Page
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 Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Oracle read only transaction in VB .NET?	ashley.ward@gmail.com	Microsoft VB .NET	4	22nd Jun 2006 09:33 AM
Oracle transaction rollback problem	dnhelp	Microsoft ADO .NET	1	25th Jun 2005 06:17 PM
Oracle Transaction error	=?Utf-8?B?SmFzb24=?=	Microsoft Dot NET Framework	1	18th Mar 2005 12:38 PM
Read-only transaction in Oracle	Maxim Maslov	Microsoft ADO .NET	4	3rd Dec 2004 08:08 AM
Getting an OLEDB Transaction for Oracle 7.2	Sara	Microsoft Dot NET	0	29th Jul 2004 11:07 PM