Missing right parenthesis in query?

Question

Oracle

SELECT JSON_OBJECT (
                    KEY 'region' IS p.state FORMAT JSON, 
                    KEY 'location' IS p.locality FORMAT JSON
                    ) "t" 
FROM CRE_AVG_PRICE_LOCATIONS p

The code doesn't work, says - the right bracket is missing (at the moment 'region').
CHADNT?

Answer 1

What version of oracle?
json_object is only available since 12.2