Skip to Main Content

DevOps, CI/CD and Automation

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!

Before report trigger execution sequence

user12024310Aug 25 2011 — edited Aug 25 2011
Hi,
What is the execution sequence of the before report trigger ?

In the report builder help, the definition says "The Before Report trigger fires before the report is executed *but after queries are parsed and data is fetched*."


But the oracle document "Oracle iDS Reports: Build Internet Reports: Volume 2: Student Guide" says

"Before a report executes; *after queries are parsed, but before records are fetched*


I have built a report where, i am populating a table A with some data in the before report trigger. The data model query is a "select * from A ". But the report o/p is blank since the before report trigger was fired after the query was parsed and fetched. My understanding is that the queries should only be parsed but not fetched before the "before report trigger"

Regards,
Suresh

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 22 2011
Added on Aug 25 2011
3 comments
2,841 views