Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to generate URL with path parameters instead of query string?

Faezeh Ebrahimi6 hours ago

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?

This post has been answered by jariola on Nov 25 2025
Jump to Answer
Comments
Post Details
Added 6 hours ago
2 comments
42 views