Re: Print in PL/SQL
From: Daniel A. Morgan <damorgan_at_exesolutions.com>
Date: Fri, 18 Jan 2002 17:30:46 +0000
Message-ID: <3C485BC6.363DDBAB_at_exesolutions.com>
Date: Fri, 18 Jan 2002 17:30:46 +0000
Message-ID: <3C485BC6.363DDBAB_at_exesolutions.com>
Oracle doesn't print. SQL*Plus prints. If you want to send something from the database to SQL*Plus use DBMS_OUTPUT as others have indicated. But in no manner should you interpret this as the database printing anything.
Daniel Morgan
Stjepan Brbot wrote:
> 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 - 18:30:46 CET