RE: Simple? PL/SQL query [SOLUTION]

Reply,

Thanx. Did the trick(?)

• Sean

-----Original Message-----
From: ddorr.cs_at_clearstream.com [mailto:ddorr.cs_at_clearstream.com] Sent: Monday, September 04, 2000 15:26
To: ORACLE-L_at_fatcity.com
Cc: Sean.ONeill_at_organon.ie
Subject: RE: Simple? PL/SQL query

SET SERVEROUTPUT ON in your SQL*Plus session should do the trick.

> ----------
> From: O'Neill, Sean[SMTP:Sean.ONeill_at_organon.ie]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Monday, September 04, 2000 16:41
> To: Multiple recipients of list ORACLE-L
> Subject: Simple? PL/SQL query
>
> I'm new to PL/SQL and I am trying to use same to send output of name from
> v$database to screen. The code I'm using is as below but the output is
> not
> being sent to screen and I can't figure why not. The code is replying
> with
> "PL/SQL procedure successfully completed." in SQL*Plus. Maybe this is not
> the most appropriate way to approach this requirement and alternative
> method
> inputs are welcome too!. Are there any other ways to send output to
> screen
> aside from DBMS_OUTPUT?
>
> DECLARE
>
> db_name varchar2(20);
>
> BEGIN
> SELECT name
> INTO db_name
> FROM v$database;
> DBMS_OUTPUT.PUT_LINE
> ( 'Database name is ' || db_name );
> END;
>
> /
>
>
> Sean :)
>
> ###### ###### ###### ######
> # # # # # # # # Rookie
> #### # # ###### ###### Data
> # # # # # # # # Base
> # # ####### ###### # # Adminstrator
> -------------------------------- ------------
> Organon (Ireland) Ltd.
> E-mail: sean.oneill_at_organon.ie [subscribed: Digest Mode]
>
> The only man who never makes a mistake is the man who never does anything.
> - Theodore Roosevelt
>
> --
> Author: O'Neill, Sean
> INET: Sean.ONeill_at_organon.ie
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Mon Sep 04 2000 - 09:28:38 CDT