ORA-06502: PL/SQL : erreur numérique ou erreur sur une valeur
Hello everybody,
Well, I have several procedures that do update or insert and generate this error, the worst is that it works for the client. I think it comes from my database which is poorly configured.
For example I have a batch which done an update of certain data from a file, it processes line by line. For a row, if the data contains too many characters, in this case it is an address, I get the message:
ORA-06502: PL / SQL: erreur numérique ou erreur sur une valeur
ORA-06512: at line 1.
This should normally be a maximum of 32 characters (this basic field is a VARCHAR2 (32 BYTE)), in my case, my address should be a maximum of 12 characters for inclusion works (I tried for example with 12 letters A and it works but not 13 A letters).
For example I have a batch which done an update of certain data from a file, it processes line by line. For a row, if the data contains too many characters, in this case it is an address, I get the message:
ORA-06502: PL / SQL: erreur numérique ou erreur sur une valeur
ORA-06512: at line 1.
This should normally be a maximum of 32 characters (this basic field is a VARCHAR2 (32 BYTE)), in my case, my address should be a maximum of 12 characters for inclusion works (I tried for example with 12 letters A and it works but not 13 A letters).
0