stored function not found !!
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
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>
====================================
Quote:
>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
