From: kahuna@panix.com (Andy Finkenstadt)
Newsgroups: comp.databases.oracle.misc
Subject: Re: PL/SQL parameter with a "DEFAULT"ed argument
Date: 8 Aug 2001 01:42:04 -0400
Organization: Me Myself and I
Lines: 20
Message-ID: <9kqjfc$86g$1@panix3.panix.com>
References: <9kq8n8$6b1$1@slb5.atl.mindspring.net>
Reply-To: kahuna@panix.com
NNTP-Posting-Host: panix3.panix.com
X-Trace: news.panix.com 997249325 20627 166.84.1.3 (8 Aug 2001 05:42:05 GMT)
X-Complaints-To: abuse@panix.com
NNTP-Posting-Date: 8 Aug 2001 05:42:05 GMT
X-Newsreader: NN version 6.5.6 (NOV)


In <9kq8n8$6b1$1@slb5.atl.mindspring.net> "Andrew Sprecher" <flathead@ix.netcom.com> writes:
>Anyone have an issue with a function defined like the following:
>myPackage.myProcedure ( myArgument Default '/directory' )...
>returning null within the scope of the procedure when the procedure is
>called like this:
>begin
>myPackage.myProcedure ( NULL ) ;
>end ;
>Thanks

What did you expect?  Default parameters are not null parameters.
They are not-specified parameters...

andy

-- 
Andrew Finkenstadt (http://www.finkenstadt.com/andy/)

Your question was: Oh Oracle most wise, if knowledge is power, what's ignorance?
Thus spake the Oracle: Horsepower.