I want to convert
'my string' in
CALL UTL_FILE.PUT(v_filehandle, 'my string'); from UTF-8 to Windows-1256. I use IBM data studio v4.1.2.
EBCDIC_STR('my string'). It didn't work, and this error appeared:
No authorized routine named "EBCDIC_STR" of type "FUNCTION" having compatible arguments was found.
I also tried
CAST('my string' AS CLOB CCSID EBCDIC) and the program didn't accept EBCDIC.