Re: HELP! OCI

T.Merlin wrote:
>
> Hi,
> I want to know the max pos after function oparse().
> Example :
> SELECT ename FROM emp ; pos=1
> SELECT ename,job FROM emp ; pos=2
> .....
> Did oparse() give me the max number pos ?
> Thanks for your help.
> --
> Thierry Merlin

i think you mean that you want to know how many columns are selected by this query.
The only way to determin this is to do a loop with odescr, incrementing the position with one until you get an oracle-error ('ORA-???? column not in select list').

--
Gert Rijs
mailto:gem_at_wirehub.net    (at home)
mailto:gert.rijs_at_corp.ah.nl (at work)