GUID to CHAR conversion function?

Hi All,

I am an Oracle newbie and could use a little help, please. We are porting an app to Oracle that already runs with Ingres and MSSQL. Our UUID (GUID) columns are stored as RAW(16). I would like to write a function that will convert the 36-char (or 38-char) GUID string to RAW(16) and a function to convert the RAW(16) to the 36-char string.

When converting from CHAR to RAW(16), the input string would look like this: '00000000-0000-0000-0000-00000000000' or '{00000000-0000-0000-0000-00000000000} '.

When converting from RAW(16) to CHAR, the output string would always look like '00000000-0000-0000-0000-00000000000'.

Does anyone out there have such a function or can point me to one. I haven't found mention of anything like this in the Oracle doc.

Thanks very much
Troy Rudolph Received on Fri Mar 17 2006 - 14:50:14 CST