srinims
asked on
Cursor invalid ora - 1001 error
we have upgradaed the database from oracle 8i to oracle 10g. after this some store procedures failing(ora 1001, cluster invalid). I'm new to oracle and pro C. pls help me to odd out the cause.
The same thing was worked finely with the old database.
Currently we are checking the queries and procedures with evaluation version of oracle 10g.
srini ms
The same thing was worked finely with the old database.
Currently we are checking the queries and procedures with evaluation version of oracle 10g.
srini ms
ASKER
actually. I haven't used any import/export utilities.
I don't need to update my database.
I have to update my tools, which is using the database. thru pro C Code.
The pro*C code is giving some problem while doing some update operation.
currently I'm planning to re-precompile the proC code with Oracle-10g proC compiler.
I don't think so it'll correct my problem
I don't need to update my database.
I have to update my tools, which is using the database. thru pro C Code.
The pro*C code is giving some problem while doing some update operation.
currently I'm planning to re-precompile the proC code with Oracle-10g proC compiler.
I don't think so it'll correct my problem
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
:srinims
Have you made any progress with this? Do you need any more assistance or can you assign points and close this question?
Have you made any progress with this? Do you need any more assistance or can you assign points and close this question?
ASKER
hi,
sorry for the delay. I have corrected the problem by recompiling all proc file with the oracle 10g proc compiler.
the problem is due to oracle 10g uses the bigger structure for the cursor handler. instead of int, they have replace long in lot of places.
Any how, I'll give the points for your effort. Thanks for the answer
srini ms
sorry for the delay. I have corrected the problem by recompiling all proc file with the oracle 10g proc compiler.
the problem is due to oracle 10g uses the bigger structure for the cursor handler. instead of int, they have replace long in lot of places.
Any how, I'll give the points for your effort. Thanks for the answer
srini ms
The best way is using Export/Import utilities.
Be aware that 10g Release 1 has many bugs.
Try to use 10g Release 2 Upgrade 2, i.e. 10.2.0.1 if
you can achieve this.