Problem
You get the following error with the stored procedure call to Oracle:
-2147217900 [Oracle][ODBC][Ora]ORA-00900: invalid SQL statement
You can write to and read from the Oracle files within the same program that is calling the stored procedure. It is a simple stored procedure with no paramaters or result sets and uses the SQL_RunSPBasic function. For example: To clear some Oracle files before inserting data from the iSeries:
* call CLEAR store procedure
c eval rtn = SQL_RunSPBasic(SQL_Socket:
c 'ClearOrders')
Solution:
The SP_RunSPBasic function does not work with the Oracle database stored procedure calls. Use the SQL_RunSP function instead.
Last Modified On:
No, open a new Support Case