Home » Other » Test » problem while executing function relating to java
problem while executing function relating to java [message #196143] Wed, 04 October 2006 05:54
vikas_miraj2003
Messages: 13
Registered: July 2006
Location: INDIA
Junior Member
create or replace function getEmpName (n IN number) return varchar2 is
language java name 'emp_v.getEmpName(int)
return java.lang.String';

the function above created

emp_v is table

When executed following query

sql> select getempname(2) from emp_v

got ERROR!!!
ORA-29540 CLASS EMP_V DOES NOT EXISTS

what is the problem if iam executing all in oracle 8i
if i need to install something extra for java class

please help.

Previous Topic: return results
Next Topic: Locked
Goto Forum:
  


Current Time: Thu Mar 28 20:22:55 CDT 2024