I am trying to create java stored procedure, everything seems to be setup correctly, but when I call the stored procedure I get the following error. How can I fix this or what am I doing wrong?
Here's the error:
SQL4306N Java stored procedure or user-defined function
"E1USER.INSERT_TN_BSFN", specific name "INSERT_TN_BSFN" could not call Java
method "javastp", signature "(Ljava/lang/StringV". SQLSTATE=42724
Here's the DB2 Procedure.
CREATE PROCEDURE E1USER.INSERT_TN_BSFN
(IN test GRAPHIC(30))
DYNAMIC RESULT SETS 0
PARAMETER STYLE JAVA
EXTERNAL NAME 'stpclass.javastp'
2008-03-10-20.53.08.823251-300 E172846G366 LEVEL: Warning
PID : 23670 TID : 3004169120 PROC : db2fmp
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, BSU Java support, sqlejLogException, probe:10
MESSAGE : ADM10000W A Java exception has been caught. The Java stack
traceback has been written to the db2diag.log.