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
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
timestamp '1970-01-01 00:00:00 -5:00' +numtodsinterval(json_value(json_value, '$.baseline_start')/ 1000, 'second') as target_start_date
where Entity_name = 'IssueProperty'
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events