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
}
			this.callStat.execute( );
			if ( this.callStat.getResultSet( ) != null )
				return new ResultSet( this.callStat.getResultSet( ) );
			else
				return new SPResultSet( null );
		}
		catch ( SQLException e )
		{
			throw new JDBCException( ResourceConstants.RESULTSET_CANNOT_RETURN,
					e );
		}
	}
	/**
	 * 
	 * @param position
	 * @param type
	 * @throws OdaException
	 */
	void registerOutParameter( int position, int type ) throws OdaException
	{
		assertNotNull( callStat );
		try
		{
			callStat.registerOutParameter( position, type );
		}
		catch ( SQLException e )
		{
			throw new JDBCException( ResourceConstants.QUERY_EXECUTE_FAIL, e );
		}