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
schemaPattern = procedureName.substring( 0,
						procedureName.indexOf( "." ) );
				procedureNamePattern = procedureName.substring( procedureName.indexOf( "." ) + 1 );
			}
			
			if ( schemaPattern != null )
			{
				schemaList = new ArrayList( );
				schemaList.add( schemaPattern );
			}
			else
			{
				schemaList = createSchemaList( metaData.getSchemas( ) );
			}
			
			if ( schemaList == null || schemaList.size( ) == 0 )
			{
				if ( schemaList == null )
					schemaList = new ArrayList( );
				
				schemaList.add( "" );
				columnNamePattern = "";
			}
			for ( int i = 0; i < schemaList.size( ); i++ )
			{
				java.sql.ResultSet rs = metaData.getProcedureColumns( cataLog,
						schemaList.get( i ).toString( ),
						procedureNamePattern,
						columnNamePattern );
				while ( rs.next( ) )