Home » RDBMS Server » Server Administration » Re: prompting in PL
Re: prompting in PL [message #370292] Wed, 04 August 1999 11:11
Chris Hunt
Messages: 27
Registered: March 1999
Junior Member
I don't think this is possible in ordinary PL/SQL (i.e. as run from SQL*Plus). SQL*Plus batches up a whole PL/SQL block, sends it to the database and doesn't get control back till the procedure finishes.

For the same reason, if you use DBMS_OUTPUT to display your progress, nothing is output until the process finishes.

Previous Topic: Re: adding new rows only on changes?: proper sql statement
Next Topic: Re: ORDER BY clause - easy question
Goto Forum:

Current Time: Wed Oct 28 07:23:23 CDT 2020