Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Externals and PLS-00311
I have a following Java class
package com.firm.service;
public class JavaExtService
{
private static String serviceName = "This is service name";
public JavaExtService()
{}
public static String getServicenName()
{
return serviceName;
}
}
and I'm trying to create a function using it with command below
CREATE or REPLACE FUNCTION getExternalService
RETURN VARCHAR2
AS LANGUAGE JAVA
NAME 'com.firm.service.JavaExtService.getServiceName() return
java.lang.String';
But Exception PLS-00311 is thrown
" the declaration of "com.firm.service.JavaExtService.getServiceName()
return java.lang.String" is incomplete or malformed "
Can anyone see what could be wrong? Received on Mon Sep 25 2006 - 11:16:19 CDT
![]() |
![]() |