SQL> variable v_cur refcursor
SQL> exec open :v_cur for select dname,loc from dept;

PL/SQL procedure successfully completed.

SQL> set markup html on spool on
SQL> print v_cur
<br>
<p>
<table border='1' width='90%' align='center' summary='Script output'>
<tr>
<th scope="col">
DNAME
</th>
<th scope="col">
LOC
</th>
</tr>
<tr>
<td>
ACCOUNTING
</td>
<td>
NEW YORK
</td>
</tr>
<tr>
<td>
RESEARCH
</td>
<td>
DALLAS
</td>
</tr>
<tr>
<td>
SALES
</td>
<td>
CHICAGO
</td>
</tr>
<tr>
<td>
OPERATIONS
</td>
<td>
BOSTON
</td>
</tr>
</table>
<p>

SQL&gt;