Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: variable list of arguments to a pl/sql procedure

Re: variable list of arguments to a pl/sql procedure

From: Daniel <danielroy10junk_at_hotmail.com>
Date: 10 Jun 2005 11:56:37 -0700
Message-ID: <1118429797.401928.323560@o13g2000cwo.googlegroups.com>


Why don't you use a package-level ref cursor, and process it in this package's procedures? That ref cursor could contain all the parameters you have to deal with, and is a flexible way to handle this problem. Note that it could be a weakly-typed cursor (if you don't know beforehand the type of the parameters) or a strongly-typed cursor.

Daniel Received on Fri Jun 10 2005 - 13:56:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US