PL/SQL and null
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
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.