No warning in SQLDeveloper 4.1.3 when creating an incorrect view

3165999 Jan 29, 2016 11:29 AM

In the newest release of SQL Developer the following incorrect view definition does not give an error/warning.

At least in release 4.0.3 and previous releases the behaviour was different.

Is this the intended behaviour in 4.1.x?

1. Re: No warning in SQLDeveloper 4.1.3 when creating an incorrect view

thatJeffSmith-Oracle Jan 29, 2016 3:40 PM (in response to 3165999)

No, that would be a bug.
Like Show 0 Likes(0)

Actions
2. Re: No warning in SQLDeveloper 4.1.3 when creating an incorrect view

BPeaslandDBA Jan 29, 2016 4:19 PM (in response to 3165999)

Do you get the same behaviour if you omit the FORCE keyword? That keyword is telling Oracle to create the view even if it is invalid.

Cheers,
Brian
Like Show 0 Likes(0)

Actions
3. Re: No warning in SQLDeveloper 4.1.3 when creating an incorrect view

thatJeffSmith-Oracle Jan 29, 2016 4:20 PM (in response to BPeaslandDBA)

SQL*Plus shows the warning message.
Like Show 0 Likes(0)

Actions
4. Re: No warning in SQLDeveloper 4.1.3 when creating an incorrect view

3165999 Feb 1, 2016 10:00 AM (in response to BPeaslandDBA)

When I omit the FORCE, I get the correct exception. In my opinion I should definitely get the warning (as in 4.0.x) even when I use FORCE.
Like Show 0 Likes(0)

Actions