OCI and ORA-01486

From: Steve Hindmarch <stephen.hindmarch_at_bt.com>
Date: Fri, 02 Jul 1999 15:18:35 +0100
Message-ID: <377CCA3B.A89843D3@bt.com>

I am trying to fetch batches of varchar2's from a pl/sql table, and put them into arrays of chars.

text fname[100][20];
sword *batchsize;

OCIBindByName(stmthp,bndhp,errhp,
":fname",strlen(":fname"),fname,20,SQLT_CHR, indp, alenp, rcp, (ub4) MAX_ARRAY_LENGTH, batchsize, OCI_DEFAULT)

OCIBindArrayOfStruct(bndhp, errhp, 20,
sizeof(sb2), sizeof(ub2), sizeof(ub2))

If I set batchsize to 16 then I am fine.

If I set batchsize to 17 then I get an ORA-01486.

Any Clues?

Steve Hindmarch Received on Fri Jul 02 1999 - 09:18:35 CDT