I have imported one procedure in order to buiild report from it.
When I am running the procedure through SQL developer I am getting the data but when I tried to test the procedure with the same parameters in FM it is returning zero records.
1] I tried reimporting the procedure.
2] Checked the connection both sql developer and FM are pointing to(which is same).
3] checked all the required permissions are granted for cognos user.
4] For all other procedures I am able to get the data .
Please advise .
Quote from: devardekartb on 04 Apr 2016 11:00:19 AM
I have imported one procedure in order to buiild report from it.
When I am running the procedure through SQL developer I am getting the data but when I tried to test the procedure with the same parameters in FM it is returning zero records.
1] I tried reimporting the procedure.
2] Checked the connection both sql developer and FM are pointing to(which is same).
3] checked all the required permissions are granted for cognos user.
4] For all other procedures I am able to get the data .
Please advise .
Hi,
Does the stored procedure return a single uniform result set? Is it a user-defined stored procedure?
Take a look at the Framework Manager User Guide - page 70 - to make sure your stored procedure is of the correct type and format:
http://public.dhe.ibm.com/software/data/cognos/documentation/docs/en/10.2.2/ug_fm.pdf
Cheers!
MF.
yes the procedure returns a single uniform result set.it is a user-defined stored procedure.