SQL Developer 3.2.20.09
I feel so dumb ...
I modified a package, now it won't compile. When I run the sql-File that holds package specification and body it rightly complains that there are errors. I tells me to check the compiler log. First question: where to I find the log?
Ok, than I navigate in the connection browser to the package body itself which is marked as erroneous. ok. I open it. I right click and choose "compile" in the context menu. I would expect now that it shows me a list of syntax errors. But it does not. Nothing happens.
How am I suppose to debug this now? Should I switch back to sql-plus?
thanks for any help!
Thanks for your help - but this seems to get even more tricky:
I've tried to do the same thing on a windows machine, and there it works without problems.
The instance of sqldeveloper I have problems with is on ubuntu linux, I have downloaded and installed Sql Developer 3.2.2 for other platforms.
Apart from not being able to compile the package I also miss all the usual icons in the code editor view. See https://dl.dropboxusercontent.com/u/8595447/img86.png
Any ideas how to solve this?
I investigated more and found I was running SQL Developer with Java 7. Apparently it should only be run with java 6. So I made sure that it is started with the correct java version - and now it works ok. Icons are there again and it is possible to compile. Hurray!
Thanks for posting your solution! The impact of using Java 7 against 3.2.20.09.87 seems to vary by Java 7 update number and by OS. Perhaps someone else already posted a warning about Java 7 on Ubuntu, I don't recall, but it is always best to stick with certified versions.