Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Autocommit
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