OCIStmtFetch error handling

Greetings,

I am using OCI8. Say following code model:

OCIStmtExecute("select .. from .. where ...");

while (1)
{

      switch (OCIStmtFetch())
      {
       case OCI_SUCCESS:
                  handle the data;
                  break;
       case OCI_NO_DATA:
                   return;
        default:
                   // Error occur
        }

My question is for error handling. Error might be "fetched column is NULL", etc. But anyway, it should be a record level. What I want to do is to skip the wrong record and process rest records.

And I am wondering when OCIStmtFetch returns error, can I get rowid or primary key value of the error record so that I can delete the error record?

Evan

--
Li, Evan Chao
==========================================
Software Support Center, Lucent Qingdao(QD) , R&D
Tel: (Office) +86-532-8702000 x5231
Email: cli4_at_lucent.com
http://gdcsr60.gdc.lucent.com/qdr&d/cfd_labsuprt/ssc/index.html