Skip to Main Content
Forums

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!

validating stored procedure parameters for not null

user4900730Mar 12 2010 — edited Mar 18 2010
As a part of SP parameter validation the first check we do is to verify all mandatory parameters for NOT NULL. Is it possible to refer to the parameters of ANY stored proc by generic names that will work for ALL SPs instead of having to hard code the SP specific parameter names?

Thanks in anticipation
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 15 2010
Added on Mar 12 2010
#parameter, #validation
2 comments
1,689 views