ORA-00907: missing right parenthesis

Hello everybody,

I'm trying to execute JSON_TRANSFORM function as in the following sample SQL code:

SELECT json_transform(po_document, REMOVE '$."Special Instructions"' RETURNING CLOB PRETTY) FROM j_purchaseorder;

Table j_purchaseorder is:

CREATE TABLE CAFC_DWH.j_purchaseorder

  (id     RAW (16) NOT NULL,

  date_loaded TIMESTAMP WITH TIME ZONE,

  po_document CLOB

  CONSTRAINT ensure_json CHECK (po_document IS JSON));

   

  INSERT INTO j_purchaseorder

 VALUES (SYS_GUID(),

     SYSTIMESTAMP,

     '{ "PONumber"       : 1600,

 "Reference"      : "ABULL-20140421",

 "Requestor"      : "Alexis Bull",

 "User"         : "ABULL",

 "CostCenter"      : "A50",

 "ShippingInstructions" : { "name"  : "Alexis Bull",

               "Address": { "street" : "200 Sporting Green",

                     "city"  : "South San Francisco",

                     "state"  : "CA",

                     "zipCode" : 99236,

                     "country" : "United States of America" },