ORA-01722 Exception

ORA-01722 Exception

Postby 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?
Alex123
 
Posts: 4
Joined: Thu 09 Dec 2010 00:53

Postby 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.
StanislavK
Devart Team
 
Posts: 1710
Joined: Thu 03 Dec 2009 10:48


Return to dotConnect for Oracle