How to Parse JSON Message using JSON_VALUE function in stored procedure oracle SQL Developer. facing below error when I pass the dynamic value to the JSON_VALUE for the static value it's working as expected. can anyone help on this to fix the issue?enter image description here below is the error message:
Error(14,1): PL/SQL: ORA-40598: JSON path expression contained an invalid array index ('$[a].Component') JZN-00211: Invalid array subscript at position 4