SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OUT parameter with NOCOPY hint of type SYS_REFCURSOR

user2946813Mar 26 2012 — edited Mar 26 2012

Hi,
I am having a procedure which returns a set of 100+ records (each record having 10+ columns) through a OUT parameter of type SYS_REFCURSOR.
These output records are used in JAVA code for fecthing the resultset and process data.
Will it make any difference in performance if I use NOPCOPY compiler hint in this procedure (especially I am interested in the interaction between JAVA and PLSQL, with and without NOCOPY parameter).
Thanks.

Edited by: user2946813 on Mar 25, 2012 9:15 PM

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 23 2012

Added on Mar 26 2012

5 comments

1,821 views