work with json in oracle

by

I have started using this library, and it seems promising:
https://github.com/pljson/pljson

Easy to install, and the examples are good.

To use the library in your example, add these variables to your procedure..

mapData     json;
results     json_list;
status      json_value;
firstResult json;
geometry    json;

….

Then you can manipulate the response as a json object.

-- convert the result from the get to a json object, and show some results.
mapData := json(v_ans);

-- Show the status of the request
status := mapData.get('status');
dbms_output.put_line('Status=" || status.get_string());

IF (status.get_string() = "OK') THEN
  results := json_list(mapData.get('results'));
  -- Grab the first item in the list
  resultObject := json(results.head);

  -- Show the human readable address 
  dbms_output.put_line('Address=" || resultObject.get("formatted_address').to_char() );
  -- Show the json location data 
  dbms_output.put_line('Location = ' || resultObject.get('geometry').to_char() );
END IF;

Running this code will output this to the dbms output:

Status = OK
Address = "St Paul, MN 55105, USA"
Location = {
  "bounds" : {
    "northeast" : {
      "lat" : 44.9483849,
      "lng" : -93.1261959
    },
    "southwest" : {
      "lat" : 44.9223829,
      "lng" : -93.200307
    }
  },
  "location" : {
    "lat" : 44.9330076,
    "lng" : -93.16290629999999
  },
  "location_type" : "APPROXIMATE",
  "viewport" : {
    "northeast" : {
      "lat" : 44.9483849,
      "lng" : -93.1261959
    },
    "southwest" : {
      "lat" : 44.9223829,
      "lng" : -93.200307
    }
  }
}

More Related Contents:

  1. Return results of a sql query as JSON in oracle 12c
  2. How do I cast a JSON Object to a TypeScript class?
  3. Are multi-line strings allowed in JSON?
  4. Parsing JSON in Excel VBA
  5. How do I use custom keys with Swift 4’s Decodable protocol?
  6. JSON and dealing with unexported fields
  7. How to decode a nested JSON struct with Swift Decodable protocol?
  8. JSON and escaping characters
  9. Converting Go struct to JSON
  10. AngularJS $http-post – convert binary to excel file and download
  11. Build a JSON string with Bash variables
  12. uncaught syntaxerror unexpected token U JSON
  13. How to fetch JSON file in Angular 2
  14. Unhandled Exception: InternalLinkedHashMap’ is not a subtype of type ‘List
  15. How to Deserialize a list of objects from json in flutter
  16. Jackson JsonTypeInfo.As.EXTERNAL_PROPERTY doesn’t work as expected
  17. Deserializing JSON using JSon.NET with dynamic data
  18. How to use Newtonsoft.Json as default in Asp.net Core Web Api?
  19. Flutter FormatException: Unexpected character (at character 1)
  20. Mapping JSON data in JQGrid
  21. Which JSON content type do I use?
  22. Why would you use a string in JSON to represent a decimal number
  23. Bash script: Use string variable in curl JSON Post data
  24. json unmarshal time that isn’t in RFC 3339 format
  25. How can I deserialize an optional field with custom functions using Serde?
  26. How do I customize default error message from spring @Valid validation?
  27. Spring @ResponseBody Jackson JsonSerializer with JodaTime
  28. How to open Visual Studio Code’s ‘settings.json’ file?
  29. unmarshalling arbitrary data
  30. REST API Best practices: args in query string vs in request body

Leave a Comment