Bug 199791 Sybase Stored Procedures and Temp Tables
Using BIRT 2.2.0 I am try to create a data set that accesses a procedure in ASE Sybase. I am able to select the procedure I want from the list available. The problem is, if the procedure contains a temporary table and that table is is used to return the result set, no output columns will be displayed. No preview results will be returned in the data set. If a standard SQL select statement is entered in place of the temporary table, output columns and preview results will be returned in the data set. Is there a configuration or parameter that I am missing? Thanks Mark
data/org.eclipse.birt.report.data.oda.jdbc/src/org/eclipse/birt/report/data/oda/jdbc/CallStatement.java
}
		return paramMetaDataList;
	}
	
	/*
	 * Temporary solution for database-specific dataType issues
	 */
	private void correctParamType( ParameterDefn parameterDefn )
	{
		String parameterName = parameterDefn.getParamTypeName( ).toUpperCase( );
		if ( parameterName.equals( ORACLE_FLOAT_NAME ) )
			parameterDefn.setParamType( Types.FLOAT );
		else if ( parameterName.equals( ORACLE_CURSOR_NAME ) )
			parameterDefn.setParamType( ORACLE_CURSOR_TYPE );
		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( );