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!

Which subprogram should we prefer to return multiple values with OUT parameter?

917017Dec 11 2014 — edited Dec 12 2014

Hi,

I have worked on Procedures and Funtions and aware of their differences. Today I have got a interview question that - Suppose I have to return multiple values through a subprogram and I Neither want to execute any DML inside that subprogram Nor I want to use that subprogram in SQL query. Which subprogram should I prefer - "Procedure" or "Function" and why?

According to me, Both can be used in this case, but want to see your views/opinions.

regards,

Sachin Jaiswal

This post has been answered by BluShadow on Dec 11 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 8 2015

Added on Dec 11 2014

15 comments

654 views