| Oracle9iAS Portal PL/SQL API Reference | |||||||
| FRAMES NO FRAMES | ||||||||
These examples are based on a form component based on the SCOTT.EMP table:
Example 1:
This HTML starts a new session for a form component, via the link "New
Form":
<a href="http://HOST:PORT/pls/DAD/PORTAL_SCHEMA.wwa_app_module.link?
p_arg_names=_moduleid&p_arg_values=MODULE_ID&
p_arg_names=_sessionid&p_arg_values=> New Form</a>
To start a new session, leave _sessionid parameter set to null. To start a saved session, specify the session_id in the corresponding p_arg_values.
Note: A new session can also be started using the new_instance procedure.
Example 2:
This URL starts a new session for a form component, with deptno set to 20:
http://HOST:PORT/pls/DAD/PORTAL_SCHEMA.wwa_app_module.link?
p_arg_names=_moduleid&p_arg_values=MODULE_ID&
p_arg_names=_sessionid&p_arg_values=&
p_arg_names=DEPTNO&p_arg_values=20
Note: DEPTNO is the name of a form component item, i.e. a text box in a form for the deptno column.
In this example, the new session is started in QUERY mode, i.e. with the QUERY button displayed and with the value 20 in the deptno field.
Example 3:
This URL starts a new session for a form component in UPDATE mode, i.e.
already queried based on deptno set to 20:
http://HOST:PORT/pls/DAD/PORTAL_SCHEMA.wwa_app_module.link?
p_arg_names=_moduleid&p_arg_values=MODULE_ID&
p_arg_names=_sessionid&p_arg_values=&
p_arg_names=DEPTNO&p_arg_values=20&
p_arg_names=_deptno_cond&p_arg_values=%3D
Note: %3D is the escaped form of the character "=". The escaped forms of other relational operators can also be used for specifying query conditions.
| Oracle9iAS Portal PL/SQL API Reference | |||||||
| FRAMES NO FRAMES | ||||||||