We have DB2 UDB v8.2 on RedHat Linux and are having problem calling a stored procedure from Java client. The name of the stored procedure is GROWTH_CHARTS which has three varchar "in" parameters and it returns an open cursor.
PROCEDURE GROWTH_CHARTS (
IN v_GUID VARCHAR(19),
IN v_temp VARCHAR(7),
IN v_ENC VARCHAR(19))
When we execute the stored procedure from the db2 command prompt it works fine.
db2 => call nwdb2.GROWTH_CHARTS('a', 'b', 'c')
Return Status = 0
When the GROWTH_CHARTS is called from a Java client we get the follwoing error -
java.sql.CallableStatement.executeQuery() was called but no result set
was returned. Use java.sql.CallableStatement.executeUpdate() for
When an isolated test case with the same SQL is run, it gives an error complaining it couldn't find a file: DB2 SQL error: SQLCODE: -444, SQLSTATE: 42724, SQLERRMC: GROWTH_CHARTS;SQL040916092620920;\GROWTH_CHARTS;GR OWTH_CHARTS;4.