Re: How do i print to the screen in SQL plus

From: replace this with _at_ <_at_)xs4all.nl>
Date: 1997/10/11
Message-ID: <343fb09d.6724619@news.xs4all.nl>#1/1

On Sat, 11 Oct 1997 00:06:30 +0100, Casper Thrane <ct_at_benau.dk> wrote:

>How do I print to the screen in SQL Plus from a procedure.
>I can't use "prompt" so what can I do?

All output is directed to the screen, so what's the problem? In PL/SQL you can make use of the DBMS_OUTPUT package in the following way:

SET SERVEROUTPUT ON
BEGIN
DBMS_OUTPUT.PUT_LINE('Hello world...'); END; Maybe you should do the following:

SET TERMOUT ON I can't think of anything else...

Received on Sat Oct 11 1997 - 00:00:00 CDT