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.