ORA-01722 Exception

Alex123 · Post by **Alex123** » 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?

StanislavK · Post by **StanislavK** » Thu 16 Dec 2010 16:39

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.