Re: Simple PL/SQL output question

From: Subodh Deshpande <>
Date: Thu, 10 Mar 2011 09:38:31 +0530
Message-ID: <>


from the TNS error it seems its network issue..and not related to dbms..output...

to get output in some file you should use spool

On 9 March 2011 21:13, Dennis Williams <> wrote:

> List,
> I recently wrote a SQL script containing a PL/SQL anonymous block. I used
> DBMS_OUTPUT to sent results to the screen. This worked fine when I copied
> and pasted the script into a SQL*Plus session. However, when I just hit "r"
> to rerun the script, I noticed that it produced no output. Later I passed
> this to a user who ran it using Toad and got no output. Can anybody tell me
> what (isn't) going on?
> The reason I used PL/SQL in this manner is that I needed more logic than
> SQL itself could provide. In our environment, creating database objects
> requires a lot of red tape, but we have a read-only account that can be used
> to run queries or ad-hoc scripts.
> Thanks,
> Dennis Williams


Received on Wed Mar 09 2011 - 22:08:31 CST

Original text of this message