Hi,
Please give me some advice on how to debug effectively the PL/SQL side of an incoming OData REST webservice request when the input is a complex structure.
As long as there are some simple parameters to the request, it is fine, I can specify them in the test window of PL/SQL Developer.
However, it can be quite painful to build a complex structure (like several customer orders and their lines and their child rows) in PL/SQL before calling the request.
Ways I tried:
- Remote debug with Oracle SQL Developer → could not get through the error: ‘insufficient privileges’ for DBMS_DEBUG_JDWP package (I granted everything and added ACLs)
- Tried to find within IFS how the conversion of JSON to Oracle types are done - that way I could copy the JSON part of the request to the test window of PL/SQL Developer, where I would convert it to the proper Oracle record type that is defined in My…._SVC package and pass it to the the appropriate method in My..._SVC package
Any recommendation is welcome.
Thanks
Janos