Re: pl/SQL question

From: Richard Kuhler <noone_at_nowhere.com>
Date: Fri, 03 May 2002 19:18:06 GMT
Message-ID: <OnBA8.5641$M7.2334289@twister.socal.rr.com>

Yes, you can overload in pl/sql as long as they have different parameters. I didn't have any problems finding this under "overloading" in the 8i and 9i PL/SQL User's Guide.

Richard

tony wrote:
>
> Java allows a technique known as method overloading. This is where
> you have 2 (or more) methods by the same name but with different
> parameter signatures. Depending on what parameter list is passed the
> method with the matching signature is invoked.
>
> It seems that I can do the same thing in pl/sql with procedures. The
> specification includes the following:
>
> PROCEDURE tbl_add;
> PROCEDURE tbl_add (v_action VARCHAR2,newcode VARCHAR2,newdesc
> VARCHAR2);
>
> Everything appears to work fine but I can't find supporting
> documentation so I'm not sure if this is a good thing to do. It could
> save us a pile of work.
>
> Any comments are welcome.
> cheers,
> tony
> 494-1021 w
> 461-4550 h
Received on Fri May 03 2002 - 14:18:06 CDT