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 -
"com.ibm.db2.jcc.c.SqlException:
java.sql.CallableStatement.executeQuery() was called but no result set
was returned. Use java.sql.CallableStatement.executeUpdate() for
non-queries."

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.

Any help will be appreciated. Thanks!