Error -2147217900 with the stored procedure call to Oracle

Problem

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: