Re: stored procedure: dinamically create / insert / drop table

Jon wrote:

> 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,
>
>

What are you trying to do anyway? Why do you have a need to create a table 'on the fly'?
Platform/versions?

-- 

Regards,
Frank van Bortel