Bug 191447 Repreview the Output Parameters in storedprocedure dataset will lead the exception
Description: Repreview the Output Parameters in storedprocedure dataset will lead the exception Build number: 2.2.0.v20070607-0630 Steps to reproduce: 1, Open the attached report design 2, Open the Data Set 3, Preview Output Parameters 4, Click OK button 5, Reopen the Data Set 6, Preview Output Parameters again Expected result: The preview should be successfully Actual result: Exception occurs Error log: org.eclipse.birt.data.engine.core.DataException: Cannot execute the statement. SQL statement does not return a ResultSet object. SQL error #1: Parameter #2 has not been set. at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.execute(PreparedStatement.java:567) at org.eclipse.birt.data.engine.executor.DataSourceQuery.execute(DataSourceQuery.java:494) at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQueryExecutor.executeOdiQuery(PreparedOdaDSQuery.java:338) at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(QueryExecutor.java:761) at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.executeQuery(ServiceForQueryResults.java:216) at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:152) at org.eclipse.birt.report.designer.data.ui.dataset.OutputParameterPreviewPage.updateResults(OutputParameterPreviewPage.java:256) at org.eclipse.birt.report.designer.data.ui.dataset.OutputParameterPreviewPage.access$1(OutputParameterPreviewPage.java:190) at org.eclipse.birt.report.designer.data.ui.dataset.OutputParameterPreviewPage$2.run(OutputParameterPreviewPage.java:165)
data/org.eclipse.birt.report.data.oda.jdbc.ui/src/org/eclipse/birt/report/data/oda/jdbc/ui/editors/SQLDataSetEditorPage.java
import org.eclipse.birt.report.data.oda.jdbc.ui.util.DbObject;
import org.eclipse.birt.report.data.oda.jdbc.ui.util.ExceptionHandler;
import org.eclipse.birt.report.data.oda.jdbc.ui.util.IHelpConstants;
import org.eclipse.birt.report.data.oda.jdbc.ui.util.Procedure;
import org.eclipse.birt.report.data.oda.jdbc.ui.util.ProcedureParameter;
import org.eclipse.birt.report.data.oda.jdbc.ui.util.Utility;
import org.eclipse.core.runtime.Preferences;
import org.eclipse.datatools.connectivity.oda.design.ColumnDefinition;
import org.eclipse.datatools.connectivity.oda.design.DataSetDesign;
import org.eclipse.datatools.connectivity.oda.design.DataSourceDesign;
import org.eclipse.datatools.connectivity.oda.design.ResultSetColumns;
import org.eclipse.datatools.connectivity.oda.design.ui.wizards.DataSetWizardPage;
import org.eclipse.jface.dialogs.IMessageProvider;
import org.eclipse.jface.resource.ImageDescriptor;
import org.eclipse.jface.resource.ImageRegistry;
import org.eclipse.jface.resource.JFaceResources;
import org.eclipse.jface.text.Document;
import org.eclipse.jface.text.IDocument;
import org.eclipse.jface.text.ITextOperationTarget;
import org.eclipse.jface.text.rules.FastPartitioner;
import org.eclipse.jface.text.source.CompositeRuler;
import org.eclipse.jface.text.source.LineNumberRulerColumn;
import org.eclipse.jface.text.source.SourceViewer;
import org.eclipse.jface.viewers.ComboViewer;
import org.eclipse.jface.viewers.IStructuredContentProvider;
import org.eclipse.jface.viewers.IStructuredSelection;
import org.eclipse.jface.viewers.LabelProvider;
import org.eclipse.jface.viewers.Viewer;
import org.eclipse.swt.SWT;
import org.eclipse.swt.custom.BidiSegmentEvent;