sqlcode -4306 on stored procedure ....

From: Raquel (raquel_at_nospam.com)
Date: 06/24/04

  • Next message: Tobias Besch: "Re: Foxpro database connection" 
    Date: Thu, 24 Jun 2004 01:00:26 -0400

    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.

  • Next message: Tobias Besch: "Re: Foxpro database connection"