set_target procedure

Related topics

Contained in package wwa_app_module.

Call this procedure to set the target URL for a form component.

procedure set_target
(
p_target in varchar2,
p_target_mode in varchar2 default 'CALL'
);

Version: Oracle Portal 3.0.9

Parameters:

p_target

The URL to be displayed.

Datatype: varchar2

p_target_mode

Determines whether the current session is dropped.

Options are: CALL and GO:

GO - the current session is dropped before going to the URL.

CALL - the current session is not dropped so you can return to previous session.

Datatype: varchar2
Default: CALL

Exceptions:

None.

Example:

Consider a procedure named helloworld in your database provider (application) schema, denoted by 'x'. Execute privileges have been granted on procedure helloworld to <portal_schema>_public database user:

procedure helloworld
(
p_back_url in varchar2 default null
)
is
begin
htp.p('Hello World');
if p_back_url is not null then
htp.br;
htp.p('<a href="'||p_back_url||'">Back to form</a>');
end if;
end;

To set the target of the form component using the set_target procedure, make the call to set_target from one of the PL/SQL button handler codes:

Since the session is dropped when the target mode is GO, there is no need to give a Back link to the previous form session:

<portal_schema>.wwa_app_module.set_target
(

p_target =>'http://<host>:<port>/pls/<dad>/x.helloworld'
p_target_mode => 'GO'

);

The current session is not dropped when the target mode is CALL, so we can give a Back link to the previous session:

<portal_schema>.wwa_app_module.set_target
(

p_target => 'http://<host>:<port>/pls/<dad>/x.helloworld?p_back_url='||
<portal_schema>.wwutl_htf.url_encode(
'http://<host>:<port>/pls/<dad>/<portal_schema>.'||
'wwa_app_module.show?p_sessionid='||p_session.get_id),
p_target_mode => 'CALL'

);

Version: Oracle Portal 3.0.9
Parameters:
p_target	The URL to be displayed. Datatype: varchar2
p_target_mode	Determines whether the current session is dropped. Options are: CALL and GO: GO - the current session is dropped before going to the URL. CALL - the current session is not dropped so you can return to previous session. Datatype: varchar2 Default: CALL
Exceptions: None. Example: Consider a procedure named helloworld in your database provider (application) schema, denoted by 'x'. Execute privileges have been granted on procedure helloworld to <portal_schema>_public database user: procedure helloworld ( p_back_url in varchar2 default null ) is begin htp.p('Hello World'); if p_back_url is not null then htp.br; htp.p('<a href="'\|\|p_back_url\|\|'">Back to form</a>'); end if; end; To set the target of the form component using the set_target procedure, make the call to set_target from one of the PL/SQL button handler codes: Since the session is dropped when the target mode is GO, there is no need to give a Back link to the previous form session: <portal_schema>.wwa_app_module.set_target ( p_target =>'http://<host>:<port>/pls/<dad>/x.helloworld' p_target_mode => 'GO' ); The current session is not dropped when the target mode is CALL, so we can give a Back link to the previous session: <portal_schema>.wwa_app_module.set_target ( p_target => 'http://<host>:<port>/pls/<dad>/x.helloworld?p_back_url='\|\| <portal_schema>.wwutl_htf.url_encode( 'http://<host>:<port>/pls/<dad>/<portal_schema>.'\|\| 'wwa_app_module.show?p_sessionid='\|\|p_session.get_id), p_target_mode => 'CALL' );

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