PL/SQL based crosstab report error

[kalyan_sekhar1]

Hi ,

I created a report basing on PL/SQL stored Procedure, when i ran the report if i give the same parameters as given in Frame Work Manager while publishing its generating the report. But If i pass the different values its giving wiered error

Here is the Error Description:

UDA-SQL-0114 The cursor supplied to the operation "sqlOpenResult" is inactive.

UDA-SQL-0283 Metadata describing "PKG_MBU" does not match results from the database.

RSV-SRV-0025 Unable to execute this request.

Trace back:

WPBIBusMethod.cpp(190): QSException: CCL_CAUGHT: WPBIBusMethod::run

WPReportExecutionMethod.cpp(180): QSException: CCL_RETHROW: WPReportExecutionMethod::checkRequestForExceptions

WPExecuteRequestThread.cpp(169): QSException: WPExecuteRequestThread::checkException

WPEngine.cpp(946): QSException:

WPController.cpp(263): QSException: CCL_RETHROW: WPController::executeRendering()

LWDataRetrievalEngine.cpp(785): QSException: CCL_RETHROW: LWDataRetrievalEngine::iterateResultSets

Source/QEDmResultSet.cpp(76): QSException: CCL_THROW: QE

---------------------------------------------

If any body can provide info on how to solve will be great helpful

Thanks

[sir_jeroen]

Have you checked if it's text or numeric. I have had an error like that and  in FM i passed numeric but RS passed it as text.