Bug 211384 [Regression]Refresh issue of multiple parameters on Stored Procedure Dataset[07]
Description: [Regression]Refresh issue of multiple parameters on Stored Procedure Dataset[07] Build number: 2.3.0.v20071129-0800 Steps to reproduce: 1, New a stored procedure dataset and make sure the procedure including multiple input or output parameters 2, After specify the query, go to parameters page Expected result: After step2, all the required parameters listed in parameters page Actual result: Refresh the page all the paremeters listed
data/org.eclipse.birt.report.data.oda.jdbc/src/org/eclipse/birt/report/data/oda/jdbc/CallStatement.java
* redirect the call to JDBC callableStatement.execute(), since
		 * currently only support the single result set, we just return the
		 * first none null result set from callable statement
		 */
		
		java.sql.ResultSet rs = null;
		try
		{
			this.callStat.execute( );
			rs = this.callStat.getResultSet( );
			while ( rs == null && this.callStat.getMoreResults( ) )
			{
				rs = this.callStat.getResultSet( );
			}
			if ( rs != null )
				return new ResultSet( rs );
			java.sql.ResultSet resultSet = getOutputParamResultSet( );
			if ( resultSet != null )
				return new ResultSet( resultSet );
			else
				return new SPResultSet( null );
		}
		catch ( SQLException e )
		{
			throw new JDBCException( ResourceConstants.RESULTSET_CANNOT_RETURN,
					e );
		}
	}
	
	/*