Home » SQL & PL/SQL » SQL & PL/SQL » create procedure problem
create procedure problem [message #7812] Thu, 10 July 2003 05:47 Go to next message
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 Go to previous messageGo to next message
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;
/
Re: create procedure problem [message #7818 is a reply to message #7816] Thu, 10 July 2003 08:45 Go to previous message
inna
Messages: 6
Registered: July 2002
Junior Member
you do not need to commit after drop or create view
Previous Topic: MSSQL to Oracle SQL
Next Topic: ORA-01002 for CURSOR FOR LOOP
Goto Forum:
  


Current Time: Thu Mar 28 21:23:48 CDT 2024