DevOps, CI/CD and Automation

Hi,
I'm developing an interface to access data from Oracle using OCI. Since this is an interface, all the calls to the database is more or less dynamic. Same is the case with stored procedures. I'm having a hard time binding the output variables of the stored procedures. Is there a way to get the IN, OUT and IN/OUT parameters of a stored procedure from the database ? How can I execute the stored procedures dynamically, through OCI and get the data back ? Is there any sample programs ?

Any help is appreciated.

Thanks
Manoj Thoniyil