REF CURSOR

[Chao]

Is there an approach to traverse the columns of a ref cursor to extract the column information (i.e. column name and value) in PL/SQL? I can do this with Visual Basic's recordset object. Here's VB code of what I would like to do in PL/SQL:

i.e. set rs = cn.execute("select * from tab&quot
strOutput = ""
for i = 0 to rs.fields.count-1
stroutput = stroutput & rs.fields(i).name & space(5)
next i
while not rs.eof
for i = 0 to rs.fields.count-1
stroutput = stroutput & rs.fields(i).value
& space(5)
next i
rs.movenext
wend
...

 

[vc123]

DBMS_SQL is the only way to handle a result set with
an unknown number and type of columns in PLSQL.

You cannot parse a ref cursor in PL/SQL (although you can in Java, VB, etc.)

Rgds.