Hi,
Need to ask suppose there is a procedure P in package and it is returning several rows using SYS_REFCURSOR to some application as resultset. In current scenario SYS_REFCURSOR pointer to every row will proceed one after other. So if we want to return a large resultset in that case it will be slow.
My Question is , is there any other approach through which we can return fast result set.