PL/SQL (MOSC)

MOSC Banner

DBMS_ROWID problems

edited May 6, 2010 8:50AM in PL/SQL (MOSC) 4 commentsAnswered
 I'm trying to write a PL/SQL program to return the data values from a locked row to help our developers debug the locking conditions.  However, I'm having lots of difficulty with the dbms_rowid package.  I get the columns ROW_WAIT_OBJ#, ROW_WAIT_FILE#, ROW_WAIT_BLOCK#, ROW_WAIT_ROW# from v$session for the locked row and use the dbms_rowid.create_rowid to create a rowid from the values.  However, when I try to select that row I'm getting an ORA-01410 Invalid Rowid.

When I write a bit of PL/SQL and select the rowid of the data row I've locked, I get a slightly different rowid format, but it's largely the same.  However, I cannot resolve the parts of that rowid with the dbms_rowid.rowid_info procedures.

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