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 -> How to store GUIDs generated from Microsoft

How to store GUIDs generated from Microsoft

From: Randi W <randiwolner_at_hotmail.com>
Date: Tue, 30 Mar 2004 14:38:32 +0200
Message-ID: <c4bpo9$h6o$1@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 Received on Tue Mar 30 2004 - 06:38:32 CST

Original text of this message

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