Where to find a sample on accessing Oracle data as result sets from
PL/SQL block using OCI in C++ environment.
Accessing Oracle data using OCI from a PL/SQL Block(stored procedure).
The query is calling the PL/SQL block by binding and defining in/out parameters.
The block returns a ref cursor which contains the reference to the
requested object.
The data from the cursor can be fetched into the object. The object
can be retrieved and put into local variables.