we have some code which is working on Oracle 12.2, but it must also work on
12.1.0.2.
The problem is, on 12.1 json_object_t, json_array_t and json_object_t are not available or have some limitations to 12.2.
What we need in the next two day.
For two different json formats we need PL/SQL code (compliant to 12.1) which assign json content to variables and print out the content ad debug information. As soon as your code is available, we will replace the debug output with the relevant INSERT statements to create the content in our DB
Enclosed are two json formats with sample data:
I have also added some of the 12.1 non-compliant code as an example.
Thanks","employmentType":["FULL_TIME","PART_TIME","CONTRACTOR","TEMPORARY","PER_DIEM"],"jobLocationType":"TELECOMMUTE","hiringOrganization":{"@type":"Organization","name":"Toogit","sameAs":"https://www.toogit.com/","logo":"https://www.toogit.com/images/toogit_logo_initial.png"},"identifier":{"@type":"PropertyValue","name":"Toogit","value":309309},"skills":["Oracle PLSQL"],"applicantLocationRequirements":[{"@type":"Country","name":"IN"},{"@type":"Country","name":"Canada"},{"@type":"Country","name":"USA"},{"@type":"Country","name":"Germany"},{"@type":"Country","name":"Pakistan"},{"@type":"Country","name":"Philippines"},{"@type":"Country","name":"Indonesia"},{"@type":"Country","name":"Sri Lanka"},{"@type":"Country","name":"Nigeria"},{"@type":"Country","name":"China"},{"@type":"Country","name":"Russia"},{"@type":"Country","name":"Bangladesh"}],"validThrough":"2025-01-28T06:26:35+05:30","url":"https://www.toogit.com/freelance-jobs/MzA5MzA5"}
Remote Web Development Job In IT And Programming
Find more Web Development remote jobs posted recently Worldwide
Work from Anywhere
40 hrs / weekFixed Type
Remote Job$47.90
Cost Looking for help? Checkout our video tutorial
How to search and apply for jobs
How to apply? Do you have more questions about the Job?
See frequently asked questions
ORACLE DBA SME to conduct a 30 minute interview and 30 minute feedback session via skype. I am currently preparing for a DBA internship interview. Based on the job description and my resume test me according to the difficulty of the position.
I need my blogspots blog to connect to instant articles. I need help in that problem or I need approval service for that. Waiting for your proposals. I will pay you 40$ for approving.
I ran the Termination Report developed in SQL and generated output for every terminated employee except within the duration.
But one terminated employee did dot show up even though people form looks the same as other terminated employee.read more
I need my blogspots blog to connect to instant articles. I need help in that problem or I need approval service for that. Waiting for your proposals. I will pay you 40$ for approving.
Required DBA (On Site) having have proficiency on Java, J2ee, SQL, SQL Server, Network Administration and Oracle Technology.
Application developed in MVC 4 and need to upgrade to MVC 6 (MsSQL Server 2017, 2018)
SQL Server (2008 R2 TO 20...read more