Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Pl/SQl function to insert data

497797Jun 1 2006 — edited Jun 2 2006
Here 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?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 30 2006
Added on Jun 1 2006
5 comments
664 views