Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

ref_cursor_to_json Performance

2012-08-31
2013-05-28
  • Hi,

    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?

    Regards,
    Wilson

     
  • Have you tried out the json_dyn package?

     
  • Hi,

    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?

    Regards,
    Wilson

     
  • uncomment the two functions in the spec and body of json_dyn.
    It will only work if you're on 11g