Describe the problem/error/question
We are using the 'Oracle Execute SQL' module to try run a stored procedure, however it fails, when trying to execute it using n8n.
When we run normal SQL commands like 'select * from Uk.employees" it returns a result but when we try run a SP like
Begin
uk.changeEmplyee_name;
End;
We get a ORA-06550 error in the output, when if we run same thing ins SQL Developer it runs fine.
I was wondering if anyone has had same issue, is it limitation or is there specific syntax that is required?
What is the error message (if any)?
ORA-06650
Please share your workflow
(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)
Share the output returned by the last node
Information on your n8n setup
- n8n version: 1.121.3
- Database (default: SQLite): Oracle 19c Standard
- n8n EXECUTIONS_PROCESS setting (default: own, main):
- Running n8n via (Docker, npm, n8n cloud, desktop app):
- Operating system: Window