Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> OCI array of strings bind
Hi,
I'm attempting to bind an array of strings of variable length.
text *textval = "Entry1Entry2"
ub2 alen[2]; alen[0] = 6; alen[1] = 6;
status = OCIBindByPos (stmtp, &bindpp, errpp, 1, textval, 6,
SQL_CHR, inds, alen, 0, 0, 0, OCI_DEFAULT);
This works fine, however when I try to insert two strings of different lengths things go awry.
Is it possible bind an array of variable length strings, or do they have to fixed length padded with spaces?
Thanks S. Received on Mon Mar 29 1999 - 21:26:23 CST