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

The server is on my computer, and will never ever be used by anyone but me. These databases will NEVER even get into anything more than that. I am testing an Oracle interface layer, and created it as the System account. When it comes time to actually do something, a DBA will be designing the data structure.

It is easier to just run the oracle as system, so that I don't have to deal with other things at the moment.

If you look, the table is even named 'test', which should have given a hint.

DA Morgan wrote:
> 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:
> >
> > Table is owned by system for ease at the moment.
>
> Ease of what? Ease of trashing the system. If you are being paid ... you
> are being paid to do a good job. Please reconsider.
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org
Received on Fri Oct 13 2006 - 07:25:11 CDT