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 Received on Fri Oct 06 2000 - 14:00:59 CDT