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
parameterDefn.setParamType( Types.FLOAT );
		else if ( parameterName.equals( "NCHAR" )
				|| parameterName.equals( "NVARCHAR2" ) )
			parameterDefn.setParamType( Types.VARCHAR );
		else
			parameterDefn.setParamType( Types.VARCHAR );
	}
	/**
	 * @param schemaRs:
	 *            The ResultSet containing the List of schema
	 * @return A List of schema names
	 */
	private ArrayList createSchemaList( java.sql.ResultSet schemaRs )
	{
		if ( schemaRs == null )
		{
			return null;
		}
		ArrayList schemas = new ArrayList( );
		ArrayList allSchemas = new ArrayList( );
		try
		{
			while ( schemaRs.next( ) )
			{
				allSchemas.add( schemaRs.getString( "TABLE_SCHEM" ) );
			}
			
			Iterator it = allSchemas.iterator( );
			while ( it.hasNext( ) )
			{