Bug 124059 Stored procedure: parameters: default value required
Create a stored procedure data set. Use valid argument in query, eg. {call sp_tables('CUSTOMERS')} A parameter is created and a default value is required; data set cannot be saved until you change the argument to a question mark and define a default value. Shouldn't you be able to hard-code an argument and not have to define a parameter?
data/org.eclipse.birt.report.data.oda.jdbc/src/org/eclipse/birt/report/data/oda/jdbc/CallStatement.java
logger.logp( java.util.logging.Level.FINE,
				CallStatement.class.getName( ),
				"executeQuery",
				"CallableStatement.executeQuery( )" );
		try
		{
			if ( !maxRowsUpToDate )
			{
				try
				{
					assertNotNull( callStat );
					callStat.setMaxRows( maxrows );
				}
				catch ( SQLException e1 )
				{
					
					
				}
				maxRowsUpToDate = true;
			}
			
			
			
			IParameterMetaData paramInfo = getParameterMetaData( );
			int count = paramInfo.getParameterCount( );
			for ( int i = 1; i <= count; i++ )
			{
				if ( paramInfo.getParameterMode( i ) == IParameterMetaData.parameterModeInOut
						|| paramInfo.getParameterMode( i ) == IParameterMetaData.parameterModeOut )
					registerOutParameter( i, paramInfo.getParameterType( i ) );