I got this ORA0410: invalid ROWID,while executing a stored procedure,after
started executing the procedure,I rebuilt the index associated with that procedure.
Here is what i did & got,
T1: exec procA
T2: rebuild index
T3: rebuild finishes
T4: ORA0410: invalid ROWID
Clear the follwing things to me,
1. Whether i got ORA0410: invalid ROWID,due to index rebuild during procedure execution or is there any other reason?
2. If I reexecute the same procedure,will it execute successfully or
again it throws ORA0410: invalid ROWID.If the same error will be given
again,then what are all the steps I've to follow before execting this
procedure so that it'll be executed successfully.