Re: Pass optional parameter to a PL/SQL procedure
From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2 Aug 2002 00:29:27 -0700
Message-ID: <a20d28ee.0208012329.3afa4f55_at_posting.google.com>
Date: 2 Aug 2002 00:29:27 -0700
Message-ID: <a20d28ee.0208012329.3afa4f55_at_posting.google.com>
a_sood_at_rediffmail.com (Ak) wrote in message news:<10cb5393.0208011755.1a730368_at_posting.google.com>...
> Hi,
>
> I have a PL/SQL procedure that accepts certain number of input
> parameters. One of the input parameters, passed to the procedure, at
> times can be null. Is there a way in PL/SQL to declare a parameter
> optional or otherwise is there a work around.
>
> Thanks!
> Ak
refer to
http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/appdev.817/a77069/07_subs.htm#6822
Please try to search the docs before you post
Regards
Sybrand Bakker
Senior Oracle DBA
Received on Fri Aug 02 2002 - 09:29:27 CEST