Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Stored Java procedure Problems again
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 malformedReceived on Fri Sep 29 2000 - 14:22:17 CDT
![]() |
![]() |