Toad World® Forums

invalid ROWID error


#1

Hi, using Toad 10.6 I’m running this sql statement

SELECT
t.rowid x, ARCHIVE_LINE, ARCHIVE_LAST
FROM ITHACA.ARCHIVE_TRANSCRIPTS t
Where
ARCHIVE_LINE LIKE ‘%RICARDO%’;

Which is returning the following data:

(AAD3pwAAAAAAAAAAA1nQmg LUCAS RICARDO J 129501723

but the ROWID is 23 characters long…it’s supposed to be only 18 correct? If I
try to select the row by that value (rowid =
chartorowid(’(AAD3pwAAAAAAAAAAA1nQmg’) I get this error:

ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-01410: invalid ROWID
ORA-06512: at “SYS.ORACLE_LOADER”, line 52

If I try it without the the CHARTOROWID function, I get this error:

ORA-00600: internal error code, arguments: [qknltAllocate_10], [63399], [],
[], [], [], [], []

Any ideas what I should do differently?


#2

but the ROWID is 23 characters long…it’s supposed to be only 18
correct? If I try to select the row by that value (rowid =
chartorowid(’(AAD3pwAAAAAAAAAAA1nQmg’) I get this error:

ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-01410: invalid ROWID
ORA-06512: at “SYS.ORACLE_LOADER”, line 52

If I try it without the the CHARTOROWID function, I get this error:

ORA-00600: internal error code, arguments: [qknltAllocate_10],
[63399], [], [], [], [], [], []

Any ideas what I should do differently?

According to that error in Oracle Support, you should skip using the ROWID.
It appears that your table is external (i.e. not in the database), where
there is no such thing as a ROWID and is therefore meaningless, causing your
issue.

Let us know if this is the case! GL!

Rich – [TeamT]

Disclaimer: My wife has never bit off my tongue. Yet.