GUIDs are represented in Oracle using a RAW(16) datatype. Unfortunately, the byte order is different from the standard hyphen-separated GUIDs used in other applications (SQLServer, for example). You also have to wrap the guid in HEXTORAW when doing an insert in Oracle. This converter will produce equivilent GUIDs for use in Oracle, along with a couple of other formats for convenience |