Skip to Main Content
Feature Request FR-2528
Product Area APIs
Status CLOSED

9 Voters

Add APEX_UTIL.URL_DECODE function

ino.laurensse Public · May 18 2022

Idea Summary
There is a function APEX_UTIL.URL_ENCODE, but no APEX_UTIL.URL_DECODE.

It's almost the same as using the UTL_URL functions, but the latter cannot be used in SQL statements (because of the boolean input parameter).

Use Case
REST services returning a URL.

Preferred Solution (Optional)
Add URL_DECODE to APEX_UTIL.

We reviewed this idea carefully, and while it was interesting, we concluded that due to all the internal implications we need to take into account, it is unlikely to make its way into APEX.

Comments

Comments

  • fac586 OP 3.2 years ago

    Add URL_DECODE to APEX_UTIL.

    Combat APEX_UTIL bloat. Deprecate APEX_UTIL.ENCODE and add URL_ENCODE/DECODE to APEX_ESCAPE.

  • vincent morneau Admin OP 2 years ago

    Hi @ino.laurensse ,

    Given that this API existed for many years, and was missing URL_DECODE, and soon you should be able to use UTL_URL boolean functions in 23c, it's unlikely that APEX will invest in new PL/SQL wrappers.

    If you need it now, you should be able to create your own wrappers until you can use 23c.