Skip to Main Content

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!

Null values in procedure input parameters

user586638Dec 4 2008 — edited Dec 4 2008
I have a debate with the application developers (c#)
They claim that it is malpractive of passing NULL values into procedure. Instead, they want me to handle it as:
Such as adding 1 "true/false" field to your procedure inputs:

Where input_number = database_value OR input_number is null


Where input_number = database_value OR ( ignore_input_number_flag = true )

What is the best way to handle NULL values?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 1 2009
Added on Dec 4 2008
14 comments
12,579 views