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>


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> 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;


SQL> set transaction;
set transaction

              *
ERROR at line 1:
ORA-00900: invalid SQL statement Received on Sat Apr 28 2001 - 11:02:13 CEST

Original text of this message