Thank you, Peter. It works.
------------------------------
clef andrin
Knowledge Community Shared Account
------------------------------
Original Message:
Sent: 10-17-2023 04:50
From: Peter Sykes
Subject: Proper Syntax to call Oracle Stored Procedure using DB Execute
There are some options, but with a JDBC execute node you can just paste in a valid anonymous PL/SQL e.g. from SQL developer to run it. You don't seem to require any parameters so something like this: Also the JDBC execute node needs an input, even if just dummy data from a create data node.
sql query:
BEGIN
F2();
END;
------------------------------
Peter Sykes
Data Governance & Architecture
Vontobel Holding AG
Zurich
Original Message:
Sent: 10-16-2023 09:33
From: clef andrin
Subject: Proper Syntax to call Oracle Stored Procedure using DB Execute
Hi, how can I properly call the oracle stored procedure using DB execute node? I already tried 'EXEC Schema.PROC', 'EXECUTE Schema.PROC', 'BEGIN Schema.PROC END' but none works. Appreciate the help in advance.
------------------------------
clef andrin
Knowledge Community Shared Account
------------------------------