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