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
amannan
Messages: 5
Registered: December 2006
Location: DUBAI
Junior Member
HI,

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?
YES/NO".

I highly appreciate quick response.

Regards,
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
skooman
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: datalink not functioning
Next Topic: Problem sorting alphabetical caracters with numbers
Goto Forum:
  


Current Time: Sat Nov 30 00:58:26 CST 2024