Problem with the stored procedure call to Oracle

From Support

If you have a question or seek clarification, please call Technical Support.

Problem:

I am having a problem with the stored procedure call to Oracle. I am getting the following error.

-2147217900 [Oracle][ODBC][Ora]ORA-00900: invalid SQL statement

This is a simple stored procedure with no paramaters or result sets. It is used to clear some Oracle files before I start inserting data from the AS/400.

 *                  call CLEAR store procedure
c                   eval      rtn = SQL_RunSPBasic(SQL_Socket:
c                                   'ClearOrders')

I did not write the stored procedure and I do not have direct access to the Oracle server. I know the connection is good because I can wite to and read from the Oracle files within the same program that is calling the stored procedure.

Solution:

SP_RunSPBasic does not appear to work with the Oracle database stored procedure calls.

User was calling the SQL_RunSPBasic function. They should use the SQL_RunSP function instead.