1. Aurangzeb Qaimkhani
  2. PowerBuilder
  3. Thursday, 14 December 2023 19:32 PM UTC

Hey guys,

Our company is in process of upgrading to oracle v19c. is there any known dependencies, conflicts, and resolutions including oracle client & Oracle database drivers version needed to upgrade PowerBuilder 2022 Build 1900 applications to oracle v19c. 

Thanks,

Zeb Qaimkhani

Bruce Armstrong Accepted Answer Pending Moderation
  1. Friday, 15 December 2023 17:53 PM UTC
  2. PowerBuilder
  3. # 1

The only issues I've ever had with upgrading Oracle versions was triggered by changes in Oracle.  For example, DBMS_OBFUSCATION_TOOLKIT get's deprecated and DBMS_CRYPTO needs to be used instead.  (https://oracle-base.com/articles/8i/data-encryption).  In another case, one of our developers decided to use an internal, not officially supported Oracle function called WM_CONCAT.  Great until Oracle eventually removed it (https://oracle-base.com/articles/misc/string-aggregation-techniques#wm_concat).  So it's a matter of reading through the Oracle docs to see what got removed between the version you're currently using (which you didn't mention) and 19c.    Also, you might migrate a test database to 19c, run through your application against it and see what breaks.  Good time to have something like AscentialTest (https://zeenyx.com/automated-testing-tool/) in place so that you can automate such end to end testing whenever considering upgrades like this.



Comment
There are no comments made yet.
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Thursday, 14 December 2023 20:16 PM UTC
  2. PowerBuilder
  3. # 2

PowerBuilder 2022 does support Oracle 19c.  However, the quality of PB 2022 R3 should be better and it has long-term support (at least 5 years).  So I would recommend rolling out your Oracle 19c upgrade together with the R3 long-term support version of PB 2022.

Comment
  1. Aurangzeb Qaimkhani
  2. Friday, 15 December 2023 17:20 PM UTC
I think you misunderstood my question, we already upgraded the oracle database from 12c to 19c, we need to know what changes do we need to make in PB 2022 (build 1900) application, and what are dependencies, including oracle clients etc.

Thanks.
  1. Helpful
  1. Armeen Mazda @Appeon
  2. Friday, 15 December 2023 18:52 PM UTC
Changes you need to make to your SQL depends on Oracle changes. As Bruce mentioned refer to Oracle docs.
  1. Helpful
  1. Aurangzeb Qaimkhani
  2. Monday, 18 December 2023 14:37 PM UTC
we are all done upgrading SQL/oracle 19c, now question is do I need to make any changes to Power builder 2022 applications ?
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.