SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01410: invalid ROWID

pawanprajapatiJan 23 2017 — edited Jan 26 2017

Hi All,

I am working as a Oracle PLSQL developer and my Oracle version is as below

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

PL/SQL Release 11.2.0.1.0 - Production

CORE 11.2.0.1.0 Production

TNS for 64-bit Windows: Version 11.2.0.1.0 - Production

NLSRTL Version 11.2.0.1.0 - Production

I have a plsql process which run smoothly but Now some time process interrupted due to ORA-01410: invalid ROWID exception, when I use DBMS_UTILITY.FORMAT_ERROR_BACKTRACE to trace the error, it is comming from a select statement.

Please provide the solution.

Thanks in advance

Pawan Kant Prajapati

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 23 2017

Added on Jan 23 2017

7 comments

2,468 views