stored function not found !!

From: Tab Liao <tabliao_at_ms14.hinet.net>
Date: Fri, 18 Dec 1998 03:13:39 GMT
Message-ID: <75cgvf$gdv@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 Thu Dec 17 1998 - 21:13:39 CST