Data360 Analyze

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
------------------------------

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
------------------------------

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
------------------------------