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

From: <laulau823_at_my-deja.com>
Date: Thu, 06 Jan 2000 19:36:37 GMT
Message-ID: <852qs3$a42$1_at_nnrp1.deja.com>



Hello all,

   I create the following procedure:

create or replace procedure testing as
begin

[Quoted] [Quoted]    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 - 20:36:37 CET

Original text of this message