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 Pass Accented Character in URL

FofanaAug 4 2021 — edited Aug 4 2021

Hello, Is there a way to exclude some accented characters when using UTL_URL.ESCAPE
Issue is that I have to pass this URL exactly to an API because the remote server will make a check against an existing folder bearing that name.
account/RAÚL SÁNCHEZ (TECH SOLUTIONS)_dfdf9e8f9dd3eb11bacc0022486d86e4/opportunity
If I use ...UTL_URL.ESCAPE(p_AccountName)... I get this:
account/RA%DAL%20S%C1NCHEZ%20(TECH%20SOLUTIONS)_dfdf9e8f9dd3eb11bacc0022486d86e4/
which is not the folder name
If I don't use UTL_URL.ESCAPE I get error: h2>Bad Request - Invalid URL</h2><hr><p>HTTP Error 400. The request URL is invalid.</p>
Any Idea?

Comments
Post Details
Added on Aug 4 2021
1 comment
348 views