ORA-01722: invalid number in the BizTalk WCF-Oracle Adapter RRS feed

  • Question

  • I have updated new password in the Oracle adapter after that BizTalk is receving below error

    ORA-01722: invalid number 

    if i enter wrong password then returns valid error message like invalid user name or password

    Monday, June 13, 2016 5:47 PM


  • Okay. In that case check the response returned by oracle. 

    Check if there was some change at Oracle end. You might need to regenerate the schemas.

    I repeat this error has nothing to do with Password change, you need to investigate this at oracle end.

    An ORA-01722 error occurs only when an attempt is made to convert a character string into a number, and the string cannot be converted into a number.

    Rachit Sikroria (Microsoft Azure MVP)

    Monday, June 13, 2016 6:19 PM

All replies