Can you give us a repeatable example with a common dataset like HR.EMPLOYEES?
Are you saying you're doing something like
WHERE EMPLOYEE_ID IN (1, 2, 3, ..., 152);
Yes, it's sometimes really as simple as:
where employee_id in (1,2,3,...152);
BTW, I just tested a different query on another database and there it successfully exported beyond 152 expressions.
I disconnected to the original database with the issue and still the limit seems to be in the same amount of expressions. changing select * to select column1 (and not other columns) doesn't seem to have an effect on the results.
I'm thinking the issue may be in 3 different places:
1. Memory of my client where the query is parsed (does this even happen in SQL Developer or on the Oracle DMBS?)
2. If 1 is not on the client, maybe there's some database limit that is exceeded somewhere
3. Some limit that is exceeded when the data is exported
1 and 2 seems very unlikely as all the records successfully shows on the output pane, and I can go all the way to the bottom. So it ran successfully at least and returned the records to the client.
Can you run the query multiple times without any problems?
Unless you have fetched the entire resultset down, when you do the export it runs the query again.
You could try to get around this issue using the formatter comments - add a /*csv*/ to your select and run with F5 - the data will come back automatically formatted in CSV.
My session stays in tact. So I can run it for the exceeded list, see all the data on the screen, try and export, get a blank file, and run the query again.
It's almost asif SQL dev thinks it's successfully exported it.
I have to add, I run my SQL Dev program with the following batch program:
c:\program files (x86)\java\jre7\bin\java.exe" -Xmx1024M -Xms128M -Xverify:none -Doracle.net.disableOob=true -Doracle.ide.util.AddinPolicyUtils.OVERRIDE_FLAG=true -Dsun.java2d.ddoffscreen=false -Dwindows.shell.font.languages= -XX:MaxPermSize=128M -Dide.AssertTracingDisabled=true -Doracle.ide.util.AddinPolicyUtils.OVERRIDE_FLAG=true -Djava.util.logging.config.file=logging.conf -Dsqldev.debug=false -Dide.conf="./sqldeveloper.conf" -Dide.startingcwd="." -classpath ../../ide/lib/ide-boot.jar oracle.ide.boot.Launcher
This was mainly to get the disableOob flag in so that I can cancel queries and resume my session.
Even with sqldeveloper.exe and sqldeveloperw.exe it doesn't work.