Menu
I get this error:
Errors: check compiler log
How can I see compiler log in Oracle SQL Developer?
797
Add 'show errors' after the create or replace, and use F5 instead of Ctrl+Enter. This will run the entire script, and ask Oracle to show us any errors for the session.
Once SQL*Developer links a database package to a file, it can auto-save the file with the freshly compiled text (ie click the "compile" button). Using the File view, you can easily see if the file has been commited to the Code Repository.
The following query may give you the list of running SQL ( SQL_ID ) from Active Sessions: select inst_id, program, module, SQL_ID, machine from gv$session where type!=
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)
172
I can also use
show errors;
In sql worksheet.
24
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
