Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Newbie DBMS_OUTPUT problem

Re: Newbie DBMS_OUTPUT problem

From: Vijay Darekar <vijayd_at_worldnet.att.net>
Date: 1997/07/16
Message-ID: <33CD75D6.4290@worldnet.att.net>#1/1

Richard E. Isler wrote:
>
> Heres the problem:
> I am writing this PL/SQL program that uses DBMS_OUTPUT.PUT_LINE to write
> a header line, some report lines within a cursor FOR loop, and a footer
> line e.g. DBMS_OUTPUT.PUT_LINE('End of Report');
>
> I have a DBMS_OUTPUT.ENABLE statement right after the BEGIN statement,
> and a DBMS_OUTPUT.DISABLE call just before the final END; statement. The
> procedure compiles with no errors and all I get is the message
> 'Procedure created'.
>
> Any suggestions? Thanks in advance for your help.
>
> --
> Richard E. Isler | "Give a man a Twinkie and you feed him
> | for a day,
> isler_at_sandia.gov | teach him to shoplift Twinkies and you
> | feed him for life."

include
"set serveroutput on size 100000"
before at the start; Received on Wed Jul 16 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US