Re: pl/SQL question

From: Christopher Beck <christopher.beck_at_oracle.com>
Date: Fri, 3 May 2002 15:24:07 -0400
Message-ID: <osBA8.19$jK4.155@news.oracle.com>

Tony,

Procedures and functions can be overloaded if they are defined within a package or a type. It is supported and works great. In fact, many of Oracle's supplied packages use overloading ( eg. dbms_sql ).

You can find out more about it here:
http://otn.oracle.com/docs/products/oracle9i/doc_library/901_doc/appdev.901/ a89856/09_packs.htm#580

hope this helps.

chris.

--
Christopher Beck, Principal Technologist, Oracle Corporation
christopher.beck_at_oracle.com

Beginning Oracle Programming,
http://www.amazon.com/exec/obidos/ASIN/186100690X

-----------

"tony" <ttigger4321_at_hotmail.com> wrote in message
news:3cd2da51.350489927_at_news.dal.ca...


> 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:24:07 CDT