1. Michał Gamus
  2. PowerBuilder
  3. Monday, 23 January 2023 10:47 AM UTC

Hi
After Oracle migration to 19c, there is a problem with comunication PB-> Oracle.

When function has in f.e. table of strings in declaration, PB throws an exception

ORA-00932: inconsistent datatypes: expected %s got %s.

I tried to remove this collection from declaration and oracle function - and it works.


PB: string p_tab_val[]

Oracle:  type tab_val is table of varchar2(30) index by binary_integer;

Anyone has an idea?

Powerbuilder 2017 R3 BUILD 1858

EDIT:

I've updated Oracle client to 19c, powerbuilder to 1951 based on this article:https://community.appeon.com/index.php/qna/q-a/oracle-19c-compatible
still not working


Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Monday, 23 January 2023 14:39 PM UTC
  2. PowerBuilder
  3. # 1

Hi Michal; 

   Oracle 19C compliance was not supported in that release.

FYI: O19C compliance was added to PB 2017 R3 in build 1915 (Dec 2019) and PB 2019 build 2170 (Dec 2019). Both of those releases were MR's. 

  Since PB 2017 & most PB 2019 releases are no longer supported, I would recommend upgrading to either PB 2019 R3 or higher to get proper O19C support plus a supported PB release as well.

Regards... Chris 

 

Comment
  1. Andreas Mykonios
  2. Monday, 23 January 2023 15:06 PM UTC
Well 2017 R3 1915 should be under support until 2023.07.31...

Andreas.
  1. Helpful 1
  1. Michał Gamus
  2. Monday, 23 January 2023 15:25 PM UTC
I've installed PB 2019 R3 Build 2779, and it still shows me this error
  1. Helpful
  1. Chris Pollach @Appeon
  2. Monday, 23 January 2023 16:47 PM UTC
Hi Andreas;

The key is that those old releases are "out of maintenance". Which means no more fixes. While "end of support" means that we'll try to give you a "workaround" if possible but we're not patching anymore.

Personally, I would even try moving to PB 2022 as Appeon has made numerous Oracle driver fixes in v2021 & 2022 that are not in any 2017 release.

@Michal - your O19C error though may be all DBMS version related - so some DML refactoring might be required.

Regards ... Chris
  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.