I am using a stored proc to build by report. This proc returns a refcursor. i.e in my proc, i insert the final data into a temp table and use an output cursor to fetch the result set to display it in the report. This report works fine when i run it locally but when i upload this report to CMC and schedule it it duplicates the records. i get twice the number of records. An investigation revealed that the proc is being called twice. is there any other way of calling the proc. Currently i am mapping the proc by connecting to the database which inturn reads all the columns from the temp table to map on the report fields. Is there a way to call stored proc from the command prompt to avoid this duplication.

i have used both OLEDB and ORacle connection with no luck. I tested the database and found that the proc is being called twice. not sure where it is being called twice.