in reply to get rowid for failed records using dbi

I can't answer the question directly. Since I have not encountered that type of error with the DBI module. I suspect that there is NO rowid to provide your perl script since the operation is failing in the oracle database server itself.

Since you're likely doing the divide operation in sql, you should do a simple decode on Zero for the divisor and set the result an "impossible" value. That will help you identify from your script.

If this is bad data just look in the column where the row is null and identify the rowid that way.

  • Comment on Re: get rowid for failed records using dbi