Activity for PL/JSON
-
George Thomas modified a comment on discussion Help
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
-
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
-
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
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
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
Hi, I have exactly the same problem. These types are invalid. Could you elaborate your solution? Thanks in Advance
-
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
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
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
I used pretty print to convert to varchar then I was able to use.
-
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...
-
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;
-
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
This issue got resolved . by recreating json_value to cust_json_value
-
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
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
Following is the JSON output I am getting from REST URL : { "type": "Campaign", "currentStatus":...
-
James Sumners posted a comment on discussion Help
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
How does this address the problem?
-
Is that reply intended to mean something?
-
https://github.com/pljson/pljson
-
https://github.com/pljson/pljson
-
I find json_ext.get_string() fails when the object searched for has any valid JSON...
-
It appears that JSON objects are not parsed correctly in PLJSON. Valid JSON keys...
-
Prakash Rai posted a comment on discussion Open Discussion
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
Hi, Has anyone managed to speed up outputting the json object to htp.p. We are finding...
-
github.com/pljson/pljson
-
packydevel posted a comment on discussion Open Discussion
Hi guys, i'm interested in JSON Schema validation. A useful feature that can be added...
-
Arun Singh posted a comment on discussion Help
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
Hi , I have this requirement to convert JSON format into result set (with rows and...
-
Hi , I have this requirement to convert JSON format into result set (with rows and...
-
Aries modified a comment on discussion Open Discussion
Hi, Is the error ORA-22813 coupled with ora-600 part of this limitation? I got the...
-
Hi, Is the error ORA-22813 coupled with ora-600 part of this limitation? I got the...
-
bumping to top
-
Please ask your question on StackOverflow using a "pljson" tag -- http://stackov...
-
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
/* -- i have the Table Rota (rota_iu number(10), name varchar2(40)) rota_iu Name...
-
/* -- i have the Table Rota (rota_iu number(10), name varchar2(40)) rota_iu Name...
-
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
I may have found the bug, second set of eyes would be great. In json_printer.ppMem...
-
(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)...
-
(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)...
-
(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
Sorry, I've been quite busy and will be for a while.
-
anpegar posted a comment on discussion Open Discussion
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
I ran the following select value from nls_database_parameters where parameter='NLS_CHARACTERSET';...
-
Would you be willing to ask this question on StackOverflow using the pljson tag?...
-
Hi, I'm using PL/JSON to parse data from MongoDB to Oracle DB. The Packages work...
-
Hi, I'm using PL/JSON to parse data from MongoDB to Oracle DB. The Packages work...
-
Hi, I'm using PL/JSON to parse data from MongoDB to Oracle DB. The Packages work...
-
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
-
-
When you concatenate that way, you hit the 32K limit. You need to pretty print with...
-
There is no error. The non-strict parsing creates two strings: "TRUE" and "NULL"....
-
Perhaps you should look at https://sourceforge.net/p/pljson/code/HEAD/tree/svn/examples/ex11.sql...
-
get_string will return a string which is limited to 32K.
-
Does the test with the PL/JSON logo work?
-
I guess you are referring to the extension where you can omit the "'s. I would prefer...
-
With large amount of data, the performance is poor. The reason is the dataformat,...
-
Hi, I'm using the script below in order to fetch JSON file from MongoDB, parse it...
-
Hi, I'm using the script below in order to copy data from MongoDB to Oracle DB. The...
-
Hi, I'm using the script below in order to fetch JSON file from MongoDB, parse it...
-
Hi, I'm using the script below in order to fetch JSON file from MongoDB, parse it...
-
Hi, I'm using the script below in order to copy data from MongoDB to Oracle DB. The...
-
Hi, I'm using the script below in order to copy data from MongoDB to Oracle DB. The...
-
Hi, I'm using the script below in order to copy data from MongoDB to Oracle DB. The...
-
Ok, thank you very much for your attention and I looking forward to hearing from...
-
Hi all I Will look into all the reported issues when i return from my vacation
-
Hi folk !! First of all, thank you to Jonas Krogsboell for his great package JSON....
-
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
No guarantee that this relates to, or fixes, what you've run into, but a few years...
-
I've continued researching and I've seen that only fails when I try to get a json...
-
Hi folk !! First of all, thank you to Jonas Krogsboell for his great package JSON....
-
Can you make the change, perform a test, and report your findings?
-
Tom van der Duin posted a comment on discussion Open Discussion
The regualar expression that checks for valid characters in attribute names, is '^[[:alnum:]_...
-
Felipe García posted a comment on discussion Help
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
I'll file the bug. I'd debug and write the fix myself, but legal circumstances prevent...
-
Please a file a bug at https://github.com/jsumners/pljson I'll look at it when I...
-
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
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
That did the trick. Thanks for your help. Tim
-
This works for me: DECLARE j json := json('{"key":"value"}'); c CLOB; BEGIN j.print;...
-
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
Hi, I have a standalone Core Java project which uses SOAP webservices to access some...
-
Hi, I have a standalone Core Java project which uses SOAP webservices to access some...
-
Are you generating the JSON?
-
Chris Schiffman posted a comment on discussion Open Discussion
Ok, so i think you're right.. it's not that it cant handle it, it's bad characters...
-
dupe
-
Did you dig into the error? It looks like your data contains characters that need...
-
Did you dig into the error? It looks like your data contains characters that need...
-
Thanks James.. I tried this method and got: ORA-06502: PL/SQL: numeric or value error:...
-
Something I found immensely helpful are the 19 examples that Jonas provides in the...
-
What have you tried? Have you looked through the documentation?
-
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
Hi, how can I read values from JSON object , and that JSON object may contain JSON...
-
hi, if you want transfer data or print it on browser. check following code, i have...
-
Hello, I have a json object that has 3-4 elements.. one of the elements in the json...
-
Thanks Herb Swift. you clear my points. yesterday, I did some modification and got...
-
json_util_pkg.sql_to_json() returns a json_list, which isn't a native data type....
1 >