CODEWITHSUNDEEP
sqloracle-databaseoracle-sqldeveloper
Paul
Paul

Reputation: 3582

Oracle DB & SQL Developer: "Error report: execution completed with warning" - How do I *see* the warning?

I'm setting up a local oracle (11g) database - a clone of another database we have running already. I'm running a bunch of generated PL/SQL commands in SQL Developer.

I get the output 

Error starting at line x in command: 
*long-ass SQL statement here* 
Error report: 
SQL Command: force view "someViewName"
Failed: Warning: execution completed with warning

How do I read the warning that has been generated without modifying the script?

when I use the show errors immediately after this command, I get the output no errors

Upvotes: 17

Views: 34918

Answers (2)

stephen meckstroth
stephen meckstroth

Reputation: 345

The cause of the error is just simply forgetting your semi-colon at the end of your code. Or if it is PL/SQL you are forgetting your forward slash at the end.

Upvotes: -5

Alex Poole
Alex Poole

Reputation: 191520

If show errors doesn't give you anything:

select line, position, text
from user_errors
where type = 'VIEW'
and name = 'someViewName'
order by sequence;

That assumes you're creating it under your own schema; if not you can look in all_errors instead.

The columns are in the documentation:

ALL_ERRORS describes the current errors on the stored objects accessible to the current user.
DBA_ERRORS describes the current errors on all stored objects in the database.
USER_ERRORS describes the current errors on the stored objects owned by the current user. This view does not display the OWNER column.

Upvotes: 34

Related Questions