Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (1)

Resolved Error after migration -functions /procedures with collections

  1. Issue
0
Votes
Undo
  1. Michał Gamus
    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


  1. Collection
  2. Migration
  3. PowerBuilder
"Dark Mode"
RightFax(10.6) is not working with PB2022
Responses (1)
Chris Pollach @Appeon
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
Andreas Mykonios
  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
Michał Gamus
  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
Chris Pollach @Appeon
  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.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.