Stack Overflow
Stack Overflow

Questions tagged [pljson]

PL/JSON is a generic JSON object written in PL/SQL.

PL/JSON is a generic JSON object written in PL/SQL. Using PL/SQL object syntax, users instantiate a JSON object and then add members, arrays and additional JSON objects. This object type can store JSON data, in Oracle, persistently.

The project's home page is https://github.com/pljson/pljson.

Questions using this tag should be directly related to the usage of the PL/JSON library. Other PL/SQL questions should use the tag.

Potential bugs in the PL/JSON library should not be posted as questions to StackOverflow. Such posts should be directed at the project's bug tracker -- https://github.com/pljson/pljson/issues.

44 questions
0
votes
0 answers

What's the best option to replace \r\n from a returned object

When using the PL/JSON, values that contain carriage returns or new lines is returned with \r\n. Is there a way to have \r\n replaced with ASCII on the returned object or replaced?
Christine Yee Tang
  • 1
0
votes
0 answers

Use PLJSON types in Java via JDBC Type mapping

Is there a Java library to directly access PLJSON Types returned from PLSQL procedures / functions which would be more performant than returning a CLOB and using another Java library like GSON to deserialize the JSON CLOB to Java POJOs? My usecase…
JakeDot
  • 101
  • 3
0
votes
1 answer

How to parse json with multiple records using pljson

I am having issues parsing this json data there is a total of 2 records in "orders" and I need to retrieve data based on order 1 and order 2 with also of each item in "orders.order_items" Any help would be great, it's stressing me out... { …
iStealth
  • 43
  • 4
0
votes
3 answers

How to generate JSON through SQL PL/JSON

I'm trying to generate a JSON from an SQL with PL/JSON declare customer json_list := json_list(); product json_list; begin customer:= json_dyn.executeList('SELECT DISTINCT A.customer_id, A.customer_name, FROM customer A WHERE…
Luciano Amaro
  • 51
  • 6
0
votes
2 answers

Oracle - Retrive data from json object with json list inside

So, I have this api that ansawer me a json_list, and my program put it inside a json object that i can't change. I need to retrive information from it but i can't. My json file: [{ "idSolic" : "1234", "Status" : { "code" :…
Lucas Mouta
  • 1
  • 1
  • 2
0
votes
1 answer

How can I get PL/JSON array of array value

How can I retrieve content from below JSON using Pl/JSON? i need to fetch values of first array and second array { "documents1": [ { "key": "NATID", "validations": [ { "error": "Field is required" } …
Sha
  • 13
  • 7
0
votes
1 answer

Parse array of string in PLJSON oracle

I have to parse a array of string in my JSON with ORACLE dans PLJSON module. I'm able to parse data without array like CLE,X,Y.. But when I want to get COLORS or REGROUPEMENT_COLORS, this return me nothing. There is the code: DECLARE obj json…
DEVLOGIN
  • 87
  • 1
  • 9
0
votes
2 answers

Parse JSON LIST in a JSON LIST PLSQL

I'm working with PLJSON and ORACLE ,I have a JSON like this { "DATA": { "FROM_DATA": [ { "COL": "", "ROW": "", "GET_DATA": [{"0":"df"}], "SAVE_DATE": [{"2":"ar"}] } ] } } I'm able to parse…
DEVLOGIN
  • 87
  • 1
  • 9
0
votes
0 answers

Json strings stored in collection in oracle apex classic report using pljson

I have used the following query for the classic report using pljson: the page works, but it only shows 46 records, in all cases. Does anyone know why this limitation, or have you had a similar experience? Thanks for your help select * from…
ans240577
  • 1
0
votes
1 answer

Oracle 12c PL/JSON Chopping Off Strings at 5000 Characters

I'm having an issue with PL/JSON chopping off string values at exactly 5000 characters. Example data: {"n1":"v1","n2":"v2","n3":"10017325060844,10017325060845,... this goes on for a total of 32,429 characters …
gfrobenius
  • 3,987
  • 8
  • 34
  • 66
0
votes
1 answer

Generate JSON from stored function/procedure that returns the result of an SQL?

I am testing PLJSON on Oracle 12.1, with the intention of generating JSON from a table. I have implemented a package that encapsulates queries to that table. I have also verified that, using pljson_dyn, I can generate JSON correctly from an SQL…
Jorge J. Espada
  • 31
  • 1
  • 9
0
votes
1 answer

pljson_util_pkg sql_to_json doesn't work if values are less than 1

I have a problem with pljson_util_pkg.sql_to_json declare -- Local variables here tstjson_list pljson_list; l_Result_json_clob clob; begin -- Test statements here tstjson_list := pljson_list(); …
user4841164
  • 11
  • 3
0
votes
1 answer

Processing JSON object via Webservice in PL/SQL

I am developing a test Oracle Procedure to receive a JSON object from a locally XAMPP hosted web-service. Followed below steps. (01) Created the ACL set define off; BEGIN SYS.DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(acl => 'www.xml', …
Lalama Yatawara
  • 13
  • 1
  • 6
0
votes
1 answer

Reading data in an inner array with pljson

Sample JSON: {"TestResults": [{ "Messages": ["PASS: Status date 7/1/2002, ID"], "Status": "Pass", "Name": "IFTA License" }, { "Messages": ["Carrier compliant"], "Status": "Pass", "Name": "MCOLS carrier compliance check" }, { …
rnicol
  • 3
  • 4
0
votes
1 answer

Hierarchal JSON to oracle table

I have a JSON object stored in a CLOB that represents a hierarchy: { "Version": 1, "nodes": [{ "id": 0, "Fields": ["ABC"], "nodes": [{ "id": 1, "Fields": ["DEF"], …
JohnHC
  • 10,935
  • 1
  • 24
  • 40
1
2
3