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
&& schemaPattern.indexOf( "." ) != -1 )
			{
				packagePattern = schemaPattern.substring( schemaPattern.lastIndexOf( "." ) + 1 );
				schemaPattern = schemaPattern.substring( 0,
						schemaPattern.lastIndexOf( "." ) );
			}
			
			if ( schemaPattern != null )
			{
				schemaList = new ArrayList( );
				schemaList.add( schemaPattern );
			}
			else
			{
				java.sql.ResultSet rs = metaData.getSchemas( );
				schemaList = createSchemaList( rs );
				rs.close( );
			}
			
			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 = null;