'Get Output of stored procedure using PutSql in Nifi

I have to get the output of Oracle stored procedure in Nifi. I've tried PutSql with the following sql statement :

declare out VARCHAR2 ; begin PKG_TEST.P_TEST(1,out); end;

It works fine but it just executes the script. How can I get the value of output 'out' ?

Thank you!



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source