Re: Screen output for PLSQL script under SQL+

set echo off
rem SQL*Plus script containing PL/SQL script; exec from sqlplus as _at_script set serveroutput on
declare
variables go here
begin
  some code ...
  dbms_output.put_line('Number of rows processed: '||v_counter); end;
/
rem You need the slash to execute the pl/sql

I hope this answers your question.

mrittman_at_my-dejanews.com wrote in article <7180th$cpo$1_at_nnrp1.dejanews.com>...
> Does anyone know how to make a message appear on the screen (such as
'number
> of records processed = ' || rec_num) using a PL/SQL program under
SQLPlus?
>
> I've tried using 'prompt' but it won't take any argument after 'prompt'.
I
> would like to make the message include a variable (in this case, the
number
> of records counted).
>
> Any help woud be appreciated.
>
> Many thanks
>
> Mark
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
 

>
Received on Thu Oct 29 1998 - 20:04:48 CET