Re: [GENERAL] alter table alter type CASCADE

[Thom Brown]

On 5 May 2010 13:14, Chris Barnes <compuguruchrisbar...@hotmail.com> wrote:

>
> It has been some years since I worked with Oracle, doesn't Oracle recompile
> the view when the object it references changes in structure?
> Send
>

What does Oracle do when you've got a view like:

CREATE OR REPLACE VIEW test_view AS
 SELECT test.test_id, test.test_value, date_is_future(test.test_date) as
upcoming
   FROM test;

Where date_is_future expects a text field, but you change the test table so
that test_date is now varchar(20)?  The function no longer matches the
signature.  Does it just prevent it?  And what about when conditions are
provided in a WHERE clause which become invalid when the column type
changes?

Thom