ORA 0410: invalid ROWID

[dba127]

Hi,

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.

Thanks

[tabreaz]

What your procedure actually does?

[dba127]

This error is reported by developer,I don't know at procedure level,but from the info collected from them,I finally traced out this could be the reason for this error.

The traced info is,
T1: exec procA by developer
T2: rebuild index by me
T3: rebuild finishes
T4: ORA0410: invalid ROWID

Thanks

[tabreaz]

I thinks its not the problem with rebuilding index.

Something to do with the procedure, you can speak to your developers and know what exactly the procedure doing, you might find the reason.

[JMac]

Can they reproduce this - obvioulsy whilst you are NOT rebuilding any indexes? If so, its their code.