Just say
commit;
insert...
commit;
Jim
"Raheen Ballard" <rballard34_at_home.com> wrote in message
news:B70N7.264217$5A3.101005338_at_news1.rdc2.pa.home.com...
> Hi!
> As stated, I'm using the Personal edition of Oracle 8i. I'm using
Sam's
> SQL in 21 Days and when I enter the following statement from the book:
> "
> SET TRANSACTION;
> INSERT INTO CUSTOMERS
> VALUES('JOHN MACDOWELL','2000 LAKE LUNGE ROAD','CHICAGO','IL',42854,7);
> COMMIT;
> "
> I get the following error: "ERROR at line 1:ORA-00900: invalid SQL
> statement"
>
> I looked in another book, and saw that it appended "read only" after the
> "set transaction", and that line alone ran, but when I went to insert, of
> course I get an error stating that it's a read-only transaction and it
> won't let me update...can anyone help me w/the correct syntax? Thx!
>
>
Received on Wed Nov 28 2001 - 08:33:36 CST
