Re: SET TRANSACTION statement

From: Joel R. Kallman <jkallman_at_us.oracle.com>
Date: Mon, 23 Nov 1998 12:30:00 GMT
Message-ID: <365a5477.2753098@newshost.us.oracle.com>

On Sat, 21 Nov 1998 12:44:16 +0530, Rajesh Bhave <rajeshb_at_india.hp.com> wrote:

>Hi
>
>Can we have 2 SET TRANSACTION statements for single transaction. If
>yes, then what happens to 1st statement.

You cannot specify multiple SET TRANSACTION statements for a single transaction. A SET TRANSACTION statement can only be issued as the first statement of a transaction. See the "SET TRANSACTION" description in the Oracle8 Server SQL Reference manual.

---

SQL> set transaction read only;

Transaction set.

SQL> update a set col2 = 1 where col1 = 1; update a set col2 = 1 where col1 = 1

       *
ERROR at line 1:
ORA-01456: may not perform insert/delete/update operation inside a READ ONLY
transaction

SQL> set transaction read write;
set transaction read write
*
ERROR at line 1:
ORA-01453: SET TRANSACTION must be first statement of transaction

---

>
>Rajesh
>

Thanks!

Joel

Joel R. Kallman Oracle Government, Education, & Health

Columbus, OH                             http://govt.us.oracle.com

jkallman@us.oracle.com                   http://www.oracle.com

---

The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation. Received on Mon Nov 23 1998 - 06:30:00 CST