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
* 
	 * Constructor CallableStatement(java.sql.Connection connection) use JDBC's
	 * Connection to construct it.
	 *  
	 */
	public CallStatement( java.sql.Connection connection ) throws OdaException
	{
		if ( connection != null )
		{
			
			this.callStat = null;
			this.conn = connection;
			maxrows = 0;
		}
		else
		{
			throw new JDBCException( ResourceConstants.DRIVER_NO_CONNECTION,
					ResourceConstants.ERROR_NO_CONNECTION );
		}
	}
	/*
	 * @see org.eclipse.datatools.connectivity.oda.IQuery#prepare(java.lang.String)
	 */
	public void prepare( String command ) throws OdaException
	{
		logger.logp( java.util.logging.Level.FINE,
				CallStatement.class.getName( ),
				"prepare",
				"CallableStatement.prepare( \"" + command + "\" )" );
		try