re-binding variables in OCI statements
From: Tomasz Romanowski <tromanow_at_hotmail.com>
Date: 27 Sep 2002 11:50:55 -0700
Message-ID: <84e67408.0209271050.5c37dfeb_at_posting.google.com>
Date: 27 Sep 2002 11:50:55 -0700
Message-ID: <84e67408.0209271050.5c37dfeb_at_posting.google.com>
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 - 20:50:55 CEST
