SP

[tansdot]

can you create tables inside a stored procedure in 9i

[marist89]

yes, you have to use dynamic sql

[tansdot]

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

[Jr]

yes

[Jani]

Plz marist89 , Jr
write examples.

[Jr]

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.

[tansdot]

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