Re: FORMS 4.5 - ON-LOGON trigger

There is a third parameter for logon built in If it is TRUE default oracle will automatically call it's standard logon screen and if you pass it FALSE , You can check for FORM_SUCCESS otherwise this will not give you the correct result. See online help for LOGON built in.

Neville Sweet wrote:

> Hi George,
>
> I don't know how to force ON-LOGON, but you could try checking
> Forms_Success after LOGON_SCREEN. This will test False if either the user
> hit Cancel or there are 4 failed login attempts. You could then loop and
> call LOGON_SCREEN again if necessary. The user needs to have an "out" from
> the loop, which would be Cancel. I've never needed to differentiate between
> cancel and failure - maybe test userid and password for null?
>
> George Dimopoulos <george_at_hivnet.ubc.ca> wrote in article
> <70018f$172$1_at_nntp.ucs.ubc.ca>...
> > I am attempting to add pre-fixes to username and password
> > before logon to Oracle Instance.
> >
> > This will work fine if on the first attempt user enters correct
> > username/password
> > as they know it.
> >
> > It fails to work, if user enters incorrect username or/and password
> > since LOGON built-in does not fire ON-LOGON trigger again.
> >
> > Any ideas on how to make ON-LOGON fire again?
> >
> >
> > DECLARE
> > un VARCHAR2(80);
> > pw VARCHAR2(80);
> > cn VARCHAR2(80);
> >
> > BEGIN
> >
> > logout;
> >
> > Logon_Screen;
> >
> > un := Get_application_Property(USERNAME);
> > pw := Get_application_Property(PASSWORD);
> > cn := Get_application_Property(CONNECT_STRING);
> >
> > un := 'pra_'||un; -- gd
> > pw := 'x'||pw||'x'; -- gd
> >
> > IF cn IS NOT NULL THEN
> > LOGON(un,pw||'_at_'||cn);
> > ELSE
> > LOGON(un,pw||'_at_promis'); -- gd
> > END IF;
> >
> > END;
Received on Thu Oct 15 1998 - 15:21:56 CEST