Place SQL statements in PL/SQL procedure but failed...

Hello all,

   I create the following procedure:

create or replace procedure testing as
begin

   create table a as ...
   create view b as ...
   truncate table c;
   drop table c;
end;

   However, there is something wrong in compilation.

   How can I place the above SQL statements in PL/SQL procedure such that when I execute this procedure, the above SQL statements will be executed?

   I am using Oracle 7.3.3.

Thanks,
David

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Jan 06 2000 - 13:36:37 CST