Oracle’s JSON Path Expression (JPE ) uses specific characters such as dollar signs and dots to step through JSON structures. For example a JPE of $.NAME steps to the NAME key at the absolute top of a JSON structure. Whenever invalid syntax JPE syntax is encountered Oracle throws an error with a JZN prefix. Why that prefix? I suspect it is a shortened, stylized version of JSON. I also suspect the WTF prefix was already taken.
As I come across new JZN errors I will document them in this series. I will also poke fun at them. Because sometimes that alleviates any frustration and that is how I roll.
|Error Text||Unclosed quoted step|
|Cause||A step beginning with a quotation mark did not have a closing quotation mark|
|Shakespeare||A grise beginning with a quotation marketh didst not has’t a closing quotation marketh|
|Action||A step beginning with a quotation mark did not have a closing quotation mark|
|Erroneous JPE||$.mrns[*]?(@.MRN == “MRN99 )|
|Corrected JPE||$.mrns[*]?(@.MRN == “MRN99” )|
The corrected example has a double quote before AND after the value.