link procedure

Related topics

Contained in package wwa_app_module.

Call this procedure to start a form component session via a link. Appropriate parameters can be passed as name value pairs.

Note: Knowing the parameter names is important and this is illustrated in the examples below.

procedure link
(
p_arg_names in wwv_utl_api_types.vc_arr default empty_vc_arr,
p_arg_values in wwv_utl_api_types.vc_arr default empty_vc_arr
);

Version: Oracle Portal 3.0.9

Parameters:

p_arg_names

The argument name.

Datatype: wwv_utl_api_types.vc_arr
Default: empty_vc_arr

p_arg_values

A corresponding argument value

Datatype: wwv_utl_api_types.vc_arr
Default: empty_vc_arr

Exceptions:

None.

Examples

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.

Version: Oracle Portal 3.0.9
Parameters:
p_arg_names	The argument name. Datatype: wwv_utl_api_types.vc_arr Default: empty_vc_arr
p_arg_values	A corresponding argument value Datatype: wwv_utl_api_types.vc_arr Default: empty_vc_arr
Exceptions: None. Examples 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.

Related topics
Form component API package	PDK PL/SQL API Reference - Home