Re: Oracle SQL Worksheet trouble

From: Chris Weiss <weisschr_at_pilot.msu.edu>
Date: Fri, 14 May 1999 11:13:46 -0400
Message-ID: <7hhed5$leq$1@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 Fri May 14 1999 - 10:13:46 CDT