Re: How to get Oracle instance name and forms generation date/time

From: Steve Cosner <stevec_at_zimmer.csufresno.edu>
Date: 1997/03/23
Message-ID: <5h2fsa$ha0_at_info.csufresno.edu>#1/1

In article <33333da1.2692256_at_news.netspace.net.au>, David Martin <djmartin_at_netspace.net.au> wrote:
>I am trying to build a string that I will append to the Window Name so
>that when users screen print a problem we know where, when, by whom
>and which form.
>
>This string would contain:
>(1) the User Id (I know this one),
>(2) Oracle Instance name (we have three instances PROD, DEV1, TEST
>each addressable by Listener and defined in the TNSNAMES.ORA file),
>(3) the form name,
>(4) the date/time stamp of this form.
>
>I need help with numbers 2 and 4.

Does Get_Application_Property(Connect_String) help with #2?

On #4, the only way I would know of is to hard-code a version and date string into a parameter, or some other uniform place, in each form. Not a good solution, but I don't know any other way.

Regards,
Steve Cosner

---

Try out QA, a dynamic data utility form. Quick display and update access to any table. http://members.aol.com/stevec5088 Received on Sun Mar 23 1997 - 00:00:00 CET