I think I remember something about PL/SQL having trouble when passing null to 
a function. But searchinf for pl/sql and null doesn't bring any informative 
links.

I can go through the steps of a function one by one in psql and everything 
works fine.

But when I call the function with nulls for some of the parameters, it 
doesn't work.

What puzzles me more is that I tried to pass 0 (zero) instead and then let 
the function subsitute it with null (simple IF param = 0 then v_param := null 
thing). Still no luck.

I'm using 7.0.3. 

-- 
Kaare Rasmussen            --Linux, spil,--        Tlf:        3816 2582
Kaki Data                tshirts, merchandize      Fax:        3816 2501
Howitzvej 75               ï¿½ben 14.00-18.00        Email: kar@webline.dk
2000 Frederiksberg        Lï¿½rdag 11.00-17.00       Web:      www.suse.dk

Sun, 1 Apr 2001 10:32:07 +0200
Kaare Rasmussen <kar@webline.dk>
PL/SQL and null
On Sun, Apr 01, 2001 at 10:32:07AM +0200, Kaare Rasmussen wrote:
> 
> What puzzles me more is that I tried to pass 0 (zero) instead and then let 
> the function subsitute it with null (simple IF param = 0 then v_param := null 
> thing). Still no luck.
> 
> I'm using 7.0.3. 

	Upgrade to 7.1. This has been fixed.

	-Roberto
-- 
+----| http://fslc.usu.edu USU Free Software & GNU/Linux Club|------+
  Roberto Mello - Computer Science, USU - http://www.brasileiro.net 
      http://www.sdl.usu.edu - Space Dynamics Lab, Web Developer    
*8 *8 *8                 <- Tribbles and mamas out for a stroll.

Sun, 1 Apr 2001 16:13:18 -0600
Roberto Mello <rmello@cc.usu.edu>
Re: PL/SQL and null