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!

access to query results in after report trigger?

alexander.steinbeiszNov 14 2007 — edited Nov 14 2007
Hello!

Do I have any chance to access all my result in one of the querys in the after report trigger, without rewriting the query again?

Example: I have order-lines and I got a lot of order-line-ids in one of the groups/querys. at the end, I will mark them as "reported". I could do this with an update, using the same conditions as the querys ... but .. that is really sick, I need to keep the query twice.

so is there any chance like "for each :GROUP_NAME.FIELD_NAME loop" ... ?

best regards
Alexander
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 12 2007
Added on Nov 14 2007
1 comment
395 views