stored function not found !! 
Author Message
 stored function not found !!

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





Tue, 05 Jun 2001 03:00:00 GMT
 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





Thu, 07 Jun 2001 03:00:00 GMT
 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


Quote:
>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>

>====================================

>>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






Thu, 07 Jun 2001 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Stored function , not stored procedure !?

2. ActiveX Scripting : the function was not found

3. request new feature: auto recompile of function when oid not found

4. During dump: function not found

5. dumpOneFunc(): procedural language for function listall not found

6. fgl_fatal(?) function not found when compiling

7. Extended stored procedure with dll cannot find function

8. Stored Procedure Not Found

9. Could not find stored procedure master..xp_jdbc_open

10. Error Could not Find Stored Procedure in Excecute SQL Task

11. stored procedure not found

12. could not find stored procedure


 
Powered by phpBB® Forum Software