Pro*C interface with generic REF CURSOR

From: Crackin' 40's <c014572_at_yahoo.com>
Date: 18 Apr 2005 10:03:57 -0700
Message-ID: <1113843837.873139.123640_at_z14g2000cwz.googlegroups.com>

We have a need to code a generic reporting mechanism that calls vendor supplied stored procedures and gets the results back in a REF CURSOR.

I don't have issues with calling the stored procedure, but I cannot find an example on how to get the datatype, column name, and value from the ref cursor returned.

All the Pro*C examples show you having the SQL statement as a starting point. I will know nothing about the SQL statement, I'll be given a "live wire" open cursor to use.

You must be able to do this in some manner, as I can call the procedures from PL/SQL and print the result swith "print".

Thanks,
Tom Received on Mon Apr 18 2005 - 19:03:57 CEST