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)
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Sunday, 30 June 2019 19:49 PM UTC
  2. PowerBuilder
  3. # 1

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.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 26 June 2019 15:54 PM UTC
  2. PowerBuilder
  3. # 2

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.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.