Hi All,

I am using PowerBuilder 2019R2 build 2353 and Oracle 19C.  Recently we upgrade our database from Oracle 12 to 19.  

I have procedure which OUT parameter is date table type. before database migration its return proper value in PB's datetime variable but after migration to 19 C it shows error as "ORA-01866 - the datetime class is invalid". Please help.

Procedure Script:

   TYPE adt_crt_dt_type IS TABLE OF DATE INDEX BY BINARY_INTEGER;

procedure test_mk (rltn_nbr IN Number, ret_date OUT adt_crt_dt_TYPE)
as
Begin
ret_date(1) := sysdate;
end test_mk;

PowerBuilder Script:-

define subroutine in Local external function:-

subroutine test_mk ( decimal third_pty_rel_seq_nbr, ref datetime ret_date[] ) RPCFUNC ALIAS FOR "MLEQ.PKG_CHANGE_HISTORY.test_mk";

Call in process as:

datetime ld_datetime[1]

sqlca.test_mk(242321595,  ld_datetime)
if sqlca.sqlcode <> 0 Then
messagebox('error',sqlca.sqlerrtext)
return 1
end if