Re: Script freezes before first line
From: srivenu <srivenu_at_hotmail.com>
Date: 19 Mar 2002 21:18:14 -0800
Message-ID: <1a68177.0203192118.59ce55af_at_posting.google.com>
Date: 19 Mar 2002 21:18:14 -0800
Message-ID: <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.
You will see the results in an other session only after the entire
PL/SQL block is executed and the data is committed.
Hope this helps.
Received on Wed Mar 20 2002 - 06:18:14 CET