SAP Knowledge Base Article - Preview

1203183 - Error: "Exception: DBD, ORA-01722: invalid number" when using to_number in Desktop Intelligence

Symptom

  • Cannot use the to_number Oracle function
  • Error when using the to_number function
  • Error "Exception: DBD, ORA-01722: invalid number" when using the to_number function to convert data of type char/varchar into data of type number


Read more...

Product

SAP BusinessObjects Business Intelligence platform R2 ; SAP BusinessObjects Enterprise XI

Keywords

to_number, Oracle, ORA-01722, nls_numeric_character, ConnectInit, 667128 , KBA , BI-BIP-SL , Semantic Layer , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.