Questions? Feedback?powered byOlark live chat software
Bug 2931

Oralce 18c: Error calling PC with string arrays 18 December, 2019

Michael Doescher
24 June, 2019
Product: PowerBuilder Category: Database
Version: 2019 Publishing: Public
Classification: Priority: P1
Status: Analyzing Reason:
Ken Guo 18 December, 2019
Hi Michael,
  
Good news that Appeon PowerBuilder 2017 R3 MR (build 1915) has been officially released. The issue you reported has been fixed in this release. Please download and install it to verify your reported issue and let us know if any problems. 

You may download and install this latest release from our Downloads portal at https://www.appeon.com/user/center/index?menu=download (login required) or you may manually go to the Downloads portal from Login (to the Appeon Website) > User Center (under your login user icon) > Downloads. 

Upgrade Notes:
If you are currently using PowerBuilder 2017 R3 (build 1858 or 1880), please directly apply this MR (build 1915) on top of your current PowerBuilder 2017 R3. 
If you are currently using PowerBuilder 2017 or 2017 R2, please first upgrade your current PowerBuilder 2017 or 2017 R2 to PowerBuilder 2017 R3 LTS Build 1858 and then apply this MR (build 1915). 

We welcome all feedback from you!

Regards,
Ken
Ken Guo 24 June, 2019
Oracle 12c works

Hi Michael,

I verified your test case with Oracle 12c and it works fine (see attached). Please let us know if it works fine with Oracle 12c on your side too?

For Oracle 18c, PB 2017/2019 doesn’t officially support it yet. I will submit this issue to our development team. They will analyze this issue once it is decided to support Oracle 18c. 

Regards,
Ken
Ken Guo 24 June, 2019
Hi Michael,

I'm working on analyzing your case. I will keep you posted of the results here.

Regards,
Ken
Michael Doescher 24 June, 2019
data_binding.zip (136KB)

Hallo Appeon support team,

*Phenomenon:
We use arrays in our remote procedure calls (RPCs) to Orcale.
We seem to have a problem with string arrays in our calls to Oracle 18c and hope you can help us.

*Reproduce Steps:
We have created an example to demonstrate this problem.

To use this example, please install in an Oracle 18c Databank our Package found in the ../sql folder.
If needed to comapre, you can also install it in an Oracle 12c Databank.

Our demo EXE "data_binding.exe" was build with PowerBuilder2019 build 2082 and can be found in the ../exe_PB19_2082 folder.

To test this problem, you must first connect to the Databank using the "DB connect" button.
Only when the connection is successfull are the two Test buttons enabled.
To demontrate that we only have a problem with string arrays, we added a test call with a number array for comparision.

Remarks:
We would be very greatfull if you can check this.

Kind regards
i. A. Michael Döscher
Software Development
IMS GmbH, Germany
OS:
Windows 10 
Platform:
64-bit 
Database Type:
Oracle 
Database Version:
18c