Re: stored function not found !!

Your procedure catalog is corrupted, you must rerun the script rdbms/admin/catproc.sql (as sys).

_\\//

Christophe Nicolas, expert Oracle
www.capway.com/nicolas4/oracle/oracle.htm

Tab Liao a écrit dans le message <75htdk$dj1_at_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 Sun Dec 20 1998 - 15:02:09 CST