| Report 2.5 inserting results of report into a table [message #397977] |
Tue, 14 April 2009 13:10  |
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  |
 |
Littlefoot
Messages: 21808
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
