| 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???
Nope, it works just fine, as long as your defaulted parameter is at the end
of the parameter list. They should be able to use the same signature they
did before. (I would hope that it was appended, but that may not be the
case).
Another option, if that is not the case, and if it's a packaged procedure : Overload the name of the procedure with the old signature, calling the new one with the defaulted values.
Diana
-----Original Message-----
From: Tamara Swilley [mailto:tswilley_at_agency.com]
Sent: Monday, October 09, 2000 5:30 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Optional Parm in a Stored Procedure???
Igor,
Thank you very much! I am now being told that "defaulting
only
works if you can name the parameters when you call the
stored proc. In
JDBC we can't do that"... so I don't know if your solution
will work, but I
am going to implement it and we can try it out. Thanks
again, I a very
grateful for your help. I will let you know it if works or
not.
Tamara
-----Original Message-----
Igor Neyman
Sent: Friday, October 06, 2000 2:55 PM
To: Multiple recipients of list ORACLE-L
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
> 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
> ----------------------------------------------------------
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: ineyman_at_perceptron.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). -- 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-LReceived on Mon Oct 09 2000 - 16:08:10 CDT
 |
 |