Press "Enter" to skip to content

LOGON_SCREEN built-in Oracle D2k / Oracle Forms Description

LOGON_SCREEN built-in Oracle D2k / Oracle Forms

Description
Displays the default Form Builder 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 Form Builder 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;

Vinish Kapoor

I am a full stack developer and writing about development. I document everything I learn and help thousands of people. foxinfotech.in is created, written, and maintained by me, it is built on WordPress, and hosted by Bluehost. Connect with me on Facebook, Twitter, GitHub and get notifications for new posts.

You may also like:

Be First to Comment

    Leave a Reply

    Your email address will not be published. Required fields are marked *