Re: Autocommit

If there is no autocommit, why do when I insert data with a stored procedure without commiting, the data is available to other connections ???????????????

Thomas J. Kyte <tkyte_at_us.oracle.com> a écrit dans le message : 8dvmn4$h01$1_at_nnrp1.deja.com...
> In article <NptM4.838$Q_2.170979_at_carnaval.risq.qc.ca>,
> "Mr.X" <pandore_at_itr.qc.ca> wrote:
> > How can I disable the autocommit that is the default option in PL/SQL
 Oracle
> > for a stored procedure ?
> >
>
> there is no such feature. plsql does not ever "autocommit".
>
> various languages (microsofts api's almost always do due to their
> locking mechanims) autocommit (eg: ODBC autocommits, JDBC autocommits).
>
> PLSQL does not autocommit.
>
> > I want to test the concurence and without disable this option a
 concurent
> > stored procedure wait without sending an error message. I absolutly
 want
> > this error message to threat it as a normal error.
> >
>
> don't understand that statement at all.
>
> > P.S. : These are stored procedure whith formatted with HTML.
> >
> > Pat
> >
> >
>
> --
> 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 Sun Apr 23 2000 - 00:00:00 CDT