PL/SQL (MOSC)

MOSC Banner

dbms_rowid.rowid_info ORA-01410

edited Apr 14, 2010 3:46AM in PL/SQL (MOSC) 2 comments
 I'm trying to write a program to return data from rows that are locked to aid our developers in debugging their code.  I get ROW_WAIT_OBJ#, ROW_WAIT_FILE#, ROW_WAIT_BLOCK#, ROW_WAIT_ROW# from v$session, but when I use the dbms_rowid.rowid_create to generate a rowid and use that to select from the table I get an ORA-1401.  The created rowid (in this case, AAAC/YAALAAAACUAAw) is close to what I get with the select statement on line 10 of the PL/SQL code, but not the same.  However, the PL/SQL code below also gives the error and it's just getting the rowid_info.  What's up with this???  

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center