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

From: Andy <as.no.spam.stedat_at_gmx.net>
Date: Wed, 28 Nov 2001 10:45:48 GMT
Message-ID: <3c04bfde.15386855@by-news.bayer-ag.com>

On Wed, 28 Nov 2001 07:12:33 GMT, "Raheen Ballard" <rballard34_at_home.com> wrote:

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

Hi,

seems as if there´s something missing. Oracle normally doesn´t need such transaction statement because a transaction ist started implicit when you do an insert.

Possibly they wanted the transaction to use a dedicated rollback segment? Then it would be
set transaction use rollback segment monster; insert ...

hth
Andy Received on Wed Nov 28 2001 - 04:45:48 CST