Menu

binding multiple rows, not using arrays

2010-05-12
2012-09-26
  • Dann Corbit

    Dann Corbit - 2010-05-12

    How do I set a bind buffer for multiple rows collection? We have an array of
    records, not separate arrays for the data.
    Previously, we would do something like this:
    odefin(&cda, nLoop + 1, (unsigned char ) (pRowData + lRowLength +
    (sizeof(short) * m_cnx_oracle_fetch_count)), pCCS->lColumnLength, nType, -1,
    (short
    ) (pRowData + lRowLength), 0, -1, -1, (unsigned short *) (pRowData +
    lRowLength + ((sizeof(short) + pCCS->lColumnLength) *
    m_cnx_oracle_fetch_count)), 0);

    How can I tell Oracle to read 6000 rows at once (for instance)?

     
  • Dann Corbit

    Dann Corbit - 2010-05-21

    I discovered what I needed to know.
    odefin() and friends from Oracle 7 were replaced with OCIDefineByPos() which
    has the nearest OCILIB analog of OCD_DefineDef(), and OCI_ResultsetCreate() is
    the higher level approach for the same concept.

     
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.