I have been going through your post regarding Using Ref Cursors To Return Recordsetshttp://www.oracle-base.com/articles/mis ... rdsets.php
I would like to know the impact of this when using a sys_refcursor over a plain sql statement.
I do have a few functions which return sys_refcursor. So does this have any impact in performance if a plain normal sql statement is used instead of
sys_refcursor? Because a normal sql statement executes faster than a cursor.
Of course when calling from Java there are quite a few advantages of calling a function which returns a sys_refcursor.
Would like to hear your view point on this.