Re: Simple PL/SQL output question
- From: Kish Patchava <kish.patchava@xxxxxxxxx>
- To: oracledba.williams@xxxxxxxxx
- Date: Wed, 9 Mar 2011 11:11:04 -0500
I think it is little bit different in TOAD. You have to manually enable dbms
output in TOAD prior to running the script.
On Wed, Mar 9, 2011 at 11:05 AM, Dennis Williams <
oracledba.williams@xxxxxxxxx> wrote:
> I enabled output with
>
> SET SERVEROUTPUT ON
>
> Oh yeah, and this is Oracle 10.2.0.4 on the server, using an 11g client
> SQL*Plus.
>
> On Wed, Mar 9, 2011 at 9:47 AM, Niall Litchfield <
> niall.litchfield@xxxxxxxxx> wrote:
>
>> How did you enable output?
>>
>> On 9 Mar 2011 15:45, "Dennis Williams" <oracledba.williams@xxxxxxxxx>
>> 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
>>
>>
>
Other related posts:
