RapidMiner 9.7 is Now Available

Lots of amazing new improvements including true version control! Learn more about what's new here.

CLICK HERE TO DOWNLOAD

Execute SQL Operator - Calling Oracle Stored Procedure - Invalid SQL Statement

SUPSONSUPSON Member Posts: 2 Newbie
edited June 8 in Help
Trying to call an Oracle stored procedure using the Execute SQL operator and getting
Database error occurred: ORA-00900: invalid SQL statement.

The SP I'm trying to call is located within the schema that I've configured the connection for.
I can execute the SP successfully while connected via SQL Developer.

I've tried:
EXECUTE <SP_NAME>
EXECUTE <SCHEMA>.<SP_NAME>
EXEC <SP_NAME>
EXEC <SCHEMA>.<SP_NAME>

I was able to successfully run SELECT SYSDATE FROM DUAL using Execute SQL operator.

Thanks in advance.

Tagged:

Best Answer

Answers

  • SUPSONSUPSON Member Posts: 2 Newbie
    Got it to work...mostly. I used a test stored procedure that had a date in the where clause and I was getting an error around that. Once I changed the query and removed the date reference (just to see if I can even get the StoredProc to run), I was successful in getting the stored procedure to be called. Thanks for the help!
Sign In or Register to comment.