Re: HELP: ORA-01410: invalid ROWID.

From: <broeni_at_my-deja.com>
Date: Fri, 03 Sep 1999 10:49:47 GMT
Message-ID: <7qo94a$5s2$1@nnrp1.deja.com>

In general the ORACLE Server Messages handbook provide a better descritption than `oerr ora 1410':
A ROWID was entered incorrectly. ... format is '000001F8.0001.0006'. (ORACLE SQL> select * from dual where rowid = 'sgsd' ERROR at line 1:
ORA-01410: invalid ROWID

but

SQL> select rowid from dual;

ROWID

---

AAAACsAABAAAAGkAAA

1 row selected.

SQL> select 'it works' from dual where rowid = 'AAAACsAABAAAAGkAAA';

'ITWORKS

---

it works

1 row selected.

regards, Stephan

In article <37CF3648.6CE6D3E5_at_nortelnetworks.com>,   Chris Forlano <cforlano_at_nortelnetworks.com> wrote:
> The Oracle help for this error (oerr ORA 01410) is not very telling.
> Anyone ever seen this before?
>
> General SQL Error.
> ORA-01410: invalid ROWID.
>
> Thanks,
>
> Chris
>
> --
> Chris Forlano
> TMS Project Manager
> Nortel Networks, Maidenhead
> 590 4342 (01628 434 342)
> cforlano_at_nortelnetworks.com
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Sep 03 1999 - 05:49:47 CDT