1. Fabienne Peraldi
  2. PowerBuilder
  3. Monday, 27 November 2023 16:37 PM UTC

Hello

I just migrated my project on Oracle 19C and I have an issue with table of strings.

When PB call my stocked procedure with an array in entry that doesn't work, there is a problem.

Please can you give idea to solve this problem.

Thank you very much

 More information :

Code source PB : => this call doesn't work whereas on Oracle 12.2.0.1 this call works, the program doesn't enter in my stored procedure

SQLCA.PSS_FACT_ALL (es_param)
      If Left(es_param[10],5) = 'ERROR' Or Len(Trim(es_param[10])) = 0 Then
        gnv_factu.Of_MessageBox ("Erreur bloquante", s_Name, s_Event, &
                         "Problème de récupération de la date de clôture de la prestation de nivellement" +&
                         "~r~n~r~nCause : " + Right(es_param[10],Len(es_param[10])-8) +& 
                         "~r~nContacter la ME...")

Code source Oracle :

create or replace PROCEDURE "PSS_FACT_ALL"
(
es_param IN OUT intra.p_tab_v2)
IS

where p_tab_v2 is

type p_tab_v2 is table of varchar2(100) index by binary_integer;

We have this error :

 

 

 

 

Fabienne Peraldi Accepted Answer Pending Moderation
  1. Tuesday, 28 November 2023 09:17 AM UTC
  2. PowerBuilder
  3. # 1

Hello

We are using 12.2.0.1 Oracle client.

Best regards

 

Comment
  1. Chris Pollach @Appeon
  2. Tuesday, 28 November 2023 19:38 PM UTC
I would then suggest upgrading to the O19C DB client & then retesting.

Normally, the DBMS Server & DB Client should always be the same version & build (no matter what the DBMS vendor is).
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Monday, 27 November 2023 20:55 PM UTC
  2. PowerBuilder
  3. # 2

Hi Fabienne;

   Are you using the O19C native client software from Oracle?

Regards ... Chris 

Comment
There are no comments made yet.
John Fauss Accepted Answer Pending Moderation
  1. Monday, 27 November 2023 18:47 PM UTC
  2. PowerBuilder
  3. # 3

Hi, Fabienne -

I'm NOT an Oracle user/developer, but in looking at this similar post:

    https://community.appeon.com/index.php/qna/q-a/ora-01024-invalid-datatype-in-oci-call-oracle-19-server-pb2019-r2-build-2353

you may wish to consider opening a bug ticket.

    https://www.appeon.com/standardsupport/newbug

Best regards, John

Comment
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.