Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> Re: create table in a procedure

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@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 - 06:31:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US