ORA-06502: PL/SQL: numeric or value error

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Boris
Posts: 1
Joined: Sat 15 Oct 2005 14:03

ORA-06502: PL/SQL: numeric or value error

Post by Boris » Sat 15 Oct 2005 14:08

Hello!
We are registered customer of your ODAC components. We use Delphi 6, ODAC 5.551.22 for Delphi 6 and Oracle 9.2.0.7.
I have compiled a project DMLArray.dpr in your Demo directory \Odac\Demos\DMLArray
Then I have pushed the button “Open”. Greed has filled with data. Then I have pushed the button “Get Names” and received an error message on line 77 in main.pas, executing sqGet.Execute(RecCount); The error message is: ORA-06502: PL/SQL: numeric or value error.
I have received another error message pushing “Put Names”: ‘’ is not a valid integer value.”
Another problem we have faced is that we MUST define the type of output parameters in OraStoredProc. Otherwise, we receive the same error message: “PL/SQL: numeric or value error”. It’s not very convenient, because we haven’t seen such an error in your previous version 4.5. We did not declare the type of output parameters and everything was working. As result we have to modify a lot of code in our Delphi project.

Best regards,

Boris

Alex
Posts: 655
Joined: Mon 08 Nov 2004 08:39

Post by Alex » Tue 18 Oct 2005 06:18

We have reproduced your problem and fixed it. This fix will be included in the next ODAC build.

Post Reply