Oracle 8i Personal......need HELP w/ Transactions!!!

From: Raheen Ballard <rballard34_at_home.com>
Date: Wed, 28 Nov 2001 07:12:33 GMT
Message-ID: <B70N7.264217$5A3.101005338@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 - 01:12:33 CST