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:
-
You are trying to assign a value to numeric variable, but the value is larger than the variable can handle.
-
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.