Re: CREATE/TRUNCATE in PL/SQL???
From: RValstar <rvalstar_at_aol.com>
Date: 1996/06/24
Message-ID: <4qlph5$8c9_at_newsbf02.news.aol.com>#1/1
end;
/
end;
/
Received on Mon Jun 24 1996 - 00:00:00 CEST
Date: 1996/06/24
Message-ID: <4qlph5$8c9_at_newsbf02.news.aol.com>#1/1
Try this (I believe I'm using Oracle 7.1 and PL/SQL 2.1):
create or replace procedure my_ddl
(ddl in varchar) as
hcursor integer := dbms_sql.open_cursor;
begin
dbms_sql.parse (hcursor, ddl, dbms_sql.v7); dbms_sql.close_cursor (hcursor);
end;
/
create or replace procedure my_proc as
begin
...
my_ddl ('truncate table my_table');
...
end;
/
Received on Mon Jun 24 1996 - 00:00:00 CEST