Execute Data Modifying Stored Procedure from Reports

[vamsivanka]

we have a store procedure in oracle that has insert, update and delete commands.

Framework Manager is not letting me to add the procedure as Data Query because it has insert commands. so i changed it into data modifying object.

how can i execute the stored procedure from the Cognos report ?

e.g. procedure inserts the data into a temp table, and report shows the data from the temp table.