41.2 CREATE_SESSION Procedure
This procedure creates a new session for the given application, set environment and run the application's Initialization PL/SQL Code.
Syntax
PROCEDURE CREATE_SESSION (
p_app_id IN NUMBER,
p_page_id IN NUMBER,
p_username IN VARCHAR2,
p_call_post_authentication IN BOOLEAN DEFAULT FALSE );
Parameters
Table 41-2 CREATE_SESSION Procedure Parameters
Parameters | Description |
---|---|
|
The application id. |
|
The application page. |
|
The session user. |
|
If true, call post-authentication procedure. The default is false. |
Raises
WWV_FLOW.APP_NOT_FOUND_ERR
: The application does not exist or the caller has no access to the workspace.
Example
Note:
The CREATE_SESSION
procedure is not supported in the SQL Commands and SQL Scripts tools within SQL Workshop.
This example creates a session for EXAMPLE USER in application 100 page 1, then print the app id and session id.
begin
apex_session.create_session (
p_app_id => 100,
p_page_id => 1,
p_username => 'EXAMPLE USER' );
sys.dbms_output.put_line (
'App is '||v('APP_ID')||', session is '||v('APP_SESSION'));
end;
See Also:
Parent topic: APEX_SESSION