Using Windows 10, PB 2017 R3 Build 1858 (trial for a Proof of Concept), Oracle 11G and the Oracle Instant Client 18.3 64 bit
For the PowerServer side, using a Native Interface Oracle 10g/11g/12c transaction.
I'm using oracle stored procedures to update data in the app I help support. We use the following call format in PowerServer, it works fine in PB, but in PowerServer when I execute:
declare sp_x procedure for sp_x ( :ls_1, :ls_2, :ls_3, :ii_num) USING SQLCA;
I am getting this error:
Failed to convert parameter value from a String to a Decimal.
The three strings are all under 100 chars in length.
I have also tried to run these using 'execute immediate', and receive the same error.
Thoughts on how to get this going?