Oracle Forms: LOGON SCREEN

LOGON_SCREEN Built-in

Description

Displays the default Forms Developer 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.

Syntax

PROCEDURE LOGON_SCREEN;

Built-in Type unrestricted procedure

Enter Query Mode yes

Parameters

none

LOGON_SCREEN Restrictions

●     You must issue a call to the LOGON built-in to create the connection to your data source.

LOGON_SCREEN Examples

/*

**  Built-in: LOGON_SCREEN

**  Example: Use the default Forms Developer 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);

4-387

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;