Re: Default serveroutput

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
>
Received on Fri Jul 28 2000 - 00:00:00 CDT