Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle SQL Worksheet trouble

Re: Oracle SQL Worksheet trouble

From: Alexander G Bozhik <sander_at_isd.donin.com>
Date: Mon, 17 May 1999 10:15:13 +0300
Message-ID: <7hofnm$832$1@isd.donin.com>


Hi,
you are completly right. Very likely I have been deluded by Worksheet's automatic commit on exit.
Thanks you so much for your reply.
SY,
Alexander G Bozhik.

Chris Weiss wrote in message <7hhed5$leq$1_at_msunews.cl.msu.edu>...
>From what I can tell, SQL Worksheet does not commit every statement without
>an explicit commit. However, unless you perform an explicit rollback it
>performs an automatic commit on exit.
>
>If you have DML statements you do not want to be committed, then you must
>explicitly roll them back.
>
>I use SQL Worksheet for the majority of my data analysis and development,
>and I have never experienced the problem you have described. Rollback
>statements always succeed within the same session.
>
>Christopjher Weiss
>Professional Services Staff
>Compuware Corporation
>
>
>Alexander G Bozhik wrote in message <7hhb9m$3v9$1_at_isd.donin.com>...
>>Hi all,
>>I 've got some little trouble with Oracle SQL Worksheet. The matter is
>>Worksheet commits every SQL statement automatically. Is there any ability
>to
>>switch this option off? I haven't found any appropriate information in OEM
>>manuals.
>>SY,
>>Alexander G Bozhik.
>>
>>
>>
>>
>
>
Received on Mon May 17 1999 - 02:15:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US