How to generate URL with path parameters instead of query string?
04:40 25 Nov 2025

I’m working on Oracle APEX (v 23.1) with Friendly URL mode enabled. I want to generate a page URL where the value of a page item appears in the path, not in the query string.

For example, this is the standard output of apex_page.get_url:

SELECT apex_page.get_url(
    p_application => 500,
    p_page        => 640,
    p_items       => 'P640_ID',
    p_values      => '34491622'
)
FROM dual;

Result:

f?p=500:640:::::P640_ID:34491622

With Friendly URLs enabled, this turns into something like:

https://server/ords/r/app/page?P640_ID=34491622

But what I want is something like:

https://server/ords/r/app/page/34491622

Basically, I want the item value to become part of the path parameters, not the query string. Is there a supported way in Oracle APEX to generate a Friendly URL where page item values automatically become path parameters?

oracle-apex