Re: Script freezes before first line

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 - 15:24:06 CET