Re: FORMS 4.5 - ON-LOGON trigger

[Quoted] 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 - 06:22:46 CEST