Re: How to store GUIDs generated from Microsoft

  Thank you for the advice!

  How about the performance when using a string as Primary key - is there any significant difference compared to using a number?

• Randi

  "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:406982c1$0$3301$ed9e5944_at_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 - 11:13:45 CST