Hi,
I created a PL/SQL stored procedure which accepts parameters and published the Procdure. Now i included that procedure in Framework Manager, and when I clicked on Test Query Subject it will ask for Prompt Values for the parameter defined in Stored Procedure. I gave the Values and tested it is doing fine and showing the Result, but when i change the parameters from Options and Test its giving the error,
How do i make the Procedure to accept any values for the parameters ? i guess some where initial values are hardcoded ? Here is the error info
---------------------------------------------------------------------------------------------------
QE-DEF-0177 An error occurred while performing operation 'sqlOpenResult' status='-28'.
UDA-SQL-0114 The cursor supplied to the operation "sqlOpenResult" is inactive.
UDA-SQL-0283 Metadata describing "New_Query_Subject1" does not match results from the database.
--------------------------------------------------------------------------------------------------
Thanks
Hi i m bck agn,
Its the problem of not updating the query subject, once you are updating the Cognos query subject with the new values and test the recent values are reflecting.
But how do i update the Query Subject from Reportnet , when ever its loaded ?
Thanks
hi
I don't know if this is going to help you out, but worth giving a try. I have had this problems many times, however the only thing I did is
>Delete the query,
>Close FrameWork manager and re-create the query again !