Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Possible to overload an Oracle Function?

Re: Possible to overload an Oracle Function?

From: Rüdiger J. Schulz <johannes.schulz_at_web.de>
Date: 24 Oct 2001 13:41:32 +0200
Message-ID: <3bd6a8ef@netnews.web.de>


"Steven Pannell" <steven.pannell_at_gmx.net> wrote:
>Hi,
>
>I was wondering if it is at all possible to overload an Oracle function with
>my own user defined function of the same name. i.e. can I overload the
>Oracle convert function with my own convert function?
>
>At the moment Oracle always calls it's own convert function and not mine.

--> you have to reference your own function like:

   select YOUR_SCHEMA_OR_USERNAME.convert(...) from dual;

>
>Thanks for any help,
>Regards,
>Steve.
>

-- 
__________________________________________________________
News suchen, lesen, schreiben mit http://newsgroups.web.de
Received on Wed Oct 24 2001 - 06:41:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US