Artificial Intelligence Forum
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Qr code for zakat

0 Likes
3,056

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
Read only

0 Likes
2,057

Done by using the below

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