The title pretty much explains the purpose! So, I’m moving on to the sample. We are using ballerinax/jdbc package here.
Ballerina version: 0.990.3Oracle database version used: Oracle-xe-11g
Ok, we are going write a simple HTTP service with Ballerina that exposes stored procedures/functions in an Oracle PL/SQL package!
We are going to try out a simple example of how to call a stored procedure in Oracle which has a refcursor OUT parameter, with Ballerina programming language.