| 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???
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-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of
Igor Neyman
Sent: Friday, October 06, 2000 2:55 PM
To: Multiple recipients of list ORACLE-L
Subject: 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
> 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).Received on Mon Oct 09 2000 - 15:28:08 CDT
 |
 |