2022 Apr 01 10:59 AM
Hello,
Greetings.
I'm trying to use the built-in function in oracle to Convert the hex data to base64, but the output is not accepted by the e-invoice app.
The hex is
010c426f6273205265636f726473020F3331303132323339333530303030330314323032322d30342d32355431353a33303a30305a0407313030302e303005063135302e3030
The expected output should be
AQxCb2JzIFJlY29yZHMCDzMxMDEyMjM5MzUwMDAwMwMUMjAyMi0wNC0yNVQxNTozMDowMFoEBzEwMDAuMDAFBjE1MC4wMA==
I'm using the sample from https://zatca.gov.sa/en/E-Invoicing
My oracle function is
utl_raw.cast_to_varchar2(utl_encode.base64_encode(utl_raw.cast_to_raw(t)));
Thank you.
2022 Apr 11 2:01 PM
Done by using the below
utl_raw.cast_to_varchar2(utl_encode.base64_encode((t)));