| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Optional Parm in a Stored Procedure???
DEFAULT should work for you eg.:
PROCEDURE my_proc (param1 NUMBER, param2 VARCHAR2, param3 NUMBER DEFAULT 1)
HTH Witold
On 6 Oct 2000, at 12:05, Tamara Swilley wrote:
> Hi Gurus,
> I have two sets of users (one in Illinois, one in Calif)
> who need to use a
> stored procedure called by java servlets. I have added a
> column to the table
> that this stored procedure uses and also updated the stored
> procedure to include
> the new input parm and compiled it into the database. The
> users are asking if
> there is a way to make this one new input parm "optional"
> within the stored
> procedure somehow. This is the group that needs the older
> version. If I can
> make this parameter "optional" within the stored procedure
> then neither group
> would have to change their servlet code and both would be
> able to use the new
> version of the stored procedure.
> I'm on 8.1.5 on Unix, Solaris 2.6... is this possible and
> if so, how would
> I change the stored procedure to recognize this "optional"
> input parameter?
> Thanks in advance!!
>
> Tamara Swilley
> Oracle DBA
> AGENCY.COM-Vail
> 970-845-2173
> tswilley_at_agency.com
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Tamara Swilley
> INET: tswilley_at_agency.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
 |
 |