Forum Stats

  • 3,757,167 Users
  • 2,251,204 Discussions


OCCI C++ how return prevRow or Row by index?

4182438 Member Posts: 3
edited Feb 12, 2020 3:05AM in Oracle Call Interface (OCI)

Statement return ResultSet, but ResultSet contain only method next() for inc current pointer row.

Me need for example method prev() or getRow(int index) from ResultSet. It's really?

Or I must create list and in cycle to fill it in???

<span class="typ" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #2b91af;"></span>
Environment *env = Environment::createEnvironment(); {      Connection *conn = env->createConnection( userName, password, connectString);      Statement *stmt = conn->createStatement( "SELECT blobcol FROM mytable");      ResultSet *rs = stmt->executeQuery(); rs->next(); // but me need prev()      std::string b = rs->getString(1);      //...      stmt->closeResultSet(rs);      conn->terminateStatement(stmt);      env->terminateConnection(conn); } Environment::terminateEnvironment(env);