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

Resolved Oracle Procedure Call with Array Parameters

  1. Issue
0
Votes
Undo
  1. Clint Maxwell
    Clint Maxwell
  2. PowerBuilder
  3. Wednesday, 26 June 2019 14:54 PM UTC


We are using PB2017R2, running against an Oracle database. We have a local external procedure call that uses array parameters, both in and out. We began testing Oracle 18c recently, and post-upgrade we found that this procedure started failing with an error:

ORA-00932: Inconsistent Datatypes: Expected %s, received %s


This looks to be exactly the same problem outlined by Frank Louis last November at the following link:

https://community.appeon.com/index.php/qna/q-a/pb-2017-with-oracle-18c?limitstart=0#reply-10516

 

Has anyone had a look, any update for this, or workarounds? Thanks!

  1. Array
  2. Oracle
Copying datawindows
DataWindow Computed Field Question
Responses (2)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 26 June 2019 15:54 PM UTC
  2. PowerBuilder
  3. # 1

Hi Clint;

  O18C is not officially supported yet in PowerBuilder ... even in PB2019.

FYI: https://www.appeon.com/support/documents/appeon_online_help/pb2019/connecting_to_your_database/ch11s01.html

Regards ... Chris

Comment
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Sunday, 30 June 2019 13:29 PM UTC
But strangely enough it is said to be supported in SnapDevelop and the generate DataModel stuff

:s

regards,

MiguelL
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Sunday, 30 June 2019 16:36 PM UTC


Correct, but .... that is a different product which uses different (.Net Core) DB connectivity drivers.
  1. Helpful
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Sunday, 30 June 2019 19:34 PM UTC
True, but confusing. It would be nice if DB versions would be supported equally over all Appeon's products. I understand that it might be difficult though.
  1. Helpful
There are no comments made yet.
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Sunday, 30 June 2019 19:49 PM UTC
  2. PowerBuilder
  3. # 2

I assume you already have "PBNewSPInvocation='Yes'" in your dbparm connection string? 

If not, try adding it, it might (just might), solve the problem.

 

HTH

Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Tuesday, 2 July 2019 15:18 PM UTC
Hi Miguel;

FYI: That parameter only applies to ODBC connections & not native Oracle.

Regards ... Chris
  1. Helpful
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Tuesday, 2 July 2019 16:01 PM UTC
Ah, yes you're right: I was thinking I used it, but that was only in a small app which I used to show problems and differences between ODBC, JDBC and Native drivers. Sorry for the misleading info.
  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.