Report 2.5 inserting results of report into a table [message #397977] |
Tue, 14 April 2009 13:10 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
jsunval
Messages: 2 Registered: April 2009
|
Junior Member |
|
|
Looking to take the results of an oracle report and inserting specific data from the report into a table after the report finishes running. Not sure where to start? I think I need to do something in the report triggers.
|
|
|
Re: Report 2.5 inserting results of report into a table [message #397999 is a reply to message #397977] |
Tue, 14 April 2009 15:03 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
I'd say that you are right - triggers are capable of inserting data into a table. What data are you, actually, talking about? If it is some kind of logging information (for example, time when report was executed), no problem.
If you'd, on the other hand, want to insert result of report's query, whoa, that's something different as you'll have to execute the report twice - first time to create report output, and the second time to do INSERT INTO ... SELECT FROM. I'm not sure that this is something I'd like to do.
|
|
|
|