But this error can be seen in some cases in Dev2K when
you try to change a record of a block, based on a view.
As I remember, it is raised because in this case
block rowid is illegal, but at first it looked not very
obvious.
--
Alexander I.Doroshko, aid_at_grant.kharkov.ua
- Bank "Grant", Kharkov, Ukraine
broeni_at_my-deja.com wrote in article <7qo94a$5s2$1_at_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
: >
Received on Fri Sep 03 1999 - 10:09:48 CDT
