Pl/SQl function to insert data
497797Jun 1 2006 — edited Jun 2 2006Here is what I am trying to do:
I want to create a simple stored function in database that inserts data into a temp table based on an input parameter received.
I want to create a workbook in discoverer to execute this function. When i create a calculation based on this function and run the report, its throws an error saying "ORA-14551 : Cannot perform a DML operation inside a query"
My objective is to insert data into a temporary table before executing a report to get data from the temp table.
Any solution/suggestions are most welcome?