Precompilers and OCI (MOSC)

MOSC Banner

Any size limit when binding BLOB parameter using SQLT_LBI?

edited Nov 8, 2011 4:21PM in Precompilers and OCI (MOSC) 4 commentsAnswered
I called OCIBindByPos() to bind one BLOB parameter, and set value_sz to the actual size of some buffer in my application, indp and alenp to NULL, and dty to SQLT_LBI.It worked before I tried to set value_sz greater than 64K.
When value_sz is greater than 64K, looks like the length of buffer put into DB is random.

Is there such limit of size?

thanks in advance!

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 );

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center