What's the difference?

I had some code handed over to me. It was "working" earlier, according to the guy who handed it over to me.

I noticed that all the null values were being passed using vbNull. I changed them to a Null and the procedure is firing without any issues.


I was wondering what the difference between the two is. Why would have the procedure worked earlier with a vbNull in it? This code is around since 1999.

The Oracle database was upgraded recently to a 10g.