ANNOUNCEMENT: community.oracle.com is currently Read only due to planned maintenance until 02:30 AM PST, 28-March-2015. Any changes made during Read only mode will be lost and will need to be re-entered when the application is back read/write.
Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
Database Application Development
Windows and .NET
Oracle Developer Tools for Visual Studio
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Jul 22, 2012 6:00 AM by
I want to ecute multi stored procedure in one transaction..
Jul 22, 2012 6:00 AM
In one transaction, can I excute multi stored procedure?
if sp2 fire exception then sp1 should be rollbacked?
OracleConnection conn = null;
OracleTransaction tran = null;
OracleCommand cmd = null;
conn = new OracleConnection(ConnectionString);
cmd = new OracleCommand();
tran = conn.BeginTransaction();
cmd.CommandText = "sp_Insert";
int retval = cmd.ExecuteNonQuery();
// sp 2
cmd.CommandText = "sp_update";
retval = cmd.ExecuteNonQuery();
catch (Exception ex)
This content has been marked as final.
Show 0 replies