stored function not found !!
From: Tab Liao <tabliao_at_ms14.hinet.net>
Date: Fri, 18 Dec 1998 03:17:34 GMT
Message-ID: <75ch6q$gdv_at_netnews.hinet.net>
Hi,
PL/SQL: Statement igored
Date: Fri, 18 Dec 1998 03:17:34 GMT
Message-ID: <75ch6q$gdv_at_netnews.hinet.net>
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 Fri Dec 18 1998 - 04:17:34 CET