Re: [URGENT] autocommit

From: Matt B. <mcb_at_fightspam.sd.znet.com>
Date: 2000/08/12
Message-ID: <spbaqrcn4t125@corp.supernews.com>#1/1

"Markus Schwabe" <mschwabe_at_gscout.de> wrote in message news:8n16eu$2q1e$1_at_koroth.muc.eurocyber.net...
> AFAIK you can set autocommit only in SQL*Plus and only for this session.
> At the SQL-Prompt, type:
> "set autocommit on"

You can do it for all SQL*Plus sessions but offhand I don't remember where it is - it's either in a database file, like init.ora, or in a setup file for SQL*Plus. I know all our sessions that we have always have this turned on automatically for us.

-Matt Received on Sat Aug 12 2000 - 00:00:00 CDT