您需要使用LOGON
内置过程:
LOGON('hr', 'hr@yemensoft');
LOGON Built-in
Description: 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. Syntax
PROCEDURE LOGON(username VARCHAR2, password VARCHAR2); PROCEDURE LOGON(username VARCHAR2, password VARCHAR2, logon_screen_on_error BOOLEAN);
ON-LOGON
触发器中添加以下内容:LOGON('hr', 'hr'||'@'||Get_Application_Property(CONNECT_STRING), false);
请确保在您的 formsweb.cfg
中添加类似以下内容:
[your-conf-for-db-yemensoft]
...
...
userid=@yemensoft
execute
用于运行PL/SQL
。connect
是 SQL*Plus 语法,不是 PL/SQL。 - Jeffrey Kemp