Home about IT Motivation Course Sales Project About Me

Wednesday, February 20, 2013

SQLSTATE = 22005 [Oracle][ODBC][Ora]ORA-01722: invalid number

environment:
  • clients pc: windows XP sp2/sp3
  • oracle 11g
  • powerbuilder 9 
  • connection use ODBC to oracle server
some users use windows XP have error message as below:
SQLSTATE = 22005
[Oracle][ODBC][Ora]ORA-01722: invalid number
No changes made to database.

when changes value use combo box

below step to solve at clients PC:
  • please unisntall previous oracle clients at their PC,
  • remove ODBC setting and environment DLL for powerbuilder
  • reinstall oracle again and 
  • re setting path DLL files for powerbuilder in environment variabel.

No comments: