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":349374},"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":"2024-06-30T22:46:47+05:30","url":"https://www.toogit.com/freelance-jobs/MzQ5Mzc0"}
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.95
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
I am looking for Oracle Developer cum trainer who can help me to install software and help me to solve complex query issues, and this requires needed strong experience in database design, Unix shell script, PL/SQL and Performance tuning. For exampl...read more
I have a stored procedure in oracle DB that returns a table.
I need to do the following
1. Call the procedure from an oracle package
2. Use a table function to wrap the procedure
3. Use record type and table type as appropr...read more
Looking for a oracle application server admin. Currently have the forms and reports available in oracle 10g and Im looking to upgrade the forms reports to 11g.need someone who can help me with configuring and installing the oracle weblogic and oracl...read more
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.