# invalid ROWID error

**URL:** <https://forums.toadworld.com/t/invalid-rowid-error/10097>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [December 8, 2010, 2:48pm UTC](https://forums.toadworld.com/t/invalid-rowid-error/10097 "2010-12-08T14:48:26Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![wpenfoldithaca.edu](https://avatars.discourse-cdn.com/v4/letter/w/35a633/32.png) [@wpenfoldithaca.edu](https://forums.toadworld.com/u/wpenfoldithaca.edu)\
**Post date:** [December 8, 2010, 2:48pm UTC](https://forums.toadworld.com/t/invalid-rowid-error/10097/1 "2010-12-08T14:48:26Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [December 8, 2010, 3:21pm UTC](https://forums.toadworld.com/t/invalid-rowid-error/10097/2 "2010-12-08T15:21:21Z")

</div>

> 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.