Re: Begin... END; gives odd error:

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 13 Oct 2006 07:07:18 -0700
Message-ID: <1160748437.984495.250050@k70g2000cwa.googlegroups.com>

erich.keane_at_verizon.net wrote:
> BTW, I forgot to mention, I am executing this through a ODP.Net app.
>
> > You cannot directly perform DDL within a PL/SQL block. Also, WHY is
> > this table owned by SYSTEM? Looking at the ALTER TABLE statements I
> > find:

Within PLSQL you can use execute immediate to perform DDL.

Something like ...

begin

EXECUTE IMMEDIATE 'some ddl command'; end;

>
> Table is owned by system for ease at the moment. This is on a simple
> development database, so the owner is set by the configuration. Note
> that none of the hiarchy will make it to production at all.

Experimenting running things owned by SYS or SYSTEM is dangerous. Any collateral damage that is experienced by running things like that is not recommended. Received on Fri Oct 13 2006 - 09:07:18 CDT