-
Bryant Burnard
- PowerServer
- Thursday, 23 June 2022 04:15 PM UTC
Using PowerServer 2021 in local deploy, PowerBuilder version 2021 Build 1506 in an Oracle 19 backend. I am working with Don C of Intertech to check my work.
We are using one procedure within a package to cover Update / Insert / Delete within a stored procedure update on datawindows. This works fine within the PB 2021 client, but in a deploy to PowerServer 2021 we are getting an error. The call is:
pkgpm_table_tnx.ModifiyTableTnx ( update_mode, value1, Value2, ... ), where the update_mode is a character value of I / U / D.
and we get the following error:
dbug: PowerServer[0]
Non Db Transaction Request, Transaction Id: 'D544CE44-B218-4163-B46E-FDC1B3D0DE03-1', Transaction Status: 'Created', Transaction Last Visit Time: '2022-06-23 4:11:39 PM', Namespace Name: 'Pvr', ModuleOrModel Name: 'd_province', DbRequest: 'DataStore_Update', NonSelectCommandWasExecuted: 'True'
dbug: PowerServer[0]
ModuleOrModel Name:'d_province', SqlId:'', SqlStatement:'PKGPM_PROVINCE_TNX.SELECTPROVINCETNX;1 :AC_RESULT'
fail: PowerServer.Api.ServerApiController[0]
'PowerServer.Api.ServerApiController.DataStoreUpdate (PowerServer.Api)' get result ({
"IsSuccess": false,
"ErrorCode": 0,
"ErrorMessage": "Stored procedure update does not support the use of non-column data sources",
"Version": null,
"RequestId": null,
"AppName": null,
"Session": {
"ErrCode": 0,
"ErrMsg": null,
"SessionId": "F7CB0C2E-81AB-4C7F-BDB9-0EBE62AB20D9"
},
"Type": 0,
"Transaction": {
"TransactionId": null,
"SQLCode": -1,
"SQLDBCode": -1,
"SQLErrText": "Stored procedure update does not support the use of non-column data sources",
"SQLNRows": 0,
"SQLReturnData": null
},
"Content": {"Event": {"DbError": {"SqlDbCode": -1,"SqlErrText": "Stored procedure update does not support the use of non-column data sources",
"SqlSyntax": null,"DwBuffer": 0,"RowId": 0}},"Responses": null},"Namespace": null}).
Is there a way or setting that can be used to support the existing code with out a re-code?
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.