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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Autocommit

Re: Autocommit

From: Thomas J. Kyte <tkyte_at_us.oracle.com>
Date: 2000/04/24
Message-ID: <8e1c0f$83f$1@nnrp1.deja.com>#1/1

In article <8e17ks$430$1_at_nnrp1.deja.com>,   jeanch_at_my-deja.com wrote:
> In article <8WLM4.907$Q_2.213055_at_carnaval.risq.qc.ca>,
> "Mr.X" <pandore_at_itr.qc.ca> wrote:
> > If there is no autocommit, why do when I insert data with a stored
 procedure
> > without commiting, the data is available to other connections
> > ???????????????
> I am not 100% sure about this but I was told a while
> ago that if PL/SQL is using dynamic SQL (DBMS_SQL.xxx)
> then an auto-commit is executed for you by oracle.
>
> 1st do you use DBMS_SQL.xx at all
> 2nd can anybody confirm or unconfirm this
>
> Cheers
> JC
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

I can confirm 100% that

--
Thomas Kyte                              tkyte_at_us.oracle.com
Oracle Service Industries
http://osi.oracle.com/~tkyte/index.html
--
Opinions are mine and do not necessarily reflect those of Oracle Corp


Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Mon Apr 24 2000 - 00:00:00 CDT

Original text of this message

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