Thread: SP
-
can you create tables inside a stored procedure in 9i
-
yes, you have to use dynamic sql
Jeff Hunter
-
But can you create a table using execute immediate inside a stored procedure
-
-
yes, you have to use dynamic sql
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??
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|