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/SPParameterMetaData.java
* @see org.eclipse.datatools.connectivity.IParameterMetaData#getParameterTypeName(int)
	 */
	public String getParameterTypeName( int param ) throws OdaException
	{
		logger.logp( java.util.logging.Level.FINE,
				SPParameterMetaData.class.getName( ),
				"getParameterTypeName",
				"SPParameterMetaData.getParameterTypeName( )" );
		assertNotNull( paramMetadataList );
		ParameterDefn paramDefn = (ParameterDefn) paramMetadataList.get( param -1 );
		return paramDefn.getParamTypeName();
	}
	/*
	 * 
	 * @see org.eclipse.datatools.connectivity.IParameterMetaData#getPrecision(int)
	 */
	public int getPrecision( int param ) throws OdaException
	{
		logger.logp( java.util.logging.Level.FINE,
				SPParameterMetaData.class.getName( ),
				"getPrecision",
				"SPParameterMetaData.getPrecision( )" );
		assertNotNull( paramMetadataList );
		ParameterDefn paramDefn = (ParameterDefn) paramMetadataList.get( param -1 );
		return paramDefn.getPrecision( );
	}
	/*
	 * 
	 * @see org.eclipse.datatools.connectivity.IParameterMetaData#getScale(int)
	 */