Re: stored function not found !!

From: Tab Liao <tabliao_at_ms14.hinet.net>
Date: Sun, 20 Dec 1998 04:18:17 GMT
Message-ID: <75htdk$dj1@netnews.hinet.net>

Hi, everybody :

I think I already found the reason why , see the sql statement listed below :

---

SQL*Plus: Release 3.3.3.0.0 - Production on Fri Dec 18 21:16:32 1998

Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.

Connected to:
Oracle8 Enterprise Edition Release 8.0.4.0.0 - Production PL/SQL Release 8.0.4.0.0 - Production

SQL> show user
user is "SCOTT"
SQL> create table scott
  2 (f1 number);

Table created.

SQL> r
  1 create or replace function n ( vin in number)   2 return number
  3 is
  4 begin
  5 return(vin * vin);
  6* end;

Function created.

SQL> select n(2)
  2 from dual;

     N(2)

---

        4

SQL> select scott.n(2)
  2 from dual;
from dual

     *
ERROR at line 2:
ORA-04028: cannot generate diana for object SCOTT.SCOTT

SQL> desc scott

 Name                            Null?    Type
 ------------------------------- -------- ----
 F1                                       NUMBER

SQL> r
  1 create or replace function n
  2 return number
  3 is
  4 begin
  5 return(100);
  6* end;

Function created.

SQL> select n
  2 from dual;

        N

---

      100

SQL> select scott.n
  2 from dual;
from dual

     *
ERROR at line 2:
ORA-04028: cannot generate diana for object SCOTT.SCOTT

SQL> connect transasia/transasia_at_dean
Connected.
SQL> create table transasia
  2 (f1 number);

Table created.

SQL> create or replace function n ( vin in number)   2 return number
  3 is
  4 begin
  5 return(vin * vin);
  6 end;
  7 /

Function created.

SQL> select transasia.n(10)
  2 from dual;
ERROR:

ORA-06550: line 1, column 24:
PLS-00302: component 'N' must be declared
ORA-06550: line 1, column 7:

PL/SQL: Statement ignored

no rows selected

SQL> 
SQL> 
SQL> drop table transasia;

Table dropped.

SQL> select transasia.n(10)
  2 from dual;

TRANSASIA.N(10)

---

            100

SQL>

---

tabliao_at_ms14.hinet.net (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 Sat Dec 19 1998 - 22:18:17 CST