Blazin JZN 216 – Unclosed Quoted Step

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 Number JZN-00216
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.

Leave a Comment