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?
ORA-01722 Exception
-
- Devart Team
- Posts: 1710
- Joined: Thu 03 Dec 2009 10:48
Could you please specify the following:
1) the exact version of dotConnect for Oracle you are using;
2) the exception stack trace (the part with Devart components only);
3) whether the problem occurs with a procedure or function (i.e., whether this procedure returns a value);
4) types and directions of this procedure parameters.
1) the exact version of dotConnect for Oracle you are using;
2) the exception stack trace (the part with Devart components only);
3) whether the problem occurs with a procedure or function (i.e., whether this procedure returns a value);
4) types and directions of this procedure parameters.