This has probably already been answered (i'm a little
behind because of the holiday).
SET SERVEROUTPUT ON in your SQL*Plus and then run the
code.
Larry Hahn
Milwaukee, WI
- "O'Neill, Sean" <Sean.ONeill_at_organon.ie> wrote:
> 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).
Do You Yahoo!?
Yahoo! Mail - Free email you can access from anywhere!
Received on Wed Sep 06 2000 - 05:59:46 CDT
