Here is a link to a funny KB article:
XL97: Data Not Returned from Query Using ORACLE Data Source – http://support.microsoft.com/kb/168702
Method 2: Move Your Mouse Pointer
If you move your mouse pointer continuously while the data is being returned to Microsoft Excel, the query may not fail. Do not stop moving the mouse until all the data has been returned to Microsoft Excel.
NOTE: Depending on your query, it may take several minutes to return the results of your query to the worksheet.
Some funny comments:
@AdamMachanic – @BrentO I really like the note re: the query may take several minutes. Imagining a biz user, in a suit, moving the mouse for a half hour…
@BrentO – @AdamMachanic Or even better, the biz user gets their assistant to do it, and they put it on resume: “Oracle Input Device Administrator.”
@peschkaj – @BrentO You’re thinking low-tech. You put the mouse on one of those vibrating baby chair things.
@BrentO – @peschkaj ah, now that’s an enterprise solution right there.
Anyone else have any good ones they’d like to share??