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.

Still have questions? We can help. Submit a case to Technical Support.

Last Modified On: December 10, 2016