Peabody Blog - Automation Series #3 Complex Reports

Toad Data Point
1

Hi everyone, here is the third post in my Automation Series. This short video goes over exporting multiple result sets to Excel.

http://toadworld.com/Blogs/tabid/67/EntryId/997/Toad-Data-Point-Automation-Series-3-Complex-Reports.aspx

Enjoy,

Debbie

2

Hi,

This seems like a really nice feature, but when I try to do it I get the below error message:

Zip exception.Unable to read value at the specified position - end of stream was reached.

I’ve tried several times to make this work and I just can’t make it work - I’m using version 3.1.0.638 of Toad for Data Analysts.

Can you help me with this?

Thanks.

3

I have seen this once or twice a long time ago. It is coming from a third party control we use.

Can you try the simplest of examples. Use a query like ‘select from dual’ Oracle or ‘select 999’ and export to specific row and cell. Do you get this error in this case?

Debbie

P.S. You can always download our latest Beta and try.

http://tda.inside.quest.com/pageloader.jspa?sbinPageName=beta.htm&sbinPageTitle=Toad%20for%20Data%20Analysts%20Beta%20Program&product=toaddatapoint