Re: How does Oracle do this?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 16 Aug 2006 19:33:16 +0200
Message-ID: <ljl6e2t1vs47abimhfonudhjq2km28503f@4ax.com>

On 16 Aug 2006 08:28:37 -0700, "stephen O'D" <stephen.odonnell_at_gmail.com> wrote:

>How can I do it the 'Oracle' way so that I can just write one of these
>functions or is Oracle using some insider tricks that we cannot use?

No.
Oracle is using overloading. You can use overloading too, if you put the procedure in a package.
Procedures like put_line in the dbms_output package are all overloaded.

Overloading is discussed either in the Application Developers manual and/or in the PL/SQL reference manual.

--
Sybrand Bakker, Senior Oracle DBA

Received on Wed Aug 16 2006 - 12:33:16 CDT