Re: Procedures

From: andrija <ar35644_at_fer.hr>
Date: Thu, 10 Jan 2002 16:25:30 +0100
Message-ID: <a1kbq9$emo6$1_at_as201.hinet.hr>


> Is it possible to create and drop tables from inside a procedure. If not
is
> there another way it can be done through a function, external procedure
etc
> if you can't do this from inside a procedure.

It is possible. You just must use execute immediate statement.

execute immediate 'create table ...'

Check the documentation for this statement. Received on Thu Jan 10 2002 - 16:25:30 CET

Original text of this message