Parameter has to be NULL

[Stevenn]

I have some stored procedures which I am not able to see. I know that some parameters have to be NULL. But I don't know what it means if a parameter in a stored procedure "the_function(x, y, z)" has to be NULL. Should it be written as NULL or just an empty string; the_function(NULL) or the_function('')?

 

[Firefly2012]

In what system is the stored procedure stored? How are you passing your parameters to the stored procedure? Are you executing a snippet of SQL or using a parameters collection via whatever interface/connection technology you are using?