Re: set command in PL-SQL

From: Walter T Rejuney <BlueSax_at_Unforgetable.com>
Date: Thu, 07 Sep 2000 21:04:53 -0400
Message-ID: <39B83B35.D327CC7D@Unforgetable.com>

Emre Akbag wrote:

> How can I run "set serveroutput on" command in a stored procedure?
> Or where can I find the parameter file for SQL-Plus, where I can set these
> kind of parameters globally?
> I hope, there is such a file.
>
> --
> Emre AKBAG
>
> Data Mining, Imaging & Visualization Dept.
> Siemens Corporate Research
>
> Ph: (609) 734.6500 ext. 2260 Fax: (609) 734.6565
> E-mail: akbag_at_scr.siemens.com
>
> Siemens Corporate Research,
> 755 College Rd East,
> Princeton, NJ 08540

You can set "set serverout on" globally in $ORACLE_HOME/sqlplus/admin/glogin.sql. Otherwise you can set it in login.sql in your home directory or in any path that you point to with SQL_PATH. Received on Thu Sep 07 2000 - 20:04:53 CDT