OCI - How do I retrieve result columns from a 'SELECT * FROM MYTABLE' statement

Home -> Community -> Usenet -> c.d.o.server -> OCI - How do I retrieve result columns from a 'SELECT * FROM MYTABLE' statement

From: Sebastian Corbay <scorbay_at_netsize.com>
Date: Wed, 19 Jan 2000 19:40:07 +0100
Message-ID: <38860507.2BD02AD6@netsize.com>

I use OCI to get rows from a table on Oracle 8. I successfully, connect to the server, prepare the statement, execute this statement, but...

I don't know how to get the results.

The problem is that I cannot set local variables (with OCIDefineByPos) to retrieve value through an OCIFetch, because I do not know how many columns are returned and the type of these columns. I read the Oracle Call Interface Programmer’s Guide, but I did not find anyway how to get information about the results returned.

What am I supposed to do?

Thank in advance for your help! Received on Wed Jan 19 2000 - 12:40:07 CST