Re: stored function not found !!
From: James A. Johnson <nimbus3_at_bellsouth.net>
Date: Mon, 28 Dec 1998 01:48:33 GMT
Message-ID: <3686E2F0.ABF77FBC_at_bellsouth.net>
Date: Mon, 28 Dec 1998 01:48:33 GMT
Message-ID: <3686E2F0.ABF77FBC_at_bellsouth.net>
Create a synonym for it.
Tab Liao wrote:
> Hi,
>
> when I create a stored function f_get_unit_text(), then
> when I execute
> select material.f_get_unit_text('1')
> from dual
> /
> I got
> ORA-06550: line 1 column 23:
> ORA-00302: component 'F_GET_UNIT_TEXT' must be declared
> ORA-06550: line 1 column 7:
> PL/SQL: Statement igored
>
> but when I execute
> select f_get_unit_text('1')
> from dual
> /
> it successfully executed, the function F_GET_UNIT_TEXT is created by
> MATERIAL oracle account under ORACLE 7.2.3/Digital Unix 3.x
>
> any help would be appreciated
>
> tabliao_at_ms14.hinet.net
> tab_at_muse.com.tw
Received on Mon Dec 28 1998 - 02:48:33 CET