Thread

1. PL/SQL and null

   Kaare Rasmussen <kar@webline.dk> — 2001-04-01T08:32:07Z

   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
   
   

2. Re: PL/SQL and null

   Roberto Mello <rmello@cc.usu.edu> — 2001-04-01T22:13:18Z

   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.