dbms_rowid.rowid_info ORA-01410
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???
0