Re: create table in a procedure
From: Jose Dorado <jose_jesus_dorado_at_yahoo.com>
Date: 9 Apr 2004 04:31:44 -0700
Message-ID: <30a05329.0404090331.584538f6_at_posting.google.com>
Date: 9 Apr 2004 04:31:44 -0700
Message-ID: <30a05329.0404090331.584538f6_at_posting.google.com>
you need to execute a dynamic cursor.
declare
str long;
begin
str := 'create table test (i integer)';
execute immediate str;
end;
/
Received on Fri Apr 09 2004 - 13:31:44 CEST