SQL Window ignoring errors

[boaglio]

Hi,

We have a strange problem with SQL Window.

If we try to run an incomplete statement, like this one:

create or replace package this_is_a_test
as
begin

  procedure another_test;

Since the "end" is missing, it should inform an error, but what actually happen is showing no error.

If I try the same thing running SQL*Plus, it will have the same result, but it tells me the package was created with compilation errors.

 

[Hilarion]

The SQL Window will not inform you about compilation errors. The "create" instruction was successful - it did create the object (no Oracle error).

If you want to know the compilation errors, then you should be using the proper Window type - the Program Window.