Call a PL/SQL-Function out of KNIME

KNIME Analytics Platform
3

Hi Gabriel,

thank you for your reply to the topic but it does not answer my question. I will give an example of what i am trying do to.

I would like to execute a snippet of code that would be executed in SQL Developer or TOAD like this:

begin
  package_name.function_name('Param1','Param2');
end;

This function returns OK or FAIL. Can you tell me how i could execute this PL/SQL block prior to execute a SQL statement in KNIME ?

I think it is not possible to execute this block with the Database Connector Node by typing it into the SQL Statement field.

Thanks in advance
Thomas