Oracle conversion error

0

I have a problem: when I run a function direct on the database, no problem occurs but when I run in php , this error occurs:

  

ORA-06502: PL / SQL: numeric or value error: character to number conversion error

The problem is in these if

IF TO_NUMBER (REPLACE(SUBSTR(VAR_STRCALCULO, 71,15), '.', ',')

Most likely some null value is coming or something so conversion is not possible. How to treat it? why do not I make a mistake in the bank and sim application?

    
asked by anonymous 29.06.2018 / 19:51

0 answers