create procedure problem [message #7812] |
Thu, 10 July 2003 05:47 |
Abu Arbab
Messages: 13 Registered: June 2003
|
Junior Member |
|
|
Hi expert
I need to create pl/sql procedure in order to drop view and recreate it again and running this procedure thru the job schedule.
I appreciate your answer
Thanks
|
|
|
Re: create procedure problem [message #7816 is a reply to message #7812] |
Thu, 10 July 2003 08:21 |
Navtej
Messages: 19 Registered: July 2003
|
Junior Member |
|
|
cretae or replace procedure test is
begin
execute immediate 'drop view nav1';
commit;
execute immediate 'create view nav1 as select * from dba_users';
commit;
end;
/
|
|
|
|