APEX

Hi,

is there a way to generate URL for calling APEX page with checksum at the end of the link if URL is generated outside of APEX?

If I call function like this one outside of APEX, checksum is not generated:

create or replace function f_get_apex_url
  return varchar2
is
begin
  return apex_util.prepare_url(p_url => 'f?p=100:1:0::::P1_ITEM:1'
                             , p_checksum_type => 'PUBLIC_BOOKMARK');
end;
/

I've noticed that by populating global variable (g_curr_flow_security_group_id) in wwv_flow_security  function works fine:create or replace function f_get_apex_url

create or replace function f_get_apex_url
  return varchar2
is
begin
  apex_050100.WWV_FLOW_SECURITY.G_CURR_FLOW_SECURITY_GROUP_ID := 1830663391033130;
  return apex_util.prepare_url(p_url => 'f?p=100:1:0::::P1_ITEM:1'
                    , p_checksum_type => 'PUBLIC_BOOKMARK');
end;
/

But, I don't like the fact that this function depends on current APEX version.

Thanks in advance!

Br,

Marko