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

From: David Martin <djmartin_at_netspace.net.au>
Date: 1997/03/22
Message-ID: <33333da1.2692256_at_news.netspace.net.au>#1/1


[Quoted] [Quoted] 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.

Thanks
David


 _--_|\     PO Box 139, Belair, South Australia, 5052
/      \    Tel:+61 51 732273 Fax:+61 51 733245 Mob:+61 18 817 917
\_.-*._/    email: djmartin_at_netspace.net.au (Work things)
    ^ v          : davidj_at_adam.com.au (Adelaide stuff)
    |       "Don't fight the decision, fight its basis!"
    '----<---<---<---<---<---<---<---<---<---<---<---<---<---<- Received on Sat Mar 22 1997 - 00:00:00 CET

Original text of this message