Re: How to Display mesg. during SQLPlus login?

In article <6a530p$1it_at_news.Hawaii.Edu>,   kittu_at_Hawaii.Edu (Chakravarthy KM Nalamotu) wrote:
>
> Hello Oracle Users,
> How would I display a message when a client user
> connects to the database, something similar to
> glogin.sql, but specific to a database.
> Thank you for your replies.
> Kittu.

Hi,

One possible approach: (a) create a database procedure which checks for the instance name from v$instance and displays a corresponding message. (b) execute the procedure from login.sql (if using sqlplus) on the client m/c or execute it from the client application.

I hope this helps.
Ajit

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet