Re: SQL> SET TRANSACTION; ORA-00900: invalid SQL statement??
Date: Sat, 28 Apr 2001 13:43:10 GMT
Message-ID: <ONzG6.71092$xN4.5136261_at_news1.sttls1.wa.home.com>
commit;
starts or ends a transaction
so just use commit;
Jim
"Unknown User" <unknown_at_unknown.com> wrote in message
news: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 - 15:43:10 CEST