My PL-SQL code has a default parameter set to 0.
When I am passing the variable as null it is failing as the default value of "0" is not assigned to the variable which is used in the where clause of the query.
What could be the problem why the default value is not assigned to my variable.