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 -> Newbie DBMS_OUTPUT problem

Newbie DBMS_OUTPUT problem

From: Richard E. Isler <isler_at_sandia.gov>
Date: 1997/07/16
Message-ID: <33CCFBAD.1EB@sandia.gov>#1/1

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."
Received on Wed Jul 16 1997 - 00:00:00 CDT

Original text of this message

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