Hello DB Gurus,
While working on one of the use cases for a project, I came across one challenge.
Scenario: Source system calls the SP to retrieve the ref_cursor object. Inside the stored procedure, I have a webservice invokation and the response contains multiple records and this should be mapped to the ref_cursor(XML to cursor conversion).
To fulfill this gap of conversion, I thought that I can use a temp table where all the webservice response message is mapped and ref_cursor can point to this table. However, this approach is definitely going to give performance issues.
Please suggest in case you know of any in-built libraries/solution that does this job.
Thanks,
Vikas