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.

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;

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.