SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to convert RAW to Varchar2

407338Dec 7 2006 — edited Dec 7 2006

Hi gurus,
This function sys_guid() returns a RAW. Is there any way to convert it into a Varchar2? to_Char will result in an error ORA-00932: inconsistent datatypes: expected NUMBER got BINARY. What is the proper way to convert it into a varchar2? Is that possible?

Thanks.

Ben

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 4 2007

Added on Dec 7 2006

9 comments

46,839 views