Re: Simple? PL/SQL query

If you are running this in SQL*Plus then issue set serveroutput on before executing your code.

Allan
----- Original Message -----
From: "O'Neill, Sean" <Sean.ONeill_at_organon.ie> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Monday, September 04, 2000 9:41 AM 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 Tue Sep 05 2000 - 07:54:45 CDT