Re: Default serveroutput

In article <964803984.20034.1.pluto.d4ee154e_at_news.demon.nl>,   "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:
> Create a file called login.sql in your current working directory or
 use
> %ORACLE_HOME%\dbs as the directory.
> All statements you want to be executed on login (this will apply to
 the
> *first* login only) will be executed automatically.
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> "Manjunath Aravind" <maravind_at_hns.com> wrote in message
> news:Pine.GSO.4.21.0007281202081.21722-100000_at_swtsun8.hns.com...
> >
> > Whenever I start a SQLPlus session, the default value of
> > serveroutput is OFF. How do I ensure that this default
> > value is ON ? I don't want to do a 'set serveroutput on'
> > everytime I start a session.
> >
> > Also, executing dbms_output.enable(10000) within my pl/sql code
> > does NOT actually turn serverouput to ON for the current session.
> > Is there any other way, that I can turn serverouput to ON for
> > my session ?
> >
> >
> > TIA,
> > -Manju
> >
>
>

Yet another option is to use the $ORACLE_HOME/sqlplus/glogin.sql file and add the 'set serveroutput on' there. This will apply to every login you make to the database, but will affect every session that connects to the instance.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com http://www.deja.com/
Before you buy.