create table from procedure?

From: Volker Hetzer <volker.hetzer_at_ieee.org>
Date: Wed, 2 Jul 2003 12:58:13 +0200
Message-ID: <bduds6$efi$1_at_news.fujitsu-siemens.com>

 Hi!
[Quoted] I've got this little testcase where I create a table from a procedure and and using begin/end in sqlplus.
Why doesn't the create table work in the procedure too?

create or replace procedure testcase
is
begin
execute immediate 'create table volkerperftest.typeins_0 (indexcol integer, numcol integer,charcol char (200))'; end;
/

begin
testcase;
end;
/

begin
execute immediate 'create table volkerperftest.typeins_0 (indexcol integer, numcol integer,charcol char (200))'; end;
/

exit

Lots of Greetings and Thanks!
Volker

--
While it is a known fact that programmers
never make mistakes, it is still a good idea
to humor the users by checking for errors at
critical points in your program.
-Robert D. Schneider, "Optimizing INFORMIX
 Applications"

Received on Wed Jul 02 2003 - 12:58:13 CEST