Message-Id: <10644.118830@fatcity.com> From: Diana Duncan Date: Mon, 9 Oct 2000 17:08:10 -0400 Subject: 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@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@perceptron.com ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" Sent: Friday, October 06, 2000 4:05 PM > 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@agency.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Tamara Swilley > INET: tswilley@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@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: Igor Neyman INET: ineyman@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@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@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@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L