Here's something that I'm trying to find a justification for at the behest of
a younger and less experienced colleague: Why, when one selects from a table
via pseudocolumn ROWID, and the ROWID is not in the specified table, does
Oracle give you "1410-invalid ROWID" rather than "1403-no data found"?
I've tried this not only with ROWIDs that I've made up (see below), but also
with valid ROWIDs that exist in other tables (so, clearly it _is_ a valid
rowid, just not for the table in question). Any takers on this one?
PL/SQL Release 22.214.171.124.1 - Production
SQL> select rowid from dual;
SQL> select * from dual where rowid = '00000324.0000.0001';
SQL> select rowid from dual where rowid = '00000324.0000.0002';
ORA-01410: invalid ROWID
no rows selected