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?