RE: Simple? PL/SQL query

From: Uma Sankara_Sivadanam <UmaSankara_Sivadanam_at_satyam.com>
Date: Mon, 4 Sep 2000 19:46:36 +0530
Message-Id: <10609.116154@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C0167A.BCA02C90
Content-Type: text/plain

Hi Sean,

The code is working fine.The only possibility could be YOU MIGHT HAVE NOT SET THE SQL*PLUS ENVIRONMENT OPTION "SET SERVEROUTPUT ON" Try setting the option at the sql prompt like this :

SQL>set serveroutput on;

Then run your PL/SQL Code.

Uma Shankar

> ----------
> From: O'Neill, Sean[SMTP:Sean.ONeill_at_organon.ie]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Monday, September 04, 2000 8:41 AM
> 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).
>

------_=_NextPart_001_01C0167A.BCA02C90
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =

charset=3Dus-ascii">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12">

<TITLE>RE: Simple? PL/SQL query</TITLE>
</HEAD>
<BODY>

Hi Sean,

The code is working = fine.The only possibility could be YOU MIGHT HAVE NOT SET THE = SQL*PLUS  ENVIRONMENT OPTION  "SET SERVEROUTPUT = ON"

Try setting the = option at the sql prompt like this :

SQL>set = serveroutput on;

Then run your PL/SQL = Code.

<P><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Uma Shankar</FONT>
</P>
<BR>
<UL>
<P><FONT SIZE=3D1 FACE=3D"MS Sans Serif">----------</FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"MS Sans Serif">From:</FONT></B> &nbsp; =
<FONT SIZE=3D1 FACE=3D"MS Sans Serif">O'Neill, =

Sean[SMTP:Sean.ONeill_at_organon.ie] Reply To: =       ORACLE-L_at_fatcity.com
 Sent:   = Monday, September 04, 2000 8:41 = AM
 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);

<P><FONT SIZE=3D2 FACE=3D"Arial">BEGIN</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;&nbsp;&nbsp; SELECT name&nbsp; =
</FONT>
<BR><FONT SIZE=3D2 =

FACE=3D"Arial">        INTO = db_name
         FROM v$database;
         = DBMS_OUTPUT.PUT_LINE
         ( 'Database = name is ' || db_name );
 END;

<P><FONT SIZE=3D2 FACE=3D"Arial">/</FONT>
</P>
<BR>

Sean :)

######   ######  = ######  ###### 
 #    #   = #    #  #    #  = #    #  Rookie ####     = #    #  ######  ######  Data #   #    = #    #  #    #  = #    #  Base #    #  = #######  ######  #    #  = Adminstrator

<BR><FONT SIZE=3D2 FACE=3D"Arial">-------------------------------- =

------------ 
 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

<P><FONT SIZE=3D2 FACE=3D"Arial">-- </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Author: O'Neill, Sean</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp; 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
 <FONT SIZE=3D2 =

FACE=3D"Arial">---------------------------------------------------------=

-----------
 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 = Received on Mon Sep 04 2000 - 09:16:36 CDT