<div>
<br />
Try this in sqlplus:<br />
<br />

<pre><code id="code-180284">var beta number;
var gamma_list refcursor;
var delta number;
exec :beta:=-1;
exec PROCEDURE ALPHA (:beta,:gamma_list,:delta);
print delta;
print gamma_list;</code></pre>
</div>



Try this in sqlplus:



var beta number;
var gamma_list refcursor;
var delta number;
exec :beta:=-1;
exec PROCEDURE ALPHA (:beta,:gamma_list,:delta);
print delta;
print gamma_list;

<div>
Thank you very much for your kind cooperation! ;-)
</div>


Thank you very much for your kind cooperation! ;-)

<div>
<div class="content wysiwyg-content">
 &nbsp; PROCEDURE ALPHA (<br />
&nbsp; &nbsp; &nbsp; BETA &nbsp; &nbsp; &nbsp; IN &nbsp; &nbsp; &nbsp; NUMBER,<br />
&nbsp; &nbsp; &nbsp; GAMMA_LIST &nbsp; IN OUT &nbsp; c_list,<br />
&nbsp; &nbsp; &nbsp; DELTA &nbsp; &nbsp; &nbsp; OUT &nbsp; &nbsp; &nbsp;INTEGER<br />
&nbsp; &nbsp;)<br />
&nbsp; &nbsp;IS .....<br />
<br />
<br />
The c_list type is REF CURSOR.<br />
<br />
In order to debug, how could I download the c_list content into a table?
</div>
</div>


   PROCEDURE ALPHA (
      BETA       IN       NUMBER,
      GAMMA_LIST   IN OUT   c_list,
      DELTA       OUT      INTEGER
   )
   IS .....


The c_list type is REF CURSOR.

In order to debug, how could I download the c_list content into a table?

Insert an object of type ref cursor into a table ( Oracle PL/SQL )

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.