This content has been marked as final. Show 12 replies
I'll restart SQL developer later as I'm in the middle of something and have to leave soon - but I had already tried running the SQL in Developer before posting and it output the expected answer, as per SQL Plus. Hence my current perplexed state.
I just wondered if there was a setting somewhere I might be missing.
Thanks for your help, Elaine
Can you create a new script called sqldev_test.sql and in it have something like
select * from scott.emp;
select count(*) from scott.dept;
And try running that? I'm wondering if there's a big problem in your setup with executing scripts, or if there's something in particular with your script we need to investigate.
If the above works, we might need to open up @el_ccn script and see what's what.
well - really not sure what's happening ....
I reset the test script, like you suggested, with a SELECT of columns from the table followed by the SELECT count(*). To add a bit of fairy-dust I added an alias to the COUNT(*) too.
Strangely only the COUNT(*) heading showed as before without any reference to the alias ...
Sounds as if it is something more fundamental is wrong. I think I'll defer this to our DBA to log a call with Oracle. unless anyone has any bright ideas.
Whenever some unexpected behavior occurs that is not a known bug, I always suspect corruption in the migrated settings / user preferences. The quickest way to test this is
1. Export any connection definitions you do not wish to lose.
2. Add the following line to your sqldeveloper.conf file ...
AddVMOption -Dide.user.dir=<path-to-user-preferences-folder>3. Restart the product without migrating any settings
The conf file is <sql developer home>\sqldeveloper\sqldeveloper\bin\sqldeveloper.conf. The ide.user.dir must be writable given whatever privileges your user has (and preferably on a non-network drive) and must differ from the default value SQL Developer uses (e.g., on Windows 7, C:\Users\<yourusername>\AppData\Roaming\SQL Developer).
If el_ccn.sql script works properly with the clean, default user preferences, then you can back out the change to the conf file, delete or rename the system3.2.20.09.87 folder in the default or original ide.user.dir folder, then restart the product, migrating or not migrating settings from a previous installation as desired.
Hope this helps,