Re: How to store GUIDs generated from Microsoft

"Randi W" <randiwolner_at_hotmail.com> wrote in message news:c4bpo9$h6o$1_at_services.kq.no...
> I have a column of type RAW(50) that should be the Primary key of a table.
> This works fine when I store Oracle generated GUIDS.
> But - this is also supposed to work with data from some Microsoft program.
> This is an example of a GUID generated from this other program:
> 7f293893-9325-4591-a243-f3f165f33b41
>
> When trying to insert this value into the RAW column, I get this error
> message:
>
> ORA-01465: invalid hex number
>
> What can be done??
>
> Thanks for help on this!!
>
> Randi W
>
> ps. my Oracle version is 8.1.7, run on Windows and AIX

Why not just use VARCHAR2(50) or CHAR(50)? GUIDs are pretty much just strings after all.

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK