Disconnects the application from the ORACLE RDBMS. All open cursors are automatically closed when you issue a call to the LOGOUT Built-in. You can programmatically log back on with LOGON. If you LOGOUT of a multiple-form application with multiple sessions, Oracle Forms tries to re-establish all of those connections when you subsequently execute LOGON.
PROCEDURE LOGOUT;
Built-in Type unrestricted procedure
Enter Query Mode yes
none
/*
** Built-in: LOGOUT
** Example: Perform Oracle Forms standard logout. 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.
** Trigger: On-Logout
*/
BEGIN
/*
** Check the flag we setup at form startup
*/
IF :Global.Non_Oracle_Datasource = 'TRUE' THEN
User_Exit('my_logout');
/*
** Otherwise, do the right thing.
*/
ELSE
Logout;
END IF;