Pass optional parameter to a PL/SQL procedure

From: Ak <a_sood_at_rediffmail.com>
Date: 1 Aug 2002 18:55:34 -0700
Message-ID: <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 Received on Fri Aug 02 2002 - 03:55:34 CEST

This message: [ Message body ]
Next message: Dany Kattar: "how to get license key"
Previous message: Jim Kennedy: "Re: Converting SQL View to Oracle View"
Next in thread: Sybrand Bakker: "Re: Pass optional parameter to a PL/SQL procedure"
Reply: Sybrand Bakker: "Re: Pass optional parameter to a PL/SQL procedure"
Reply: Jusung Yang: "Re: Pass optional parameter to a PL/SQL procedure"
Reply: Ak: "Re: Pass optional parameter to a PL/SQL procedure"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message