Message-Id: <10609.116156@fatcity.com> From: Jahangir_Shaik Date: Mon, 4 Sep 2000 19:49:18 +0530 Subject: RE: Simple? PL/SQL query 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_01C0167B.282E9420 Content-Type: text/plain Hello, We should mention SET SERVEROUTPUT ON Before executing this PL/SQL. Try this and it should work Shaik.Jahangir Basha GE GDC Satyam Computer Services Limited Tel : +91 40 7846101 Extn 5650 E mail: jahangir_shaik@hht.satyam.com > ---------- > From: O'Neill, Sean[SMTP:Sean.ONeill@organon.ie] > Reply To: ORACLE-L@fatcity.com > Sent: Monday, September 04, 2000 8:11 PM > 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@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@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@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_01C0167B.282E9420 Content-Type: text/html Content-Transfer-Encoding: quoted-printable RE: Simple? PL/SQL query

Hello,
We should mention = SET SERVEROUTPUT ON  Before executing this PL/SQL.
Try this and it = should work

Shaik.Jahangir Basha
GE = GDC

Satyam = Computer Services Limited
Tel =     : +91 40 7846101 Extn 5650
E mail: = jahangir_shaik@hht.satyam.com