Re: Optional Parm in a Stored Procedure???

Use DEFAULT for this new parameter, so it becomes 'optional' when calling this stored procedure.

Igor Neyman, OCP DBA
Perceptron, Inc.
(734)414-4627
ineyman_at_perceptron.com

• Original Message ----- From: "Tamara Swilley" <tswilley_at_agency.com> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, October 06, 2000 4:05 PM Subject: Optional Parm in a Stored Procedure???

> 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).
Received on Fri Oct 06 2000 - 15:00:21 CDT