on 05-12-2020 01:31 AM - edited on 10-12-2020 01:59 PM by kcsrestapiuser
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()
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!