You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.
View groupJoin the community to find out what other Atlassian users are discussing, debating and creating.
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
Connect with like-minded Atlassian users at free events near you!
Find an eventConnect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.
Host an eventYou're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events