Re: Storing GUIDs in Oracle

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Wed, 23 Jul 2003 22:06:51 +0200
Message-ID: <2kqthvcvga18jsbcc5qmgs99rgdi96rb90@4ax.com>

On Wed, 23 Jul 2003 14:21:28 -0400, "Jeff Boenig" <jeff.boenig_at_elsitech.com> wrote:

>There isn't a straightforward answer to my questions in the SQL Reference. I
>want to design my database to work equally well with MS-SQL and Oracle,
>which is why I thought posting these questions on this newsgroup would be a
>constructive thing to do.

As MS-SQL and Oracle are two completely different architectures, and apart from PL/SQL Oracle treats the RAW(16) as a VARCHAR2, requiring implicit conversion all the time,. you are going to end up in hell. Please reconsider.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Jul 23 2003 - 15:06:51 CDT