We have a working PB2022 application and when used as client/server it works fine as 32/64 bit. The database is Oracle19.
When deployd to PowerServer environment, the stored procedur used in DW's to retrieve data give an error. regardled of the procedure, the error is always the same, ORA-006550:line 2, column x, where x is different.
A dw where the data is retrieved from the database using SQL works fine.
To test this I created a simple stored procedure
CREATE PROCEDURE PB_TEST(RecCur IN OUT SYS_REFCURSOR)
OPEN RecCur FOR
SELECT TO_CHAR(SYSDATE,'YYYY-MM-DD HH24:MI:SS') AS T FROM DUAL;
and a DW that uses that procedure. Then retrieved the data using the following code
rc = dw_test.Retrieve()
As client/server it worked ok. When doing the same using PowerServer, it returnned the ORA-006550 error
The error message comes before the MessageBox("SQLErrText", SQLCA.SQLErrText), which return null string. The rc, coming from PB, returns -1.
Am I missing some configuration settiong or what might cause this behaviour or how to fix this?