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,
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