Oracle and .NET

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

« Problem with oracle transaction | SqlParameter with size=0 »

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
Problem with oracle database connection using Oracle Instant Clien	PIYUSH	Microsoft Outlook Program Addins	0	5th Jun 2008 11:11 AM
Accessing arrays returned by Oracle Stored Procedures using Oracle	=?Utf-8?B?S3VtYXIuQS5QLlA=?=	Microsoft Dot NET Framework	0	18th Nov 2007 05:06 PM
Sequence.nextval numeric type in Oracle 10g differs from Oracle 8i when using MS OleDb provider	alasdair.johnson@gmail.com	Microsoft ASP .NET	0	27th Apr 2007 06:57 PM
Pass an array to an Oracle stored procedure using Microsoft's client for Oracle	michelle.m.talt@gmail.com	Microsoft ADO .NET	0	16th Jun 2006 05:34 PM
How to connect oracle 8i when oracle 8i and oracle 9i installed in one system	Prasad	Microsoft ADO .NET	0	1st Dec 2003 11:23 AM