Re: How to show environment in Forms?
Date: Tue, 24 Oct 2000 17:35:51 +0200
Message-ID: <972401915.21121.0.pluto.d4ee154e_at_news.demon.nl>
check v$instance, v$database (both accessible to people with the select_catalog_role only) and global_name (accessible to everyone). IMHO the database name should be sufficient, so global_name would do.
Hth,
Sybrand Bakker, Oracle DBA
"dniel navarro" <"dnavarro"_at_(remove_this_to_send)intervoice.com> wrote in
message news:39f4b470.0_at_208.200.21.197...
>
> I have created an application using Dev2k Release 2.1 against
> an Oracle DB (8.0.5) that resides on a Sun Solaris box. My
> dilema is that I would like to see, when using my app the
> INSTANCE NAME, IP ADDRESS, and HOST NAME that
> I am logged on to during my session using my application. I
> have several databases that I connect to (Developement DB
> and Production DB) and it would be nice to see in my
> App which one I am connect to. Has anyone done something
> like this or any ideas on how it can be done?
>
>
Received on Tue Oct 24 2000 - 17:35:51 CEST