Re: Newbie DBMS_OUTPUT problem

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."

Hi,
you can see DBMS_OUTPUT message only if you EXECUTE the procedure.

-- 
  AMARENDRA B NETTEM ( http://www.iit.edu/~nettama)
  Certified Oracle DBA
  WHITTMAN-HART Inc.
  CHICAGO.