This is a long but here goes …
Can Oracle Reports connect to an existing session (made outside of the report) so it can access uncommited data ?
We have a complex report that is working great, but we just found out that in some cases it needs to access data that is not commited. It is a large amount of data and passing it in as a parameter may be either too much work or just too difficult due to the report calling database functions that also needs to access the uncommited data to generate text that appears in the report
Workflow
* Application creates some data … inserts and updated tables but does not commit
* Application runs the report
* Report displays the data that has not been commited