FORMS 4.5 - ON-LOGON trigger

From: George Dimopoulos <george_at_hivnet.ubc.ca>
Date: Tue, 13 Oct 1998 10:07:00 -0700
Message-ID: <70018f$172$1_at_nntp.ucs.ubc.ca>

[Quoted] [Quoted] 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 Tue Oct 13 1998 - 19:07:00 CEST