ORA-01722 Exception
Posted: Wed 15 Dec 2010 05:44
Hi,
We are switching from Microsoft Oracle client to dotConnect.
I am getting the following Oracle Exception for the one particular stored proc:
ORA-01722: invalid number
ORA-06512: at "XXX", line X
ORA-06512: at line X
It was working fine with Microsoft provider. I've checked that numeric parameters are assigned with integer values and Char params with strings.
If I call same stored proc with exactly same values from PL/SQL Developer it executes fine.
I realise that this is very generic description of the problem.
Can anyone suggest what may be the reason for such issue?
We are switching from Microsoft Oracle client to dotConnect.
I am getting the following Oracle Exception for the one particular stored proc:
ORA-01722: invalid number
ORA-06512: at "XXX", line X
ORA-06512: at line X
It was working fine with Microsoft provider. I've checked that numeric parameters are assigned with integer values and Char params with strings.
If I call same stored proc with exactly same values from PL/SQL Developer it executes fine.
I realise that this is very generic description of the problem.
Can anyone suggest what may be the reason for such issue?