Describe the problem/error/question
I’m unable to execute multiple sql statements one after another or PL/SQL in a single node.
What is the error message (if any)?
Please share your workflow
set serveroutput on format wrapped;
DECLARE
v_new_id NUMBER; – Declare a variable to hold the returned ID
BEGIN
INSERT INTO schema.test_table (ID,NAME)
VALUES (schema.test_SEQ.NEXTVAL,‘test type’) – Assuming ID is from a sequence
RETURNING ID INTO v_new_id;
COMMIT;
DBMS_OUTPUT.PUT_LINE('Inserted ID: ’ || v_new_id);
END;
(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.105.3 - Database (default: SQLite): oracle
- n8n EXECUTIONS_PROCESS setting (default: own, main):
- Running n8n via (Docker, npm, n8n cloud, desktop app): npm
- Operating system: mac os