DB2 - Oracle Migration [message #94328] |
Wed, 04 August 2004 18:26 |
Leandro Costa
Messages: 2 Registered: August 2004
|
Junior Member |
|
|
We're migrating an application running on DB2, to Oracle, and we found some sources that do a previous read of the result set of a cursor, then it reads until it gets a 100 (ORA-1403 iirc), and then it READS again. This source apparently does run on DB2, but here, we get a 1002 because we're trying to fetch a null cursor. How could we workaround this and have this program run without modifying the code (i.e. some precompiler option) (if there's any way to do it)
Thanks a lot!
|
|
|
|
Re: DB2 - Oracle Migration [message #94479 is a reply to message #94478] |
Thu, 16 December 2004 01:35 |
Leandro Costa
Messages: 2 Registered: August 2004
|
Junior Member |
|
|
There are some guides out there that outline the main changes, but if have any doubts, ask for a solution in this thread. I've been working some months on a migration like the one you seem to be doing, and maybe i can help you.
Regards,
Leandro Costa
|
|
|
Re: DB2 - Oracle Migration [message #94480 is a reply to message #94479] |
Thu, 16 December 2004 03:42 |
vamsy
Messages: 3 Registered: December 2004
|
Junior Member |
|
|
Hi,
i am using db2-oracle conversion kit i collected oracle reserved words which are columns in db2 tables, now can you please tell me how to proceed further.
thanks,
Vamsy
|
|
|