Thanks for the question, H.
Asked: December 19, 2000 - 2:37 am UTC
Last updated: December 19, 2000 - 2:37 am UTC
Version: 8.1.6
Viewed 1000+ times
You Asked
Hi Tom:
I have a table like:
create table bb ( n char( 10 ) );
and I have many stored procedure based on table bb, such as
create or replace procedure tt as
begin
insert into bb values ( '11' );
end;
when I run
select object_name, status from user_objects where object_name = 'TT';
it show me STATUS is VALID;
but after I modify table bb like :
alter table bb modify ( n char(11) );
and run:
select object_name, status from user_objects where object_name = 'TT';
it show me STATUS is INVALID;
Would you please tell me How to let the status VALID without
reinstall the source code of tt;
Thanks in advance.
Regards
Hjty
and Tom said...
Just run the procedure and it'll automagically compile itself.
If you really want to, you can
alter procedure tt compile;
as well. It is not necessary. The procedure will automagically compile itself when next executed.
Is this answer out of date? If it is, please let us know via a Comment