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
Sign up for the SourceForge newsletter:
You seem to have CSS turned off.
Please don't fill out this field.