Re: SET command variables across sessions

In article <3A0AE2A2.815EE177_at_127.0.0.1>,   jr <webmaster_at_127.0.0.1> wrote:
> Hi,
>
> when setting SET command variables (e.g. SET SQLPROMPT "MY_PROMPT")
 from
> the sqlplus command line I loose this information when I exit sqlplus.
> Is there a way to keep my SET settings across sessions?
>
> One idea would be to replace the sqlplus binary with a script that
> starts the original sqlplus and calls a sql script to set these
> environment variables.
>
> Any other ideas?
> Thanks,
> jr
>
>

Sure,
Before you start replacing the sqlplus binary, you should read the sqlplus manual where it is all documented. You need to configure a file called login.sql (local settings) and/or glogin.sql (global settings). They are automatically executed upon startup of sqlplus. The idea to replace the sqlplus binary is, sorry to say so, really stupid.

Hth,

--
Sybrand Bakker, Oracle DBA

All standard disclaimers apply
------------------------------------------------------------------------


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