AppletTalk.com

Raquel · Guest

A stored procedure that I am trying to run in DB2 receives
the error :

"[IBM][CLI Driver][DB2/NT] SQL4306N Java stored procedure or user-defined
function "DB2ADMIN.SP3", specific name "SQL040624101539958" could not call
Java method "sproc3mtd", signature "(Ljava/lang/String;[Ljava/la".
SQLSTATE=42724"

SQLCODE -4306; SQLSTATE 42724. SQLCODE -4306 has the following
description:

"The Java method given by the EXTERNAL NAME clause of a CREATE PROCEDURE
or CREATE FUNCTION statement could not be found. Its declared argument
list may not match what the database expects, or it may not be a "public"
instance method."

This is my client application call:
#sql {CALL DB2ADMIN.SP3(:in workdept,:out error)};
workdept and error are both defined as String.

This is my stored procedure method statement:
public static void sproc3mtd ( String workdept,
String[] errorlabel,
ResultSet[] rs1 ) throws Exception

This is my CREATE PROCEDURE statement:
CREATE PROCEDURE SP3 (IN in1 CHAR(6), OUT out3 CHAR(50))

Any ideas what could be the problem?

TIA
Raquel.