Help, OCIRowid

I am working with the Oracle 8.04 OCI Library and when I try get the OCIRowid
happen that:

The first Fetch return the second OCIRowid of the Select (the other is good) The second Fetch return the second OCIRowid of the Select again. Nex Fetch return the Fourth OCIRowid of the Select . The next return the Fourth OCIRowid of the Select again etc.

the body of the function is

while(!status)
{

    status = OCIStmtFetch( m_hSentencia, HandleError,

            m_FilasADevolver, OCI_FETCH_NEXT, OCI_DEFAULT );     status = OCIAttrGet(m_hSentencia, OCI_HTYPE_STMT, (OCIRowid*) m_Rowid,

       0 , OCI_ATTR_ROWID , HandleError); }

where m_hSentencia is a OCIStmt * and m_Rowid is a (OCIRowid*) , etc

Thanks and I hope that anybody know the solutions

Manuel Sanchez
sanchezm_at_dycsa.es Received on Fri Feb 26 1999 - 05:19:51 CST