Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: PL/SQL parameter with a "DEFAULT"ed argument

Re: PL/SQL parameter with a "DEFAULT"ed argument

From: Andy Finkenstadt <kahuna_at_panix.com>
Date: 8 Aug 2001 01:42:04 -0400
Message-ID: <9kqjfc$86g$1@panix3.panix.com>

In <9kq8n8$6b1$1_at_slb5.atl.mindspring.net> "Andrew Sprecher" <flathead_at_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.
Received on Wed Aug 08 2001 - 00:42:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US