Re: stored function not found !!

From: Pieter Steenhuis <pieter.steenhuis_at_worldonline.nl>
Date: Wed, 30 Dec 1998 19:20:53 +0100
Message-ID: <368A6F05.59B75825_at_worldonline.nl>

This problem is caused by the prefix 'material.'.
Oracle tries to find a component f_get_unit_text in whatever material is, and can't find it.

"James A. Johnson" wrote:

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 Wed Dec 30 1998 - 19:20:53 CET