Toad World® Forums

Error ORA-06502 and ORA-06512

Hi,

i added my own “ruleset” in toad 12.8. then i clicked “save results in db” and executed the code analyzis.

now I get the errors Ora-06502 and ora-06512. could anybody tell me please why I get them?

best regards,

student2016

The common reasons behind this error are:

  1. You are trying to assign a value to numeric variable, but the value is larger than the variable can handle.

  2. You are trying to assign a non-numeric value to a numeric variable and caused a conversion error

You could correct this error by redefining the v_number variable as number(3).

or use Oracle Repair Tool to fix it.

oracle.filerepairtool.net/