Re: Question about OCI fetch

Do you have the fourth argument 'iters' set to 1. The OCIStmtExecute will fetch 1 row if it is. Set it to 0 and you should get the behaviour you expect.

By the way it is in the manual ;)(last paragraph under OCIStmtExecute.) The is a much clearer explanation there.

Cheers,
Stuart.

On Fri, 23 May 2003 10:44:56 +0800, music4 wrote:

> Hello,
>
> After using OCI about 1 year, I'm a little confused now. In OCI programing,
> say I define a select statment, if the select statement only return one
> record, or I only want to get the first record, then I don't need to do
> fetch. But if I want to get several records, then I have to use fetch in
> loop.
>
> My confuse is that, since even if I don't do fetch, I can get the first
> record, does that mean first call to fetch don't do fetch since the fist
> record has been fetched?
>
> It seems it's a silly question. But I'm really confused. Please help me get
> out this puzzle! Thanks in advance!
>
> Evan
Received on Fri May 23 2003 - 05:53:07 CDT