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!

Creating Functions with Variable Length Argument Lists

644978Aug 5 2009 — edited Aug 6 2009
I am wondering how to create a PL/SQL function with variable length argument lists. A good example of this is the LEAST function:

SELECT LEAST (1, 2, 3, 4, 5, 6, 7) FROM DUAL;
-- 1

I would like to create my own function which takes in any number of parameters as input. I've done some searching but cannot seem to find any documentation on this.

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 3 2009
Added on Aug 5 2009
11 comments
5,180 views