ORA-06502 error for json_Value

[talha Parvaiz]

I have a big SQL and it's throwing an error message for the line where I am extracting values stored in json_value. It's running fine for a few records (may be just a coincident) but generating the error message when I extract a larger dataset

Error:

ORA-00604: Error occurred at recursive SQL level 1

ORA-06502: PL/SQL: numeric or value error: Character string buffer too small

ORA-06512: at line 47

ORA-01722: invalid number

Code :

select  

 timestamp '1970-01-01 00:00:00 -5:00' +numtodsinterval(json_value(json_value, '$.baseline_start')/ 1000, 'second')  as target_start_date

from jir.entity_property

where Entity_name = 'IssueProperty'

Thanks

Please advise