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: rowid question

Re: rowid question

From: Pete's <empete2000_at_yahoo.com>
Date: 24 Apr 2003 06:44:57 -0700
Message-ID: <6724a51f.0304240544.6d5ed65e@posting.google.com>


Rowid's in 8i are actually base 64 and not Hex. You should be using a conversion procedure supplied by oracle, i.e. CHARTOROWID().

HTH,
Pete's

hegyvari <member28620_at_dbforums.com> wrote in message news:<2801411.1051179823_at_dbforums.com>...
> Was the x before the '0x4..' section intentional? It gives an error.
> Without the x the error message is invalid rowid.
>
> The log is full of rowid-s using the same format, so the same goes for
> all the logged sqls, out of which only one particular piece is causing
> EOF on communication channel. The server is Oracle 8.1.7.4 on a Windows
> 2000 server.
>
> Regards,
>
> Hegyvari Krisztian
Received on Thu Apr 24 2003 - 08:44:57 CDT

Original text of this message

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