Hello , Today - we tried to migrate our application from a 32 bit Oracle 8i environment to a 64bit Oracle 9i environment .
Whiel going through the application - we encountered a strange problem where we invoke a stored procedure - and the stored procedure is supposed to return us a cursor handle which we use to loop through data in java .
What is observed is that on executing the stored procedure through java ( old jdbc driver that was supporting 8i ) the results were kind of screwed up
Executing the stored procedure stand alone from a prompt works fine . The same code and driver when pointing to 8i 32 bit environment gave us correct results
I am not good at this - but wanted to know - would the driver play a part ? Would the driver need to be able to support the 64 bit environment ? Is there a limitation to the way SQL is built in 91 as compared to 8i which could be causing this problem ?
( we are using a driver which is in a jar file - classes12.jar )