| Problems to get a Discoverer sheet [message #203004] |
Mon, 13 November 2006 08:51  |
mitch92
Messages: 2
Registered: November 2006
|
Junior Member |
|
|
Hello,
I've got a problem to extract a result sheet we designed with Oracle Discoverer Plus. The kind of sheet we have is a simple list of customers, with the criterias "name of the local branch" and "date of the appointment".
When we have only 1 or 2 customers planned for one given date, we get the sheet quite quickly, but when for another given date we have planned for example 7 customers, the software keeps displaying the "sorting" message before displaying an error message. When we execute exactly the same query with another tool like TOAD, the 7 answers are displayed within seconds ...
How could I solve this problem ? Is it a bug linked with Oracle Discoverer ?
|
|
|
|
|
|
|
|
| Re: Problems to get a Discoverer sheet [message #203240 is a reply to message #203024] |
Tue, 14 November 2006 07:30  |
skooman
Messages: 913
Registered: March 2005
Location: Netherlands
|
Senior Member |
|
|
I'm a bit confused about the "sorting" message you mention, but still, the reason might be that the query prediction Discoverer uses is taking too long. You could disable it and see what happens:
For Discoverer Desktop, in the Windows registry, set the DWORD value of the KEY_CURRENT_USER Software Oracle Discoverer902 Database QPPEnable registry key to 0 (zero).
For the web edition, set the parameter QPPEnable=0.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
