Re: Autocommit

From: <jeanch_at_my-deja.com>
Date: 2000/04/24
Message-ID: <8e17ks$430$1@nnrp1.deja.com>#1/1

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. Received on Mon Apr 24 2000 - 00:00:00 CDT