Re: Forms 4.5 and using overloaded functions

From: Developer <MSIS_at_cyberdude.com>
Date: Wed, 3 Jun 1998 09:03:49 -0400
Message-ID: <6l3hn5$8hi$1_at_beezer.infocom.com>


There are only to places in PL/SQL programs where you can overload modules: 1. Inside declaration section of a PL/SQL block. 2. Inside a package.
If you have two standalone function it will not work.

sdevanat_at_my-dejanews.com wrote in message <6l1p0r$no4$1_at_nnrp1.dejanews.com>...
>I have a when-validate-item trigger that makes use of an overloaded
function.
>The input parameter may be either a number or a varchar2. The first time
>through either method executes correctly. After that I can only use the
method
>that worked the first time. For instance, if when-validate-item used the
call
>validate_object(object_name), where in object_name is varchar2, the next
time
>I use validate_object(object_id) where object_id is number, the validation
>fails. Oracle generates the error ORA-01475.
>
>Is there any workaround? Currently, the stored code is in the database. We
>also tried putting a wrapper around the stored code and created overloaded
>functions in .pll files. We got the same errors.
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Wed Jun 03 1998 - 15:03:49 CEST

Original text of this message