SP

can you create tables inside a stored procedure in 9i

yes, you have to use dynamic sql

But can you create a table using execute immediate inside a stored procedure

yes

Plz marist89 , Jr
write examples.

declare
begin
execute immediate 'create table myt ( c char ) tablespace testtbsp ';
end;
/

BTW - Execute immeidate is available from 8i and u need to use DBMS_SQL pckg for the same if below 8i.

Thanx
Jr.

But try putting this inside a stored procedure ; It fails for me giving insufficient privileges??