Re: Externals and PLS-00311

JimmyD schreef:

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

Not being a Java programmer at all, I do think you cannot use a class in a PL/SQL function - you can call a java function, but not a class. Received on Tue Sep 26 2006 - 03:31:07 CDT