Re: Print in PL/SQL
Date: Fri, 18 Jan 2002 21:17:21 GMT
Message-ID: <Bh028.637$Xw4.319606_at_news1.news.adelphia.net>
The simplest message would be
dbms_output.put_line( 'hello world' );
and you have to remember to do 'set serveroutput on' in sqlplus before calling that proc.
As far as I know, or have seen on these newsgroups, there is no simple way to print a 'select *', you have to specify the columns in the dbms_output.
"Stjepan Brbot" <Stjepan.Brbot_at_ZG.HiNet.HR> wrote in message
news:a2a2gb$e91j$1_at_as201.hinet.hr...
> How to print the simplest message in PL/SQL? I.e. how to print on screen
> all rows of cursor when you execute this procedure?
>
> PROCEDURE ABC IS
> CURSOR curABC IS SELECT * FROM tableA;
> BEGIN
> FOR row IN curABC LOOP
>
> ??? print row ???
>
> END LOOP;
> END;
>
> --
>
> Stjepan Brbot <Stjepan.Brbot_at_ZG.HiNet.HR>
>
>
>
Received on Fri Jan 18 2002 - 22:17:21 CET