Artificial Intelligence and Machine Learning Discussions
Engage in AI and ML discussions. Collaborate on innovative solutions, explore SAP's AI innovations, and discuss use cases, challenges, and future possibilities.
cancel
Showing results for 
Search instead for 
Did you mean: 

Qr code for zakat

0 Kudos
2,083

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.

1 REPLY 1

0 Kudos
1,084

Done by using the below

utl_raw.cast_to_varchar2(utl_encode.base64_encode((t)));