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

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

Answer 1

Hi Kapil,

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

Refer: http://www.techonthenet.com/oracle/errors/ora01722.php

It has nothing to with password change. Check the request hitting the oracle database.

Also refer: FIX: Error message "ORA-01722: invalid number" when you replicate a table to an Oracle server subscriber in SQL Server 2008 or in SQL Server 2008 R2 if a varchar (max) column of the table contains a long value record

---

Rachit Sikroria (Microsoft Azure MVP)

Answer 2

Thank you for quick response.

BizTalk has received an error while lookup (Select statement )

Answer 3

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.
Refer: http://www.techonthenet.com/oracle/errors/ora01722.php

---

Rachit Sikroria (Microsoft Azure MVP)