Performs the default Oracle Forms logon processing with an indicated username and password. Call this procedure from an On-Logon trigger when you want to augment default logon processing.
PROCEDURE LOGON
(username VARCHAR2,
password VARCHAR2);
PROCEDURE LOGON
(username VARCHAR2,
password VARCHAR2,
logon_screen_on_error VARCHAR2);
Built-in Type unrestricted procedure
Enter Query Mode yes
This Built-in takes the following arguments:
When using LOGON to connect to an OPS$ database use a slash '/' for the user.name and the database name for the password..
/*
** Built-in: LOGON
** Example: Perform Oracle Forms standard logon to the ORACLE
** database. Decide whether to use Oracle Forms
** Built-in processing or a user exit by consulting a
** global flag setup at startup by the form,
** perhaps based on a parameter. This example
** uses the 'Get_Connect_Info' procedure from the
** GET_APPLICATION_PROPERTY example.
** Trigger: On-Logon
*/
DECLARE
un VARCHAR2(80);
pw VARCHAR2(80);
cn VARCHAR2(80);
BEGIN
/*
** Get the connection info
*/
Get_Connect_Info(un,pw,cn);
/*
** If at startup we set the flag to tell our form that we
** are not running against ORACLE, then call our
** appropriate MY_LOGON userexit to logon.
*/
IF :Global.Non_Oracle_Datasource = 'TRUE' THEN
User_Exit('my_logon username='||un||' password='||pw);
/*
** Otherwise, call the LOGON Built-in
*/
ELSE
/*
** Use the following to place a slash in the username field for OPS$ logon
*/
IF un IS NULL THEN
un:='/';
END IF;
IF cn IS NOT NULL THEN
LOGON(un,pw||'@'||cn);
ELSE
LOGON(un,pw);
END IF;