Re: pl/SQL question

Excellent! Thank-you.

On Fri, 3 May 2002 15:24:07 -0400, "Christopher Beck" <christopher.beck_at_oracle.com> wrote:

>
>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
>
>

cheers,
tony
494-1021 w
461-4550 h Received on Mon May 06 2002 - 07:31:35 CDT