Home » Developer & Programmer » Reports & Discoverer » Oracle Discoverer 3.1 errorr - ORA-03123
Oracle Discoverer 3.1 errorr - ORA-03123 [message #241904] Wed, 30 May 2007 23:55 Go to next message
Messages: 5
Registered: December 2006
Location: DUBAI
Junior Member

Anybody please help me out in finding a solution for the above oracle discoverer error.

When I try to retrieve data above 2000 rows, the following error is displayed:
"ORA-03123:Operation would block
The data retrieved by the query is incomplete because it was
cancelled. Do you want to continue working with the sheet?

I highly appreciate quick response.

Abdul Mannan
Re: Oracle Discoverer 3.1 errorr - ORA-03123 [message #242133 is a reply to message #241904] Thu, 31 May 2007 14:17 Go to previous message
Messages: 913
Registered: March 2005
Location: Netherlands
Senior Member
You are aware of the fact that Discoverer 3.1 is an old, de-supported version?

Therefor, it's kind of hard to guess what's going on. But you could check in the option if there is a limit set in the query governor (as far as I recall, that was already there in 3.1), look for something like "limit rows to" and enlarge that number.

Does this error occur everytime you run this workbook?
Previous Topic: REP-50004: No report specified on the command line
Next Topic: Problem in Report Printing
Goto Forum:

Current Time: Sun Aug 20 06:49:11 CDT 2017

Total time taken to generate the page: 0.06738 seconds