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
![]() |
![]() |