OCIRaw *raws[N];

// ... fill the raws with data

int maxallocsize = 0;
for (i = 0; i < N; i++)
{
   int allocsize;
   OCIRawAllocSize(envhp, errhp, raws[i], (ub4 *)(&allocsize));
   
   if (allocsize > maxallocsize)
      maxallocsize = allocsize;
}

char *rawcopy = (char *)malloc((maxallocsize + 4) * N);

for (i = 0; i < N; i++)
{
   int allocsize;
   OCIRawAllocSize(envhp, errhp, raws[i], (ub4 *)(&allocsize));
   
   memcpy(rawcopy + i * (maxallocsize + 4), raws[i], allocsize + 4);
}

OCIStmt *stmt;
OCIHandleAlloc(envhp, &stmt, OCI_HTYPE_STMT, 0, 0);
OCIBind *bndp = (OCIBind *)0;

const char *query = "INSERT INTO ... VALUES(:param)";

OCIStmtPrepare(stmt, errhp, (text *)query, (ub4)strlen(query), OCI_NTV_SYNTAX, OCI_DEFAULT));

OCIBindByName(stmt, &bndp, errhp, (text *)":param", -1, 
   (dvoid *)rawcopy, maxallocsize + sizeof(int), SQLT_LVB, 0, 0, 0, 0, 0, OCI_DEFAULT);

OCIStmtExecute(svchp, stmt, errhp, N, 0, NULL, NULL, OCI_DEFAULT);