create table in a procedure

[DottingTheNet]

help plz!!
when i try to cretae a table in a procedure like

create procedure blah
is
begin
create table.....
......
end;

i get error PLS-00103 stating that it encountered CREATE when
expecting everything else..

thnx!!

[Jose Dorado]

Re: create table in a procedure

you need to execute a dynamic cursor.

declare
str long;
begin
str := 'create table test (i integer)';
execute immediate str;
end;
/