I have a strange situation.
I have imported a stored procedure in Oracle in to FM as query subject and it is executing fine by asking for input parameters in FM.
But when I simply pull the same in Report studio after publishing the package,it is not working and throwing the following error.
QE-DEF-0177 An error occurred while performing operation
'sqlOpenResult' status='-28'.
UDA-SQL-0114 The cursor supplied to the operation
"APICursor::OpenResult" is inactive.
UDA-SQl-0283 Metadata describing "XXX"
does not match results from the database wheree XXX stands for the name of the procedure.
Is it like the data that is retrieved would be converted to char by Rp as I have some Float fileds also that are returende.
I tried casting the same to char but still getting the same error.Can u pls help me asap.
Hi Kishore,
Even i am facing the same issue. It would be help if you can post the solution for the same
Did you check this:
http://www-01.ibm.com/support/docview.wss?uid=swg21342310 (http://www-01.ibm.com/support/docview.wss?uid=swg21342310)