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.

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 14 06:34:13 CDT 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.