Re: Print in PL/SQL/ help

you can do it using dbms package.

set serveroutput on
BEGIN

      dbms_output.enable(10000);
      loop
         exit when i < 10;
         i := i + 1;
         dbms_output.put_line('COUNT : '||to_char(i));
      END LOOP;

but, It's not display until PL/SQL completed.

Pachao ÀÌ(°¡) <1998082601592100.VAA01047_at_ladder03.news.aol.com> ¸Þ½ÃÁö¿¡¼­ ÀÛ¼ºÇÏ¿´½À´Ï´Ù...
>How to print out values that are not inserted into table ? For example,
>if I have a loop, and I have a loop counter, how do I print out
>the value of the counter on screen? THanks in advance. -pat
>
Received on Tue Aug 25 1998 - 23:43:15 CDT