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
if ( packagePattern.trim( ).length( ) > 0 )
					rs = metaData.getProcedureColumns( packagePattern,
							schemaList.get( i ).toString( ),
							procedureNamePattern,
							columnNamePattern );
				else
					rs = metaData.getProcedureColumns( cataLog,
							schemaList.get( i ).toString( ),
							procedureNamePattern,
							columnNamePattern );
				while ( rs.next( ) )
				{
					ParameterDefn p = new ParameterDefn( );
					p.setParamName( rs.getString( "COLUMN_NAME" ) );
					p.setParamInOutType( rs.getInt( "COLUMN_TYPE" ) );
					p.setParamType( rs.getInt( "DATA_TYPE" ) );
					p.setParamTypeName( rs.getString( "TYPE_NAME" ) );
					p.setPrecision( rs.getInt( "PRECISION" ) );
					p.setScale( rs.getInt( "SCALE" ) );
					p.setIsNullable( rs.getInt( "NULLABLE" ) );
					if ( p.getParamType( ) == Types.OTHER )
						correctParamType( p );
					if ( p.getParamInOutType( ) != 5 )
						paramMetaDataList.add( p );
				}
				rs.close( );
			}
		}
		catch ( SQLException e )
		{