By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,197 Members | 972 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,197 IT Pros & Developers. It's quick & easy.

create table in a procedure

P: n/a
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!!
Jul 19 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
you need to execute a dynamic cursor.

declare
str long;
begin
str := 'create table test (i integer)';
execute immediate str;
end;
/
Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.