Hello,
We have PowerServer 2022 R3 application and Oracle 19 database and we get error when executing a simple statement. Here is what we find on the powerserver.log Could you help to identify what the issue is? Thanks
-----------------------------------------------------------------------------------------------
2024-02-29 14:25:35,488 ERROR PowerServer.Api.ServerApiController.? [?] - MESSAGE: DynamicOpenCursor(80000484-0000-ed00-b63f-84710c7967bb)(2024-02-29 08:25:35.4888526): get result (
{
"IsSuccess": false,
"AppName": "ABC",
"NameSpace": "ABC",
"Type": "DynamicOpenCursor",
"SessionId": "61C208C9-A3F3-4DAE-855E-A95A912948BA",
"TransactionId": "B4260CCB-E844-4E61-915B-239654774448-2",
"TransactionName": "sqlca",
"SqlStatement": "SELECT COUNT(*) INTO :li_count FROM \"AIM00\".\"T_TABL\" WHERE \"SCH00\".\"T_TABLE\".\"SAK_NO\" = 12345",
"Content": {
"ResultSets": []
},
"ErrorCode": -1,
"ErrorMessage": "TTCExecuteSql:ReceiveExecuteResponse - Unexpected Packet received."
}).