Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Simple? PL/SQL query
Hi,
SET SEVEROUTPUT ON SIZE 1000000 U could use this in all your plsqls using dbms_output to avoid "Buffer overflow" error. Again, there is limit to the details u can see using dbms_output statement.
Regards
Rajagopal Venkataramany
On Mon, 04 Sep 2000 07:30:19 -0800, ORACLE-L_at_fatcity.com wrote:
> 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).
> >
> --
> Author:
> INET: ddorr.cs_at_clearstream.com
>
> 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).
Regards
Rajagopal Venkataramany
![]() |
![]() |