PREPARE_URL Function

Oracle Application Express is a rapid development tool for Web applications on the Oracle database.
Post Reply
admin
Posts: 2062
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

PREPARE_URL Function

Post by admin »

APEX_UTIL.PREPARE_URL (
p_url IN VARCHAR2,
p_url_charset IN VARCHAR2 default null,
p_checksum_type IN VARCHAR2 default null,
p_triggering_element IN VARCHAR2 default 'this')
RETURN VARCHAR2;

Note: As shown below each dot is mandatory so don't remove even a dot as without dot it will give an error like &APP_ID. << this dot is a must.

select APEX_UTIL.PREPARE_URL(
p_url => 'f?p=' || &APP_ID. || ':1:'||&APP_PAGE_ID.||'::NO::P1_ITEM:xyz',
p_checksum_type => 'SESSION') from dual;

htp.p(APEX_UTIL.PREPARE_URL(p_url => 'f?p=' || :APP_ID || ':10:'|| :APP_SESSION
||'::NO::P10_ITEM:ABC');
Malik Sikandar Hayat
admin@erpstuff.com
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests