Unable to get data from procedure

[devardekartb]

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 .

[MFGF]

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.

[devardekartb]

yes the procedure returns  a single uniform result set.it is a user-defined stored procedure.