Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo
I have been trying to convert a refcursor to json list using pl/sql json utility. Looks like it takes more time, for 1500 records to covert it takes about 6+ minutes.
Is there any way to improve the performance of ref_cursor_to_json function in the json_utility package?
Have you tried out the json_dyn package?
Not sure on how to use json_dyn package to convert a refcursor in to json_list.
Can you please help me on how to do that?
uncomment the two functions in the spec and body of json_dyn.
It will only work if you're on 11g