Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: stored procedure: dinamically create / insert / drop table
Just trying to change the name of some of the columns
?maybe ALTER TABLE would be enough
"Frank van Bortel" <fvanbortel_at_netscape.net> escribió en el mensaje
news:c8i6sd$o5v$1_at_news1.tilbu1.nb.home.nl...
> 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
>
Received on Fri May 21 2004 - 01:38:56 CDT