Re: Forms 4.5 Logons

I hope I fully inderstand the question;

If you mean capture a userid from an existing session where the user is logged on, but not in Forms, can you not write a database package/procedure/function to be called from the form, in the on-loggon trigger?
(My personal preference is to create a package of similar utilities on the database, and keep adding to this as new ones are required.)

If you are looking for the userid from a logged-on form, then the only function I know of for session info is GET_APPLICATION_PROPERTY either connect_string or username. But that is presumably not exactly what you are looking for?
But then the above should still do what you want.

Hope that is some help?

Mike

In article <5csrpe$eks_at_kodak.rdcs.Kodak.COM>, Eric Mansfield <l325000_at_mso8011.Kodak.COM> writes
>We are currently converting our Sun Desktop Applications to run on the PC
>(NT 4.0).
>
>In the UNIX environment, I can get the user into the application
>using their UNXI logon and the 'OPS$' oracle userid by having UNIX
>excute the 'runform45m <formname>.fmx /' and the user will not need to
>logon again.
>
>I'm trying to do the same thing on the PC.
>
>I tried using a 'logon trigger', but i still can't figure out how to
>capture the userid to pass it directly to the form and I can't simply
>use a generic userid because data is trakced by the specific userid.
>
>Anyone have any suggestions?
>
>Thanks,
>Eric Mansfield
>xamu_at_kodak.com
 

-- 
Mike Proctor                    Database Consultants International (UK)

Mike_Proctor_at_realworld.com      Oracle vision.
                                Only Oracle.
                                All the time.