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

erich.keane_at_verizon.net wrote:

> BEGIN
> ALTER TABLE "SYSTEM"."OpenBOXTest" DROP PRIMARY KEY;
> ALTER TABLE "OpenBOXTest" DROP COLUMN "ObxTestCol2" ;
> ALTER TABLE "OpenBOXTest" ADD ("ObxTestCol3" integer DEFAULT ''0'' );
> ALTER TABLE "SYSTEM"."OpenBOXTest" ADD PRIMARY KEY ("ObxTestCol1" );
> END;
> Error report:
> ORA-06550: line 2, column 1:
> PLS-00103: Encountered the symbol "ALTER" when expecting one of the
> following:

Just to re-emphasize what David wrote this is a nightmare. None of these items should ever have been created as SYSTEM. To perform DDL you must use dynamic SQL.

Someone with an understanding of Oracle needs to lock this database down with malice and aforethought.

-- 
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