Hi everyone !
This error is occurred when I call oracle procedure from other programs (PowerBuilder).
My PowerBuilder program
String My_Arr[];
My_Arr(1) = 'TEST'
Call My_Package.My_Proc(My_Arr)
My Oracle package:
TYPE MY_TYPE_ARR IS TABLE OF CHAR(7) NOT NULL INDEX BY BINARY_INTEGER;
PROCEDURE MY_PROC(MY_TYPE IN MY_TYPE_ARR)
IS
BEGIN ... END
When execute PB program, I'm getting ORA-06550 error.
If I change my Package to this, I have no problem.
TYPE MY_TYPE_ARR IS TABLE OF VARCHAR(7) NOT NULL INDEX BY BINARY_INTEGER;
PROCEDURE MY_PROC(MY_TYPE IN MY_TYPE_ARR)
IS
BEGIN ... END
How can I fix this problem if i dont want to change my type to VARCHAR?
Can anyone help me on this problem.
P/S: This problem occurred when I change my oracle to 19c from 11g. 11g version is no problem.
Sorry for my bad english