create table in a procedure

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;
/

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