Very Computer

by **Simeon Baile** » Wed, 31 Mar 1999 04:00:00

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.

by **<j.m.s..** » Wed, 31 Mar 1999 04:00:00

You forgot to BindArrayOfStruct(6,0,0,0) after your BindByPos

The 'ALen' parameter lets you specify the Actual LENgth of your parameter.
The array itself must have a fixed 'skip size', as specified by
BindArrayOfStruct.

In short, you do not need to pad spaces, but use the Alen parameter.

JM

>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.

Very Computer

OCI array of strings bind

OCI array of strings bind

OCI array of strings bind