Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> stored procedure: dinamically create / insert / drop table
Hi,
during a procedure execution I want to dinamically create a table and insert rows in this table.
execute immediate 'create table X1...';
insert into X1;
when trying to compile the procedure the problem is that X1 table does not exist so I have to use dynamic SQL to do the INSERT . Is there any way to avoid this problem?
thanks, Received on Thu May 20 2004 - 06:15:58 CDT