I get this error:
Errors: check compiler log
How can I see compiler log in Oracle SQL Developer?
+1
A:
control-shift-L should open the log(s) for you. this will by default be the messages log, but if you create the item that is creating the error the Compiler Log will show up (for me the box shows up in the bottom middle left).
if the messages log is the only log that shows up, simply re-execute the item that was causing the failure and the compiler log will show up
for instance, hit Control-shift-L then execute this
CREATE OR REPLACE FUNCTION TEST123() IS
BEGIN
VAR := 2;
end TEST123;
and you will see the message "Error(1,18): PLS-00103: Encountered the symbol ")" when expecting one of the following: current delete exists prior "
(You can also see this in "View--Log")
One more thing, if you are having a problem with a (function || package || procedure) if you do the coding via the SQL Developer interface (by finding the object in question on the connections tab and editing it the error will be immediately displayed (and even underlined at times)
tanging
2010-09-28 17:19:23
@tanging: thanks for your anwser mainly the connections part. But isn't working yes. I'm using 2.1.1.64 version. Which version are you using?
Topera
2010-09-28 17:40:54
Note: i'm creating a procedure
Topera
2010-09-28 17:43:23
@Topera , I am also on 2.1.1.64. when you go into the connections-->procedures-->[your procedure here] and make change and save it does not automatically open up the Compiler log @ the bottom? (that's how it works for me). is it possible that it is at the bottom of the screen and just hiding a bit? ( http://st-curriculum.oracle.com/obe/db/11g/r2/prod/appdev/sqldev/plsql_debug/images/crproc12.gif -- from Oracle site)
tanging
2010-09-28 18:00:03
@Topera hit enter too soon, what happens when you press Control-Shift-L?
tanging
2010-09-28 18:00:22
@tanging: when I opened the procedure and compile it works! I just don't works when I run sql in worksheet. Tks a lot!
Topera
2010-09-28 18:38:11