Re: Externals and PLS-00311

Hi Jimmy,

I'm not sure if you pasted your code or typed it, but the method name doesn't correspond to your call

Your method has the "n" character between Service and Name - ServicenName:
> public static String getServicenName()

and you are trying to call:
> com.firm.service.JavaExtService.getServiceName()

Sorry for the stupid note, if I'm wrong ...

Cheers,
Goran

JimmyD wrote:
> 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 Wed Sep 27 2006 - 03:28:21 CDT