Recent changes to Project PL/JSON

PL/JSON Not working On 12c R2 database

2021-03-19T13:39:56.441000Z

Just creating json_value to another name will help? I have used schema.json_value in all references, many compiles, But still types like JSON, JSON_LIST etc not compiling Can you explain little more, what else you did other than just changing the name. Please help
George

PL/JSON packages not compiling after Oracle 19c upgrade please help

2021-03-18T17:00:07.811000Z

We have had PL/JSON packages installed in Oracle 12c Database, When we upgraded the database to Oracle 19c . the PL/JSON packages many of them not compiling . I changed name of the json_value to schema.json_value in all references, few of the packages compiling, but many are still not compiling ,
especially type such as JSON, JSON_LIST etc. can someone help us
George

Discussion for Home page

2021-03-11T20:06:31.321000Z

it was highly recommended for me. but finally you can help us.
Please post more projects as such type of work.
like (java classes for getting client ip , os name, login name file transfer from client to client , server to client and also client to server)
Thanks Alot
Regards

PL/JSON Not working On 12c R2 database

2020-10-13T07:01:01.710000Z

we have upgraded databases 11.2.0.4 to 19.8.0.0. But, some PLJSON schema objects invalid. Do you have any idea or advise?

PL/JSON Not working On 12c R2 database

2020-08-13T19:03:36.901000Z

Hi,

I have exactly the same problem. There types are invalid.
Could you eleborate your solution?

Thanks in Advance

getting MY_SCHEMA_NAME.JSON_LIST when i execute json_util_pkg.sql_to_json

2020-06-12T15:14:19.625000Z

Hi NAgesh,

Can you send us the sample code how to extract data from Json from SQL.
I've a requirement is Input data coming as CLOB in to Oracle Standalon Function

We have written PAcakge.Function to accept input (JSON) as CLOB.
I want to read data from CLOB which is JSON file in to custom table.

Can you please help me .

Thanks,
Neel

New with JSON

2019-04-02T12:59:24.870000Z

Hi All,
I am new with JSON, I have installed all the files and they work.
My question is, how to use a JSON file in Oracle.
Do I have to laod the file into a table or?

Below is what is in the file, only a little part.

Any help or tips tricks are welcome.
Steven.

{
"type" : "FeatureCollection",
"name" : "luchtkwaliteit",
"crs" : {
"type" : "name",
"properties" : {
"name" : "EPSG:28992"
}
},
"features" :
{
"type" : "Feature",
"geometry" : {
"type" : "Point",
"coordinates" : [ 82419, 456787
},
"properties" : {
"NAAM" : "054 v. Alkemadelaan thv nr 44",
"NO2_MEETNET" : "meetpunt",
"VERG_MET_NSLMONIT" : "vgl",
"SOORT" : "woonwijken",
"GEVELAFSTAND" : 12.46,
"WEGRANDAFSTAND" : 3.26,
"RECEPTORID_MT2013" : "15528706",
"JAARGEM_2017" : 30.3,
"JAARGEM_2016" : 28.4,
"JAARGEM_2015" : 28.3,
"JAARGEM_2014" : 31.8,
"JAARGEM_2013" : 31.2,
"JAARGEM_2012" : 33.9,
"JAARGEM_2011" : 36.2,
"X" : "82419",
"Y" : "456787",
"COUNTER" : "54"
}
},
{
"type" : "Feature",
"geometry" : {
"type" : "Point",
"coordinates" : [ 82509, 456511 ]
},
"properties" : {
"NAAM" : "055 Willem Witsenplein MP18",
"NO2_MEETNET" : "meetpunt",
"VERG_MET_NSLMONIT" : "vgl achtergrond",
"SOORT" : "drukke wegen",
"GEVELAFSTAND" : 10.78,
"WEGRANDAFSTAND" : 2.33,
"RECEPTORID_MT2013" : "15527654",
"JAARGEM_2017" : 33.1,
"JAARGEM_2016" : 30.8,
"JAARGEM_2015" : 29.5,
"JAARGEM_2014" : 34.9,
"JAARGEM_2013" : 33.1,
"JAARGEM_2012" : 34.5,
"JAARGEM_2011" : 35.7,
"X" : "82509",
"Y" : "456511",
"COUNTER" : "55"
}
},
{
"type" : "Feature",
"geometry" : {
"type" : "Point",
"coordinates" : [ 82407, 456447 ]
},
"properties" : {
"NAAM" : "056 Benoordenhoutseweg thv nr 90",
"NO2_MEETNET" : "meetpunt",
"VERG_MET_NSLMONIT" : null,
"SOORT" : "drukke wegen",
"GEVELAFSTAND" : 6.4,
"WEGRANDAFSTAND" : 2.22,
"RECEPTORID_MT2013" : "NaN",
"JAARGEM_2017" : 33.5,
"JAARGEM_2016" : 28.5,
"JAARGEM_2015" : 28.5,
"JAARGEM_2014" : 31.9,
"JAARGEM_2013" : 31.6,
"JAARGEM_2012" : 32.5,
"JAARGEM_2011" : 33.8,
"X" : "82407",
"Y" : "456447",
"COUNTER" : "56"
}
}
]
}

Use json_dyn.executeobject return pljson to Java Calable Statement

2019-02-09T19:02:44.689000Z

I used pretty print to convert to varchar then I was able to use.

Use json_dyn.executeobject return pljson to Java Calable Statement

2019-02-08T21:38:36.817000Z

Hi,

I am using Oracle Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production. I am able to create the object I need and want to call as follows:
PROCEDURE member_json_gateway
(
p_process IN VARCHAR2,
p_data IN VARCHAR2,
p_result OUT json)....

In my java I have
loginUser = "{call member_info.member_json_gateway(?,?,?)}";
cstmt = conn.prepareCall (loginUser);
cstmt.setString(1, toprocess);
cstmt.setString(2, data);
cstmt.registerOutParameter(3, OracleTypes.CLOB);

      I do not know how to Map the out Parameter.

      Thank you.

Use Variables in call json_dyn.executeobject

2019-02-08T10:51:00.412000Z

found my answer
DECLARE
ret json;
v_id members.member_id%type;
v_zip_code zip_codes.zip_code%type := '97317';
BEGIN
ret := json_dyn.executeobject
(
stmt=> 'SELECT
zip_code,
zip_code_state state,
zip_code_primary_city city
FROM
zip_codes
where zip_code = NVL(:bindme,zip_code)
and rownum < 50'
,bindvar => json('{bindme:"'||v_zip_code||'"}')
);

ret.print;

END;