Options
Execute SQL Operator - Calling Oracle Stored Procedure - Invalid SQL Statement
NewbieTrying 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.
0
Best Answer
-
Options
dfostr
Member Posts: 3 
Contributor I
Hi. I had the same issue and found a working solution on Stack Overflow (I can't post the link but search for answer # 47134774) - it seems JDBC does not recognize EXEC so instead wrap your SP within an anonymous PL/SQL block, i.e.:
BEGIN
<SP_NAME>
END;
5
Answers