Oracle migration problem from 8i to 9i - URGENT [message #64086] |
Mon, 13 December 2004 20:21 |
Deepali Butaney
Messages: 4 Registered: December 2004
|
Junior Member |
|
|
We have a Oracle/PowerBuilder application. After migrating from Oracle 8.1.7 to 9.2.0, data of all columns with datatype CHAR were not displayed in the Client (PB) application. We changed the datatype from CHAR to VARCHAR2. In this case queries with multiple outer joins fail. There are two options to make this work
1) The query works by adding a Trim function to one of the outer join
2) by creating a copy of the same table and then firing the query on the copy of the table.
If you know anything about this problem, or any alternate solution please let me know. Thanks.
|
|
|
|
Re: Oracle migration problem from 8i to 9i - URGENT [message #64088 is a reply to message #64087] |
Mon, 13 December 2004 22:04 |
Deepali Butaney
Messages: 4 Registered: December 2004
|
Junior Member |
|
|
Hi Maaher, Thanx for the reply. If we migrate the database, create a backup of the table, drop all tables, recreate the tables and then import the data, it works. But the client will not accept such a solution which involves dropping of all the tables in the database and recreating them.
Can you suggest any alternate soln.
Once again thanx for taking time off to reply to my query
|
|
|
|
Re: Oracle migration problem from 8i to 9i - URGENT [message #64092 is a reply to message #64091] |
Tue, 14 December 2004 02:13 |
Deepali Butaney
Messages: 4 Registered: December 2004
|
Junior Member |
|
|
Hey Maaher, I really appreciate your response. Unfortunately we have already tried this option that you mentioned and it does not work. We migrated the application and fired explicit updates on the table columns with Trim exactly the way you mentioned but the joins in SQL's still dont work. The only 2 options that worked, out of all that we tried are
1) Dropping the tables and recreate and import data - Client wont accept it
2) Adding an explicit Trim in each and every query in our application - Too much effort, will take days to do it.
Thanx buddy. Appreciate your effort and time.
|
|
|
Re: Oracle migration problem from 8i to 9i - URGENT [message #64093 is a reply to message #64086] |
Tue, 14 December 2004 03:35 |
Sanjay Bajracharya
Messages: 279 Registered: October 2001 Location: Florida
|
Senior Member |
|
|
I really have not worked with PB (combined with Oracle)...still. I also did migrate from 8.1.7 to 9.2.0 about a year ago and did not see anything like this at all
Question... how are you connecting the PB app to Oracle ? Is it native or ODBC ? Asking this, if ODBC, did you find if there are any upgraded drivers ? or did you upgrade the Oracle client too ?? I would try to use the 9.2 client with the 9.2 RDBMS.
Good luck.
--
Sanjay
|
|
|
|
|
|