Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to store GUIDs generated from Microsoft

Re: How to store GUIDs generated from Microsoft

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 30 Mar 2004 15:22:56 +0100
Message-ID: <406982c1$0$3301$ed9e5944@reading.news.pipex.net>

"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
Received on Tue Mar 30 2004 - 08:22:56 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US