I am having a problem with calling a stored procedure.  I have
replicated the problem with multiple JDBC drivers so it doesn't seem to
be driver related. The stored procedure works when I execute in SQL
Enterprise Manager so it isn't the SQL Manager. The code hasn't changed
and it was working at one time so I need help!

I am calling a simple stored procedure that either inserts or updates a
record into a single table and returns the ID for the record.  The
stored procedure definition is as follows:

    CREATE PROCEDURE dbo.updateDistrictFiles
        @brochureId int,
        @districtId int,
        @contactTypeId int,
        @fileDesc varchar(50),
        @filePath varchar(100),
        @brochureIdOut int OUTPUT
    ....

The java code invoking the SP is as follows:

  CallableStatement c = connection. prepareCall("? = call                        
updateDistrictFiles(?, ?, ?, ?, ?, ?)";
  int index = 1;

  cstmt.setInt(index++, getBrochureId());
  cstmt.setInt(index++, getDistrictId());
  cstmt.setInt(index++, getContactTypeId());
  cstmt.setString(index++, getBrochureDescription());
  cstmt.setString(index++, getBrochureLocation());

  cstmt.registerOutParameter(index, Types.NUMERIC); // tried INTEGER too

  recordCount = cstmt.executeUpdate();
  newBrochureId = cstmt.getInt(index);

The "executeUpdate" throws the Java Exception with the message:
[Microsoft][SQLServer 2000 Driver for JDBC]Invalid parameter binding(s).
Partial stack trace below.

Any help would be GREATLY appreciated!

TIA
Earl

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for
JDBC]Invalid parameter binding(s).
[11/15/04 17:55:53:066 CST] 30e29198 SystemErr     R     at
com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
[11/15/04 17:55:53:066 CST] 30e29198 SystemErr     R     at
com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
[11/15/04 17:55:53:066 CST] 30e29198 SystemErr     R     at
com.microsoft.jdbc.base.BasePreparedStatement.validateParameters(Unknown
Source)
[11/15/04 17:55:53:066 CST] 30e29198 SystemErr     R     at
com.microsoft.jdbc.base.BasePreparedStatement.validateParameters(Unknown
Source)
[11/15/04 17:55:53:086 CST] 30e29198 SystemErr     R     at
com.microsoft.jdbc.base.BasePreparedStatement.preImplExecute(Unknown Source)
[11/15/04 17:55:53:086 CST] 30e29198 SystemErr     R     at
com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown Source)
[11/15/04 17:55:53:086 CST] 30e29198 SystemErr     R     at
com.microsoft.jdbc.base.BaseStatement.executeUpdateInternal(Unknown Source)
[11/15/04 17:55:53:086 CST] 30e29198 SystemErr     R     at
com.microsoft.jdbc.base.BasePreparedStatement.executeUpdate(Unknown Source)
[11/15/04 17:55:53:096 CST] 30e29198 SystemErr     R     at
com.microsoft.jdbcx.base.BasePreparedStatementWrapper.executeUpdate(Unknown
Source)
[11/15/04 17:55:53:096 CST] 30e29198 SystemErr     R     at
com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeUpdate(WSJdbcPreparedStatement.java:555)
[11/15/04 17:55:53:096 CST] 30e29198 SystemErr     R     at
org.frb.chi.electronic.Brochure.update(Brochure.java:494)