I am in a SQL Developer worksheet, connected, I can run queries etc without a problem. However, when I attempt to export the results the wizard comes up with a blank connection dropdown. Clicking on Next brings up the error dialog Validation failed with the message "connection is required".
The connection dropdown of the worksheet is also greyed out. I assume this is related to the failure to pass the connection to the Export Wizard. The workaround is to just log out and log back in, but this has happened several times over the last couple of days, and it's started to get provoking. So I'd welcome a more satisfactory solution.
The version is : 3.0.04.
BTW the tabs of the affected worksheets have the Worksheet icon but decorated by a yellow start with a red outline (or it may be Chaos symbol, it's too small to tell). This might be a red herring, but info on the meaning of all the SQL Dev icons seems hard to come by.
As soon as I typed the version number I knew you would suggest an upgrade. Alas, it's in a shared RDP instance with a locked down configuration. So upgrades take a long time to get approved.
I have no idea if this will work, but that's never stopped me before :)
Could you try opening an un-shared worksheet and running your query from there, and then trying the export?
Without being able to replicate your behavior in my copy of SQLDev v3, this is the closest I could think of in terms of a possible workaround...