DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Function/Procedure with unlimited number of parameters.

  1. #1
    Join Date
    Oct 2002
    Posts
    2

    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
    Location
    San Francisco, California
    Posts
    511
    Technically .. no limit... Your sharedpool size would determine the practical limit.
    Remember the Golden Rule - He who has the gold makes the rules!
    ===================
    Kris109
    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