| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> re-binding variables in OCI statements
In order to avoid re-defining the whole statement I want to re-bind
only one variable, specifing a different size and a diferent variable
data address. I did some tests and this seems to be working OK,
although I'm still not sure if it's officially supported. Can anyone
confirm/deny that?
Also, if it's supported, should I free the bind handle (the second
param to OCIBindByPos) before another call to OCIBindByPos? Purify
reports no leaks and no double memory frees regardless if I do free
the bind descriptor or not. Is Oracle smart enough to figure out that
the memory has already been allocated for this bind handle?
sword OCIBindByPos ( OCIStmt *stmtp,
OCIBind **bindpp,
OCIError *errhp,
ub4 position,
dvoid *valuep,
sb4 value_sz,
ub2 dty,
dvoid *indp,
ub2 *alenp,
ub2 *rcodep,
ub4 maxarr_len,
ub4 *curelep,
ub4 mode );
Received on Fri Sep 27 2002 - 13:50:55 CDT
![]() |
![]() |