How to check compiler log in sql developer

Question

I get this error      Errors  check compiler log   How can I see compiler log in Oracle SQL Developer

User · Answer

I can also use      show errors    In sql worksheet

User · Answer

To see your log in SQL Developer then press   CTRL SHIFT   L  or CTRL   CMD   L on macOS   or     View -  Log    or by using mysql query     show errors

User · Answer

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

[logging] How to check compiler log in sql developer?

The answer is

Examples related to logging

Examples related to oracle-sqldeveloper

Tags