Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How do i print to the screen in SQL plus
Don't forget to set in your SQLPLUS option:
set serveroutput on [size 1000000]
[optional]
Tina Tran wrote in message <01bcd693$d45f8e60$2aaeb6cc_at_dino>...
>Use dbms_output package which is located in
>$ORACLE_HOME/rdbms/admin/dbmsotpt.sql
>
>Casper Thrane <ct_at_benau.dk> wrote in article
><343EB4F6.5A51A79F_at_benau.dk>...
>> How do I print to the screen in SQL Plus from a procedure.
>> I can't use "prompt" so what can I do?
>> --
>> Casper Thrane
>> Systemdeveloper
>> Benau A/S
>>
Received on Tue Oct 14 1997 - 00:00:00 CDT
![]() |
![]() |