RE: Simple PL/SQL output question
Date: Wed, 9 Mar 2011 17:45:13 +0100
Message-ID: <DC068219E0EBA54082D33E4812CC5ED13C37CC5ABB_at_ing.com>
SET SERVEROUTPUT ON
works fine with my TOAD (10.6.1.3)
and the script works fine run in SQL*Plus (10.2.0.3.0) from TOAD
(Oracle 10.2.0.4 on Solaris)
Craig
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Dennis Williams Sent: 09 March 2011 17:30
To: Michael Moore
Cc: oracle-l_at_freelists.org
Subject: Re: Simple PL/SQL output question
Thanks Mike. Here is an abbreviated version of my script.
SET ECHO OFF
SET VERIFY OFF
SET SERVEROUTPUT ON
DECLARE
-- local variables and cursors
BEGIN
-- PL/SQL code
DBMS_OUTPUT.PUT('------------------------------------------');
DBMS_OUTPUT.NEW_LINE;
DBMS_OUTPUT.PUT_LINE('QH Source Lot ID = '||LotRec.AppID);
DBMS_OUTPUT.PUT_LINE('QH State = '||LotRec.State);
END;
/
On Wed, Mar 9, 2011 at 10:21 AM, Michael Moore <michaeljmoore_at_gmail.com<mailto:michaeljmoore_at_gmail.com>> wrote: It would help to SEE what you did.
Mike
On Wed, Mar 9, 2011 at 7:43 AM, Dennis Williams <oracledba.williams_at_gmail.com<mailto:oracledba.williams_at_gmail.com>> 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
ATTENTION:
The information in this electronic mail message is private and confidential, and only intended for the addressee. Should you receive this message by mistake, you are hereby notified that any disclosure, reproduction, distribution or use of this message is strictly prohibited. Please inform the sender by reply transmission and delete the message without copying or opening it.
Messages and attachments are scanned for all viruses known. If this message contains password-protected attachments, the files have NOT been scanned for viruses by the ING mail domain. Always scan attachments before opening them.
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Mar 09 2011 - 10:45:13 CST