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

Home -> Community -> Usenet -> c.d.o.tools -> Stored Java procedure Problems again

Stored Java procedure Problems again

From: Chris Boyle <cboyle_at_nospam.hargray.com>
Date: Fri, 29 Sep 2000 15:22:17 -0400
Message-ID: <8r2pva$d3u6$1@news3.infoave.net>

Hello I need help figuring out this error. Please. Its for a stored procedure executing in Oracle 8i. Any ideas would be greatly appreciated I have looked at the docs and seem to be calling it correctly. Am I missing something simple? (or am I just simple?)

Thanks for any and all help
Chris

Heres the bit of code from the java program
/***************************************************************************
****/
public String BOB(String commandToSwitch){  DMS command = new DMS(commandToSwitch);  return bigString;
}

/***************************************************************************
******/

This is the wrapper

CREATE OR REPLACE FUNCTION dms2 (command VARCHAR2) RETURN VARCHAR2 AS
LANGUAGE java
name 'DMS.BOB (java.lang.String)
  RETURN java.lang.String';

and this is the error I get

Warning: Function created with compilation errors.

SQL> sho err
Errors for FUNCTION DMS2:

LINE/COL ERROR

-------- -----------------------------------------------------------------
0/0      PL/SQL: Compilation unit analysis terminated
4/2      PLS-00311: the declaration of "DMS.BOB(java.lang.String)
         RETURN java.lang.String" is incomplete or malformed
Received on Fri Sep 29 2000 - 14:22:17 CDT

Original text of this message

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