SYSTEM INFO
Migrating from Powerbuilder 6.5 build 444
Migrating to Powerbuilder 8.0 build 7039
Windows NT 4.0 (build 1381 - SP6)
Oracle 8i (Enterprise Edition 8.1.7.1.1)
Oracle Net8 (8.1.6)
Oracle 7 Driver (pbo7380.dll, 276kb, 25/05/2001)
Oracle 8 Driver (pbo8480.dll, 329kb, 03/07/2001)
Can anyone help please?
We are currently evaluating Powerbuilder 8.0 (including the C2 patch) for
use as a replacement to our 6.5 software.
We have successfully migrated our source code and connected PB8 to the
database using the Oracle 8 Native Driver but we are getting two problems
with our code, both related to calls to stored procedures (used for almost
all retrieve & update functionality in our app.).
Problem 1 - during a very simple retrieve SP, the datawindow (in
development & when the app. is run) retrieves two-thirds of the required
rows (around 3000 in total) and then fails to fetch any more, returning a
-1. I have repeated using the Oracle 7.3 Native Driver and at around the
same stage (i.e. during fetch of the retrieved rows) PB just GPFs.
Problem 2 - a number of SPs simply cannot be found during execution. All of
these SPs are in packages, however other SPs in packages are found without
any problem. Again using the Oracle 7 driver causes PB to GPF.
I have checked that neither of these problems occurs in PB6.5 (where we use
the Oracle 7.3 Native Database Driver)
We have had partial success, but still no clear reason / explanation:
Using the source editor shows that the datawindows still export from PB8
with a 'release 6' header, despite having been 'successfuly' migrated.
I changed this to 'release 8' (mainly just for the sake of changing
something) and saved, causing the datawindow to be regenerated.
This caused both of the datawnidows to operate correctly using the Oracle 7
driver, but not at all under the Oracle 8 driver.
Re-creating the datawindow from scratch in PB8.0 specifying the same SP,
same result set & same arguements, allowed the datawindow to work properly
with the Oracle 8 Driver also.
The datawindow where the SP could originally not be found, defies
re-creation, failing with the error 'ORA-24334 no descriptor for this
position'.
Seems like something may have gone wrong during migration???
We are hoping not to have to re-create every one of our datawindows, as
this would represent a HUGE task.
________________________________________________________________________
Wholesale Jewelry
Edited by: 1005170 on May 10, 2013 12:05 AM