Problem exporting to Excel

[Joe Simunac]

I have a procedure that returns the results as a ref cursor. In previous versions (I'm now on 7.0.2.1076) when I opened the cursor I could select the items to export and right-click to copy to Excel. In the current version I only have Clear or Clear Results as options when I right-click. If I try to export the resultset (by selecting the Export Query Results with CSV), I get an Ora-00900 error (invalid SQL statement) and the resultset disappears.

Do I have something set wrong or is this a bug?

 

[Stew Stryker]

I get exactly the same behavior using the same version.

I even tried changing the preferences:

• File->Export->Export with smart quotes
• File->Export->Export to Excel with SQL statement

but no change even after regenerating the cursor.

 

[Marco Kalter]

This is indeed a (new) 7.0.2 bug. We'll correct this, and I will upload a fix shortly.

 

[Stew Stryker]

I thought this was a very esoteric bug, and I'd never need this feature. But Dang, wouldn't you know it? It turns out I NEED to use this feature TODAY! :-(

Any chance of a quick patch???

 

[Marco Kalter]

You can download a fix here .

 

[mhthomas]

Sorry for my ignorance, and resurrecting old thread.

I do not see the option to Export to Excel, rather I have CSV, TSV, HTML, XML. Do I need to configure something to make it work?

Current version 7.0.3.1123

 

[Marco Kalter]

Right-click on a result set and select "Copy to Excel". This works on the whole result set, or on the selected range of columns, rows or cells.