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

Home -> Community -> Usenet -> c.d.o.misc -> Re: No output w. DBMS_OUTPUT.PUT_LINE (within SQL*Plus)

Re: No output w. DBMS_OUTPUT.PUT_LINE (within SQL*Plus)

From: Frank Diedrich <fdi_at_gmx.de>
Date: Mon, 28 Oct 2002 20:23:45 +0100
Message-ID: <apk30q$g20$07$1@news.t-online.com>


Fred Zimmerman wrote:
> My script below is NOT outputting any text
> to SQL*Plus, w. DBMS_OUTPUT.PUT_LINE w. NO
> errors either.
>
> What is the problem?
>

Hi Fred,

have you done a "set serveroutput on size n" (n=buffersize in bytes, default 2000, maximum 1000000) in SQL*Plus before starting your script?

I think that will help you to get some output.

Greetings,

Frank Received on Mon Oct 28 2002 - 13:23:45 CST

Original text of this message

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