ORA-01722

BSG1 · Post by **BSG1** » Fri Sep 25, 2015 5:09 pm

Hi All,

I am reading using Oracle Connector Stage. When I run the same job with few records it run fine but with full data it's giving following error:

The OCI function OCIStmtFetch2 returned status -1. Error code: 1,722, Error message: ORA-01722: invalid number. (CC_OraStatement::fetch, file CC_OraStatement.cpp, line

Can you suggest please?

BSG1 · Post by **BSG1** » Fri Sep 25, 2015 6:23 pm

Used To_NUMBER as a workaround with suspected field.

chulett · Post by **chulett** » Fri Sep 25, 2015 6:23 pm

That's not a "workaround", at least not in my book.