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
private void registerOutputParameter( ) throws OdaException
	{
		
		if ( parameterDefn != null )
		{
			for ( int i = 0; i < parameterDefn.getParameterCount( ); i++ )
			{
				if ( parameterDefn.getParameterMode( i ) == IParameterMetaData.parameterModeOut
						|| parameterDefn.getParameterMode( i ) == IParameterMetaData.parameterModeInOut )
				{
					registerOutParameter( i + 1, getParameterType( i ) );
				}
			}
		}
	}
	
	/*
	 * Added to deal with database-specific cases. for instance,
	 * Types.OTHER->REF CURSOR->Any(odi)->Types.CHAR(oda). In above scenarios,
	 * metaData will be fetched again to correct the parameterDataType in case
	 * they've been changed already. Note there would be some extra tradeoff
	 * even the paramDataType is recognizable to us as we just can't tell for
	 * sure on jdbc level
	 */
	private int getParameterType( int i ) throws OdaException
	{
		if ( parameterDefn.getParameterType( i ) != Types.CHAR )
			return parameterDefn.getParameterType( i );
		IParameterMetaData paramMetaData = getParameterMetaData( );
		if ( paramMetaData != null && paramMetaData.getParameterCount( ) > i )