Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: DBMS_OUTPUT.PUT_LINE .. newbie question
Dug Birdzell wrote:
>
> Hi everybody:
>
> I am having some trouble getting DBMS_OUTPUT.PUT_LINE to display output
snip..
> I wonder why I don't see the 2 lines of output. Any advice is
> appreciated...thanks!
Dug,
You need to type the following command every time you start a new session in SQL*Plus:
SET SERVEROUTPUT ON SIZE 1000000 Better yet, put this line in you login.sql file.
Good Luck,
Rob Verlander Received on Tue Jun 10 1997 - 00:00:00 CDT