troubleshooting Question

Is it possible for an Oracle package to identify which parameters have been supplied?

Avatar of Milleniumaire
MilleniumaireFlag for United Kingdom of Great Britain and Northern Ireland asked on
Oracle Database
7 Comments1 Solution382 ViewsLast Modified:
I need to build a stored package procedure that can accept multiple parameters e.g. 20, however, some calls to the package will supply fewer than 20 parameters, some will provide all 20 parameters.

The values of those parameters that are supplied will be used to insert/update a table, however, for the parameters that aren't supplied the related columns in the table will be left untouched.

I'm aware that I could identify which parameters have been omitted by setting default values that would never be supplied to the procedure.  This would work okay for character and date values, however it isn't possible to identify a particular numeric value that wouldn't be supplied.

I could also use overloading to handle the various numbers of parameters, but this could result in a lot of overloaded definitions of the procedure and I would prefer to do it through inspecting the data.

Is it possible to determine which parameters have NOT been supplied to a package procedure?
Join our community to see this answer!
Unlock 1 Answer and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros