Forms 4.5 and using overloaded functions
From: <sdevanat_at_my-dejanews.com>
Date: Tue, 02 Jun 1998 20:58:05 GMT
Message-ID: <6l1p0r$no4$1_at_nnrp1.dejanews.com>
[Quoted] I have a when-validate-item trigger that makes use of an overloaded function. [Quoted] 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 [Quoted] that worked the first time. For instance, if when-validate-item used the call [Quoted] validate_object(object_name), where in object_name is varchar2, the next time [Quoted] I use validate_object(object_id) where object_id is number, the validation fails. Oracle generates the error ORA-01475.
Date: Tue, 02 Jun 1998 20:58:05 GMT
Message-ID: <6l1p0r$no4$1_at_nnrp1.dejanews.com>
[Quoted] I have a when-validate-item trigger that makes use of an overloaded function. [Quoted] 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 [Quoted] that worked the first time. For instance, if when-validate-item used the call [Quoted] validate_object(object_name), where in object_name is varchar2, the next time [Quoted] 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 Tue Jun 02 1998 - 22:58:05 CEST