How can I compare two JSON_OBJECT_T?
I have a PL/SQL procedure.
I am getting a return of an array of JSON OBJECT from GET request from HTTP API endpoint.
I have prepared a JSON_OBJECT_T record REC1.
I am trying to compare REC1 with every record in the return array from GET request. So as to figure if I need to do an UPDATE request or PUT request for REC1.
I am in Oracle 19C and am trying to use JSON_EQUAL to compare the JSON_OBJECT_T but getting following error:
PLS-00201: identifier ‘JSON_EQUAL’ must be declared
How can I achieve this in PL/SQL. Please suggest if there is another possible efficient method to achieve this.
Thank you.
Tried JSON_EQUAL
Expecting: Return Boolean if equal
Nishan Karki is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.