How to handle NULL parameters,EMPTY parameters and ERROR HANDLING in stored procedure

[Soniad]

Hello,

I have stored procedure in which i am passing parameters (varchar(8000)),
these parameters can have values or can be empty (''), i have written blocks of codes for each parameter , which executes only if parameter has values, it should not enter the block if parameter is empty,
how to detect whether the parameter is empty or not.

and also i am having output parameter (varchar(1)) that is returned by stored procedure, if all of the parameters has values then output parameter returns some value, if any of the parameters is empty, then it doesn't go till the line where OUPUT parameter is set to some value, thats y no value is returned.
can anyone help me to sort out this problem.

Regards,

"D"

[ck9663]

You can actually give default values to those parameters during creation/definition.

Read it here


-- CK