Phil Culberson wrote:
> I ran a couple of tests against an Oracle 7.3.4 database.
Thanks!
> I inserted a row into a table, then immediately typed exit. The insert was
> committed automatically.
>
> I also did an insert and then killed SQL*Plus with a SIGKILL from another
> window. The transaction was NOT committed.
>
> So, by default, SQL*Plus starts up with option AUTOCOMMIT set to OFF, and if
> one performs some INSERT/UPDATE/DELETE, an EXIT will in fact commit the
> transaction for you. If the session is abnormally terminated, the
> transaction is NOT committed.
There must be something I have in common with the Oracle
engineers (the ones who design and code, not the management
and sales staff). What else could cause that I expected
exactly that behaviour?
> Hope this helps.
Did.
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#========================================= [EMAIL PROTECTED] (Jan Wieck) #
