Skip to Main Content

SQL & PL/SQL

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!

Special characters in utl._url.escape

953817Aug 30 2012 — edited Sep 1 2012
Hi I am using httpuri for google translator to convert into different languages.

While passing the string, to escape the white spaces, I am using utl_url.escape . But many of my words contain special characters like '+ , @ , $ , ) ,. ,; [, ] etc.

Not sure how to pass these special characters in uri type.

httpuritype
              ('http://translate.google.com/?hl=' ||
                p_from || '&layout=1&eotf=1&sl=' || p_from ||
                '&tl=' || p_to || '&text=' ||
               utl_url.escape (p_words) || '#').getclob();
few of my words for translation are

VALERIANA OFFICINALIS L. + HYPERICUM PERFORATUM L. + MELISSA OFFICINALIS L.
VALERIANA OFFICINALIS L. + HYPERICUM PERFORATUM L. + [ MELISSA OFFICINALIS] L.

please advise me how to pass these special characters to the URL.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 29 2012
Added on Aug 30 2012
4 comments
597 views