The main question
select sys_guid() from dual;

As you can see, the code is directly messed up.

Reason: SYS_GUID returns a globally unique identifier in the form of a 16-bit RAW type value

Solution:
Use the rawtohex() function method.

hextoraw(): convert a hexadecimal string to raw.

rawtohex(): convert raw string to hexadecimal.

Messy code solution.

select rawtohex(sys_guid()) from dual;

You can see that the garbled code is gone.

To lowercase.
select lower(rawtohex(sys_guid())) from dual;

Similar Posts:

• How to Solve TypeError: not all arguments converted during string formatting
• Spring MVC upload file error string cannot be converted to multipartfile
• HTTP status 405 – request method ‘get’ not supported using springmvc
• [Solved] Oracle :value too large for column “SCHEMA”.”TABLE”.”COLUMN” (actual: 519, maximum: 500)
• When using SQL(), dataset can’t use map, flatmap and other conversion operators
• How to Solve Error: Unexpected token o in JSON at position 1
• Uncaught typeerror: the solution of illegal invocation problem
• Convert Object to List, avoiding Unchecked cast: ‘java.lang.Object’ to ‘java.util.List
• InvalidIndexNameException[Invalid index name [XXX], must be lowercase]
• Get the time value from the database and report an error: Java sql. Timestamp cannot be cast to java. lang.Long