Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Procedures
andrija wrote:
>> Is it possible to create and drop tables from inside a procedure.
> It is possible. You just must use execute immediate statement.
...depending on your Oracle version. With version 8.0 and earlier, you'll have to go a more complicated way using dynamic SQL. I'll give you more details on request.
Bye,
Uwe.
Received on Thu Jan 10 2002 - 10:45:32 CST