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.78
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
Please Note : This position is 100% Onsite at Leesberg , VA (NO REMOTE)
Urgent Need of a strong Oracle EBS techno-functional resource (70% Technical - 30% Functional ) Please note that this is not a pure technical role but requires a techn...read more
Hi,
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...read more
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 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