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


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 this call works, the program doesn't enter in my stored procedure

      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)

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


We are using Oracle client.

Best regards


  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 

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:


you may wish to consider opening a bug ticket.


Best regards, John

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.