Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Externals and PLS-00311

Externals and PLS-00311

From: JimmyD <Jimmy_D__at_hotmail.com>
Date: Mon, 25 Sep 2006 19:16:19 +0300
Message-ID: <ef8v8u$qta$1@nyytiset.pp.htv.fi>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US