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!

How can we encode a text to Base 64?

Shef RMay 26 2022

19CEE
Hi there -
Here is the issue I am facing

I need to send my text with a base 64 encoding via webservice. I see valid values for example

"TEXT" is encoded to "VEVYVA==" which works

However, based on documentation if I were to usee the UTL_ENCODING options, I get numeric values

select utl_encode.base64_encode(utl_raw.cast_to_raw('TEXT')) from dual

Similarly I need to decode it back when I get the value via webservice. Can someone guide me on how to get this conversion right.

TEXT should be converted to VEVYVA== as an example

thanks!

Comments
Post Details
Added on May 26 2022
1 comment
2,059 views