Activity for PL/JSON

George Thomas modified a comment on discussion Help

2021-03-19T16:17:52.762000Z

Just recreating json_value with 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

George Thomas posted a comment on discussion Help

2021-03-19T13:39:56.989000Z

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

George Thomas posted a comment on discussion Help

2021-03-18T17:00:08.634000Z

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

usman posted a comment on a wiki page

2021-03-11T20:06:32.448000Z

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

Alper posted a comment on discussion Help

2020-10-13T07:01:02.784000Z

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?

Baris modified a comment on discussion Help

2020-08-16T17:43:12.233000Z

Hi, I have exactly the same problem. These types are invalid. Could you elaborate your solution? Thanks in Advance

Baris posted a comment on discussion Help

2020-08-13T19:03:38.004000Z

Hi, I have exactly the same problem. There types are invalid. Could you eleborate your solution? Thanks in Advance

Neelakanta posted a comment on discussion Open Discussion

2020-06-12T15:14:21.715000Z

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

John de Graaf posted a comment on discussion Help

2019-04-02T12:59:27.774000Z

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"...

andrew krenitz posted a comment on discussion Help

2019-02-09T19:02:44.958000Z

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

andrew krenitz posted a comment on discussion Help

2019-02-08T21:38:39.505000Z

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...

andrew krenitz posted a comment on discussion Help

2019-02-08T10:51:03.456000Z

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;

andrew krenitz posted a comment on discussion Help

2019-02-08T10:05:03.619000Z

I have the following. DECLARE ret json; v_id members.memebr_id%type; BEGIN ret := json_dyn.executeobject('SELECT mem.member_id, mem.member_password, mem.member_username FROM members mem where mem.member_id = NVL(v_id,mem.member_id)' ); ret.print; END; How do I get the where clause to work? Thank you

prethviraj posted a comment on discussion Help

2017-08-05T10:56:02.313000Z

This issue got resolved . by recreating json_value to cust_json_value

prethviraj posted a comment on discussion Help

2017-07-28T11:24:54.771000Z

Hi Team, PL/JSON codes are not compailing on 12c R2 database .types are going into invalide state (i.e JSON,JSON_VALUE,JSON_LIST)

haobo zhou posted a comment on discussion Help

2017-06-29T03:29:15.856000Z

Following is the json code: Organisation Structure": { "Department":"ACCOUNTING", "ID":"10", "City":"NEW YORK", "Staff":[ { "Name":"CLARK", "Job":"MANAGER", "Salary":2450 }, { "Name":"KING", "Job":"PRESIDENT", "Salary":5000 }, { "Name":"MILLER", "Job":"CLERK", "Salary":1300 } }, { "Department":"OPERATIONS", "ID":"40", "City":"BOSTON", "Staff":[ ] }, { "Department":"RESEARCH", "ID":"20", "City":"DALLAS", "Staff":[ { "Name":"ADAMS", "Job":"CLERK", "Salary":1100 }, { "Name":"FORD", "Job":"ANALYST",...

Arjun posted a comment on discussion Open Discussion

2017-03-20T13:09:40.965000Z

Following is the JSON output I am getting from REST URL : { "type": "Campaign", "currentStatus":...

James Sumners posted a comment on discussion Help

2016-06-24T13:56:08.465000Z

It means posting the query here is a waste of time. In fact, if you installed from...

P Fay posted a comment on discussion Help

2016-06-24T12:42:42.958000Z

How does this address the problem?

P Fay posted a comment on discussion Help

2016-06-24T12:36:44.102000Z

Is that reply intended to mean something?

James Sumners posted a comment on discussion Help

2016-06-22T16:44:10.659000Z

https://github.com/pljson/pljson

James Sumners posted a comment on discussion Help

2016-06-22T16:43:49.499000Z

https://github.com/pljson/pljson

P Fay posted a comment on discussion Help

2016-06-22T15:52:05.546000Z

I find json_ext.get_string() fails when the object searched for has any valid JSON...

P Fay posted a comment on discussion Help

2016-06-22T15:30:56.010000Z

It appears that JSON objects are not parsed correctly in PLJSON. Valid JSON keys...

Prakash Rai posted a comment on discussion Open Discussion

2016-01-26T13:17:58.310000Z

Jonas and team, First of all, this is a great tool and Thank you. Is there a way...

Paul Jones posted a comment on discussion Open Discussion

2015-11-25T10:15:47.754000Z

Hi, Has anyone managed to speed up outputting the json object to htp.p. We are finding...

James Sumners posted a comment on discussion Open Discussion

2015-10-15T20:39:23.565000Z

github.com/pljson/pljson

packydevel posted a comment on discussion Open Discussion

2015-10-14T19:33:16.729000Z

Hi guys, i'm interested in JSON Schema validation. A useful feature that can be added...

Arun Singh posted a comment on discussion Help

2015-08-13T15:57:43.519000Z

Newbie to JSON and Java programming: How to create A JSON over HTTP API is deployed...

Amrit Agarwal posted a comment on discussion Open Discussion

2015-05-13T02:11:48.301000Z

Hi , I have this requirement to convert JSON format into result set (with rows and...

Amrit Agarwal posted a comment on discussion Help

2015-05-13T02:10:48.336000Z

Hi , I have this requirement to convert JSON format into result set (with rows and...

Aries modified a comment on discussion Open Discussion

2015-04-13T17:52:14.031000Z

Hi, Is the error ORA-22813 coupled with ora-600 part of this limitation? I got the...

Aries posted a comment on discussion Open Discussion

2015-04-13T17:49:41.102000Z

Hi, Is the error ORA-22813 coupled with ora-600 part of this limitation? I got the...

James Sumners posted a comment on discussion Open Discussion

2014-12-31T15:22:09.622000Z

bumping to top

James Sumners posted a comment on discussion Open Discussion

2014-12-31T15:19:19.862000Z

Please ask your question on StackOverflow using a "pljson" tag -- http://stackov...

James Sumners posted a comment on discussion Open Discussion

2014-12-31T15:16:30.332000Z

In an effort to keep the project alive, we have moved to GitHub. By number alone,...

Lourival Queiroz modified a comment on discussion Open Discussion

2014-12-29T19:01:02.647000Z

/* -- i have the Table Rota (rota_iu number(10), name varchar2(40)) rota_iu Name...

Lourival Queiroz posted a comment on discussion Open Discussion

2014-12-29T19:00:01.945000Z

/* -- i have the Table Rota (rota_iu number(10), name varchar2(40)) rota_iu Name...

James Sumners posted a comment on discussion Open Discussion

2014-12-23T17:55:33.603000Z

I will look at it as soon as I can, but I'm very busy at the moment. If you determine...

Gordon Frobenius posted a comment on discussion Open Discussion

2014-12-23T16:10:47.827000Z

I may have found the bug, second set of eyes would be great. In json_printer.ppMem...

Gordon Frobenius modified a comment on discussion Open Discussion

2014-12-22T18:55:57.286000Z

(this question along with a screen shot of the error can also be viewed here: http://stackoverflow.com/questions/27608461/oracle-pl-json-to-clob-fails)...

Gordon Frobenius modified a comment on discussion Open Discussion

2014-12-22T18:55:20.661000Z

(this question along with a screen shot of the error can also be viewed here: http://stackoverflow.com/questions/27608461/oracle-pl-json-to-clob-fails)...

Gordon Frobenius posted a comment on discussion Open Discussion

2014-12-22T18:51:45.550000Z

(this question along with a screen shot of the error can also be viewed here: http://stackoverflow.com/questions/27608461/oracle-pl-json-to-clob-fails)...

Jonas Krogsboell posted a comment on discussion Open Discussion

2014-12-11T19:33:54.122000Z

Sorry, I've been quite busy and will be for a while.

anpegar posted a comment on discussion Open Discussion

2014-12-11T17:25:24.181000Z

Hi Jonas !! Have you been able to seen the issue? Any idea? Thanks in advance. T...

Haytham Alzeini posted a comment on discussion Open Discussion

2014-12-09T01:55:03.296000Z

I ran the following select value from nls_database_parameters where parameter='NLS_CHARACTERSET';...

James Sumners posted a comment on discussion Open Discussion

2014-12-08T13:55:17.454000Z

Would you be willing to ask this question on StackOverflow using the pljson tag?...

Haytham Alzeini modified a comment on discussion Open Discussion

2014-12-08T09:50:50.866000Z

Hi, I'm using PL/JSON to parse data from MongoDB to Oracle DB. The Packages work...

Haytham Alzeini modified a comment on discussion Open Discussion

2014-12-08T08:41:27.957000Z

Hi, I'm using PL/JSON to parse data from MongoDB to Oracle DB. The Packages work...

Haytham Alzeini posted a comment on discussion Open Discussion

2014-12-08T08:34:24.731000Z

Hi, I'm using PL/JSON to parse data from MongoDB to Oracle DB. The Packages work...

anpegar posted a comment on discussion Open Discussion

2014-12-01T10:48:59.148000Z

Hi Jonas !! Thank you very much for your reply but it doesn't work :-( I've attached...

PL/JSON released /PL_JSON/v1.0.5/json_v1_0_5.zip

2014-11-30T14:32:02.912000Z

Jonas Krogsboell committed [r43]

2014-11-30T14:30:14.131000Z

Jonas Krogsboell posted a comment on discussion Open Discussion

2014-11-30T12:25:19.391000Z

When you concatenate that way, you hit the 32K limit. You need to pretty print with...

Jonas Krogsboell posted a comment on discussion Open Discussion

2014-11-30T12:21:29.015000Z

There is no error. The non-strict parsing creates two strings: "TRUE" and "NULL"....

Jonas Krogsboell posted a comment on discussion Open Discussion

2014-11-30T12:18:38.685000Z

Perhaps you should look at https://sourceforge.net/p/pljson/code/HEAD/tree/svn/examples/ex11.sql...

Jonas Krogsboell posted a comment on discussion Open Discussion

2014-11-30T11:50:57.659000Z

get_string will return a string which is limited to 32K.

Jonas Krogsboell posted a comment on discussion Open Discussion

2014-11-30T11:47:59.794000Z

Does the test with the PL/JSON logo work?

Jonas Krogsboell posted a comment on discussion Open Discussion

2014-11-30T11:45:44.838000Z

I guess you are referring to the extension where you can omit the "'s. I would prefer...

Jonas Krogsboell posted a comment on discussion Open Discussion

2014-11-30T11:30:02.980000Z

With large amount of data, the performance is poor. The reason is the dataformat,...

Haytham Alzeini posted a comment on discussion Open Discussion

2014-11-27T08:58:11.431000Z

Hi, I'm using the script below in order to fetch JSON file from MongoDB, parse it...

Haytham Alzeini modified a comment on discussion Open Discussion

2014-11-27T08:57:42.255000Z

Hi, I'm using the script below in order to copy data from MongoDB to Oracle DB. The...

Haytham Alzeini modified a comment on a wiki page

2014-11-27T08:57:01.123000Z

Hi, I'm using the script below in order to fetch JSON file from MongoDB, parse it...

Haytham Alzeini modified a comment on a wiki page

2014-11-27T08:56:26.503000Z

Hi, I'm using the script below in order to fetch JSON file from MongoDB, parse it...

Haytham Alzeini posted a comment on a wiki page

2014-11-26T10:58:28.693000Z

Hi, I'm using the script below in order to copy data from MongoDB to Oracle DB. The...

Haytham Alzeini modified a comment on discussion Open Discussion

2014-11-26T10:58:17.656000Z

Hi, I'm using the script below in order to copy data from MongoDB to Oracle DB. The...

Haytham Alzeini posted a comment on discussion Open Discussion

2014-11-26T10:13:12.343000Z

Hi, I'm using the script below in order to copy data from MongoDB to Oracle DB. The...

anpegar posted a comment on discussion Open Discussion

2014-11-19T08:53:20.864000Z

Ok, thank you very much for your attention and I looking forward to hearing from...

Jonas Krogsboell posted a comment on discussion Open Discussion

2014-11-19T08:05:22.280000Z

Hi all I Will look into all the reported issues when i return from my vacation

anpegar modified a comment on discussion Open Discussion

2014-11-19T07:09:13.807000Z

Hi folk !! First of all, thank you to Jonas Krogsboell for his great package JSON....

anpegar posted a comment on discussion Open Discussion

2014-11-19T06:47:28.051000Z

Hi Herb !! Thank you for your reply ... at least I know that this foro is not dead...

Herb Swift posted a comment on discussion Open Discussion

2014-11-19T03:49:47.167000Z

No guarantee that this relates to, or fixes, what you've run into, but a few years...

anpegar posted a comment on discussion Open Discussion

2014-11-18T15:48:16.516000Z

I've continued researching and I've seen that only fails when I try to get a json...

anpegar posted a comment on discussion Open Discussion

2014-11-18T13:55:57.786000Z

Hi folk !! First of all, thank you to Jonas Krogsboell for his great package JSON....

James Sumners posted a comment on discussion Open Discussion

2014-11-17T17:46:35.973000Z

Can you make the change, perform a test, and report your findings?

Tom van der Duin posted a comment on discussion Open Discussion

2014-11-17T16:23:00.892000Z

The regualar expression that checks for valid characters in attribute names, is '^[[:alnum:]_...

Felipe García posted a comment on discussion Help

2014-11-04T20:02:55.558000Z

Hallo: I'm using pl/json on Oracle 11g. How can I use clob fieles using json? If...

Malnormalulo posted a comment on discussion Open Discussion

2014-10-07T15:59:41.147000Z

I'll file the bug. I'd debug and write the fix myself, but legal circumstances prevent...

James Sumners posted a comment on discussion Open Discussion

2014-10-01T17:26:52.829000Z

Please a file a bug at https://github.com/jsumners/pljson I'll look at it when I...

Malnormalulo posted a comment on discussion Open Discussion

2014-10-01T15:53:56.829000Z

DECLARE str VARCHAR2(100); foo json_list; BEGIN str := -- 1 2 3 4 5 6 '[ TRUE, NULL,...

neel shah posted a comment on discussion Open Discussion

2014-09-19T22:21:32.440000Z

HI I am using json_list to get a list of nearby people via geo coding I return the...

Tim Metzger posted a comment on discussion Open Discussion

2014-09-15T14:12:03.948000Z

That did the trick. Thanks for your help. Tim

Herb Swift posted a comment on discussion Open Discussion

2014-09-12T20:51:49.716000Z

This works for me: DECLARE j json := json('{"key":"value"}'); c CLOB; BEGIN j.print;...

Tim Metzger posted a comment on discussion Open Discussion

2014-09-12T20:04:58.043000Z

I am new to PL/JSON and have done a lot of searching and still can't find a solution....

omniok posted a comment on discussion Open Discussion

2014-09-01T12:09:11.278000Z

Hi, I have a standalone Core Java project which uses SOAP webservices to access some...

omniok posted a comment on discussion Help

2014-09-01T11:59:33.413000Z

Hi, I have a standalone Core Java project which uses SOAP webservices to access some...

James Sumners posted a comment on discussion Open Discussion

2014-08-25T20:02:13.182000Z

Are you generating the JSON?

Chris Schiffman posted a comment on discussion Open Discussion

2014-08-25T19:13:11.219000Z

Ok, so i think you're right.. it's not that it cant handle it, it's bad characters...

James Sumners modified a comment on discussion Open Discussion

2014-08-25T17:35:22.005000Z

dupe

James Sumners posted a comment on discussion Open Discussion

2014-08-25T17:34:23.025000Z

Did you dig into the error? It looks like your data contains characters that need...

James Sumners posted a comment on discussion Open Discussion

2014-08-25T17:33:51.437000Z

Did you dig into the error? It looks like your data contains characters that need...

Chris Schiffman posted a comment on discussion Open Discussion

2014-08-25T17:11:53.424000Z

Thanks James.. I tried this method and got: ORA-06502: PL/SQL: numeric or value error:...

Herb Swift posted a comment on discussion Open Discussion

2014-08-25T14:09:49.085000Z

Something I found immensely helpful are the 19 examples that Jonas provides in the...

James Sumners posted a comment on discussion Open Discussion

2014-08-25T13:14:03.386000Z

What have you tried? Have you looked through the documentation?

James Sumners posted a comment on discussion Open Discussion

2014-08-25T12:45:10.565000Z

declare v_json json := json('{"foo":"bar"}'); v_clob clob; begin dbms_lob.createtemporary(v_clob,...

Nagesh Patil posted a comment on discussion Open Discussion

2014-08-25T12:29:38.573000Z

Hi, how can I read values from JSON object , and that JSON object may contain JSON...

Nagesh Patil posted a comment on discussion Open Discussion

2014-08-25T12:24:02.411000Z

hi, if you want transfer data or print it on browser. check following code, i have...

Chris Schiffman posted a comment on discussion Open Discussion

2014-08-20T22:26:05.267000Z

Hello, I have a json object that has 3-4 elements.. one of the elements in the json...

Nagesh Patil posted a comment on discussion Open Discussion

2014-08-20T03:41:30.857000Z

Thanks Herb Swift. you clear my points. yesterday, I did some modification and got...

Herb Swift posted a comment on discussion Open Discussion

2014-08-19T15:28:50.127000Z

json_util_pkg.sql_to_json() returns a json_list, which isn't a native data type....