Re: OCI - Error in OCIStmtExecute( )

From: DeVerne Coleman <dsleuth_at_worldnet.att.net>
Date: Sun, 11 Apr 1999 21:37:15 -0500
Message-ID: <7ermcl$762$1@bgtnsc01.worldnet.att.net>

I have run into this before. If you look at the Oracle documentation on OCIStmtExecute, there is a parameter called iters. If this is set > 0, a fetch is done at the time the statement is executed. Thus you must have bound the variables to receive the output. If you set it to 0, it should return without fetching a row. Then you can bind your result variables and start fetching.

Hope this helps,

DeVerne Coleman

uri bargil wrote in message <3710C496.6D1DD483_at_trans-planet.com>...
>I'm trying to implement a select statement using the OCIStmtExecute( ).
>
>I'm getting this error : "The error buffer is ORA-24374 : define not
>done before fetch or execute and fetch".
>What is the reason of this problem and how can I solve it ?
>thank you all.
>Uri.
>E - mail : uri_at_trans-planet.com
>
Received on Sun Apr 11 1999 - 21:37:15 CDT