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

Resolved Stored procedure call on Oracle 12c client

  1. Issue
0
Votes
Undo
  1. Jon Tzeng
    Jon Tzeng
  2. PowerServer 2020 or older (Obsolete)
  3. Thursday, 1 September 2022 20:18 PM UTC

Hello,

We have a PowerServer 2020 installed and connect Oracle by using 64-bit Oracle 11.2 client. Since Oracle 11.2 is going to end of life. We are testing to use Oracle 12c client. We found there is an issue on executing a Stored Procedure. The stored procedure would return several values and return values are cutting off. Is there any setting we need to do regarding to this issue?

Thanks,

Jon

Powerserver 2020 connecting to SQL2019
Barcode scanner issue
Responses (4)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 1 September 2022 20:24 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 1

Hi Jon;

   Are you on the latest version of PS2020 - build 2279?

Regards .. Chris

Comment
There are no comments made yet.
Jon Tzeng
Jon Tzeng Accepted Answer Pending Moderation
  1. Thursday, 1 September 2022 20:50 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 2

No, we are in 2703 build.

Comment
There are no comments made yet.
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Friday, 2 September 2022 06:33 AM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 3

What version is your database on the server? If I remember well there's some bugs with the 12c client, depending on which version you're running of that client. Try using a newer client like 19c?

regards,

MiguelL

Comment
There are no comments made yet.
Olan Knight
Olan Knight Accepted Answer Pending Moderation
  1. Friday, 2 September 2022 14:02 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 4

Jon -
   You said that your Oracle client for 11.2 was 64 bit. Does that mean your application is also 64 bit?

   If not, please try using the Oracle 12C 32 bit client.

Comment
Andreas Mykonios
  1. Andreas Mykonios
  2. Friday, 2 September 2022 14:34 PM UTC
Hi Olan.

The question is about Powerserver 2020, which can be x64, so it can work with x64 drivers...

Andreas.
  1. Helpful 1
Olan Knight
  1. Olan Knight
  2. Friday, 2 September 2022 15:19 PM UTC
Ah, thank you Andreas!
  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.