I want to convert hex values to String Is there any way out ? At present I am making a database call but this will not work in future as we are planning to moving from on premises to cloud database. I don't want this round trip. Any one has article please share
<pre>
//input 35394330315931324131
SELECT unhex(:ls_code) INTO :ls_unhex from DUAL;
// return 59C01Y12A1
SELECT hex('59C01Y12A1') from DUAL;
//return 35394330315931324131
</pre>