DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002

    Post Function/Procedure with unlimited number of parameters.

    I want to know if it is possible to create a function/procedure (in a package or standalone) which can accept UNLIMITED number of parameters. For example the standard Oracle function GREATEST or LEAST which can accept any number of parameters (I am not sure if there is a limit on this number of parameters).

    I do not want to create a function with tooo many parameters assigning a default value for each. Also I do not want to create this function with a PL/SQL table (compatibility issues with Coldfusion)

  2. #2
    Join Date
    May 2001
    San Francisco, California
    Technically .. no limit... Your sharedpool size would determine the practical limit.
    Remember the Golden Rule - He who has the gold makes the rules!
    Ph.D., OCP 8i, 9i, 10g, 11g DBA

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.