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: where is the error?

Re: where is the error?

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 25 Feb 2005 06:53:11 -0800
Message-ID: <1109343191.038919.229740@f14g2000cwb.googlegroups.com>


Excuse me but the character representation of a rowid contains letters A-Z, and a-z, digits 0-9, and a couple of puncuation characters. Only digits may appear in a character value for it to be successfully converted to a number.

UT1 > select to_char(rowid) from sys.dual; select to_char(rowid) from sys.dual

               *
ERROR at line 1:
ORA-00932: inconsistent datatypes: expected NUMBER got ROWID

UT1 > select rowid from sys.dual;

ROWID



AAAADDAABAAAALxAAA

UT1 > select rowidtochar(rowid) from sys.dual;

ROWIDTOCHAR(ROWID)



AAAADDAABAAAALxAAA

The above line is obviously not a valid number. Perhaps what you want is this

UT1 > select chartorowid('AAAADDAABAAAALxAAA') from sys.dual;

CHARTOROWID('AAAAD



AAAADDAABAAAALxAAA

HTH -- Mark D Powell -- Received on Fri Feb 25 2005 - 08:53:11 CST

Original text of this message

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