Displays the default Oracle Forms logon screen and requests a valid username and password. Most commonly, you will include this Built-in subprogram in an On-Logon trigger to connect to a non-ORACLE data source.
PROCEDURE LOGON_SCREEN;
Built-in Type unrestricted procedure
Enter Query Mode yes
none
/*
** Built-in: LOGON_SCREEN
** Example: Use the default Oracle Forms logon screen to prompt
** for username and password before logging on to
** the database. This uses the 'Get_Connect_Info'
** procedure from the GET_APPLICATION_PROPERTY
** example.
*/
DECLARE
un VARCHAR2(80);
pw VARCHAR2(80);
cn VARCHAR2(80);
BEGIN
/*
** Bring up the logon screen
*/
Logon_Screen;
/*
** Get the username, password and
** connect string.
*/
Get_Connect_Info( un, pw, cn );
/*
** Log the user onto the database
*/
IF cn IS NOT NULL THEN
LOGON(un,pw||'@'||cn);
ELSE
LOGON(un,pw);
END IF;
END;