Re: Script freezes before first line

instead of doing inserts to debug/monitor the progress, maybe the DBMS_APPLICATION_INFO package will help you. this way it won't interfere with your transaction scope.

joemellors_at_aol.com (Joe Mellors) wrote in message news:<53566469.0203210624.222650fc_at_posting.google.com>...
> srivenu_at_hotmail.com (srivenu) wrote in message news:<1a68177.0203192118.59ce55af_at_posting.google.com>...
> > Autocommit in SQL*PLUS means that SQL*PLUS issues a commit after the
> > execution after each SQL statement.
> > The entire PL/SQL block is considered as a single SQL statement and it
> > is sent at one time by SQL*PLUS to the database.
> > So SQL*PLUS issues a commit only after the excution of the entire
> > PL/SQL block by the database.
>
> Srivenu,
>
> This dawned upon me later. I knew that you couldn't use autocommit in
> a stored procedure and thought this might have been a way around it so
> as it happened my procedure was doing its job but just taking forever.
> Thanks a lot, Joe
Received on Thu Mar 21 2002 - 19:32:48 CET