-
Kari Paukku
- PowerServer
- Sunday, 25 September 2022 12:51 PM UTC
Hi,
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)ISBEGIN
OPEN RecCur FOR SELECT TO_CHAR(SYSDATE,'YYYY-MM-DD HH24:MI:SS') AS T FROM DUAL;
END;
and a DW that uses that procedure. Then retrieved the data using the following code
int rcdw_test.SetTransObject(SQLCA)rc = dw_test.Retrieve()
MessageBox("rc",rc)MessageBox("SQLErrText", SQLCA.SQLErrText)
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?
Thanks,
Kari
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.