SQL> SET TRANSACTION; ORA-00900: invalid SQL statement??
From: Unknown User <unknown_at_unknown.com>
Date: Sat, 28 Apr 2001 02:02:13 -0700
Message-ID: <5i1letckk0fgndqclpmq8d0s0b9lh3ml4q_at_4ax.com>
Date: Sat, 28 Apr 2001 02:02:13 -0700
Message-ID: <5i1letckk0fgndqclpmq8d0s0b9lh3ml4q_at_4ax.com>
Hi,
I am using Personal Oracle 8i 8.1.7 on Win2000.
I am trying to execute a simple transaction as follows and receiving the error message.
What is the proper syntax??
SQL> set transaction;
*
SQL> SET TRANSACTION;
SQL> UPDATE BALANCES SET CURR_BAL = 25000 WHERE ACCOUNT_ID = 5;
SQL> SAVEPOINT s_balances;
SQL> DELETE FROM BALANCES WHERE ACCOUNT_ID = 5;
SQL> ROLLBACK TO SAVEPOINT s_balances;
SQL> ROLLBACK;
set transaction
ORA-00900: invalid SQL statement
Received on Sat Apr 28 2001 - 11:02:13 CEST