- Suvendu Dey
- PowerServer
- Tuesday, 22 March 2022 02:33 PM UTC
We are progressing with our POC and hit an issue with an Oracle RPC call. This issue occurs in the initial screen of our main application processing and this is stalling our POC progression.
When we call this particular RPC, we are getting an error in the Web API console - "Input string was not in a correct format."
Details:
Dummy Declaration:
p_application(Integer S, String M, String A, String Mt, String Adv, String Fo, String sUs, Date Pro, String sA, Long bat, Ref Long out_bh_s, Ref Long status, Ref String msg) RPCFUNC ALIAS FOR "pack.proc"
API calling parameter:
SqlParameters": [
{
"Direction": null,
"Category": 1,
"ParameterName": "name",
"ParameterType": "int",
"ParameterValue": 1
},
{
"Direction": null,
"Category": 1,
"ParameterName": "name",
"ParameterType": "string",
"ParameterValue": "Data"
},
{
"Direction": null,
"Category": 1,
"ParameterName": "name",
"ParameterType": "string",
"ParameterValue": "Data"
},
{
"Direction": null,
"Category": 1,
"ParameterName": "name",
"ParameterType": "string",
"ParameterValue": "Data"
},
{
"Direction": null,
"Category": 1,
"ParameterName": "name",
"ParameterType": "string",
"ParameterValue": "Data"
},
{
"Direction": null,
"Category": 1,
"ParameterName": "name",
"ParameterType": "string",
"ParameterValue": "Data"
},
{
"Direction": null,
"Category": 1,
"ParameterName": "name",
"ParameterType": "string",
"ParameterValue": "Data"
},
{
"Direction": null,
"Category": 1,
"ParameterName": "name",
"ParameterType": "date",
"ParameterValue": "2016-05-16"
},
{
"Direction": null,
"Category": 1,
"ParameterName": "name",
"ParameterType": "string",
"ParameterValue": "Data"
},
{
"Direction": null,
"Category": 1,
"ParameterName": "name",
"ParameterType": "long",
"ParameterValue": 1
},
{
"Direction": null,
"Category": 1,
"ParameterName": "name",
"ParameterType": "long",
"ParameterValue": 0
},
{
"Direction": null,
"Category": 1,
"ParameterName": "name",
"ParameterType": "long",
"ParameterValue": 0
},
{
"Direction": null,
"Category": 1,
"ParameterName": "name",
"ParameterType": "string",
"ParameterValue": " "
}
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.