Skip to Main Content

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!

REF CURSOR or SQL Object Type

Pranay DeepMar 22 2017 — edited Mar 23 2017

Hi,

I have a procedure which returns a row of a table. Is it better to use ref cursor or SQL Object Type to return the row of the table? Will there be any performance difference with respect to both the return types ?

Thank You.

This post has been answered by BluShadow on Mar 22 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 20 2017
Added on Mar 22 2017
5 comments
1,181 views