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

first you have to find out how many columns the result set has: attached file line 521: OCIAttrGet( ..., ..., ..., ..., OCI_ATTR_PARAM_COUNT, ... ); second you ask for each coltype:
attached file line 562+: OCIParamGet(...

have fun
markus

Sebastian Corbay wrote:
>
> 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!