This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
When running a workflow with an Input or Output Data tool and trying to execute a procedure via the Pre or Post SQL Statement section, the following error occurs:
ORA-00900: invalid SQL Statement
CALL SCHEMA.MYPROC(10, 20, my_var)
This was extremely helpful. I created a brand new procedure to simply truncate the table before I load it again.
One thing I forgot was to make sure my database user had the proper grants on the proc.
I was able to execute the procedure from SQL Developer but Alteryx kept throwing an error, invalid object.
Added grants, now it works!