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

erich.keane_at_verizon.net wrote:
> Ok, I have agreed that it is a bad idea from the start. I did it
> because I am lazy! The database is meaningless, and stores Zero data.
> >From now on, I will store it as a separate user. You win on that. Can
> we please get to the issue I am having?
>
> My issue still remains, I am attempting to execute through ODP.Net a
> single event with the database, and am getting errors still. I
> followed the advice above to try a dynamic query, and am getting the
> illegal character (ORA-00911) error:
>
> BEGIN
> EXECUTE IMMEDIATE 'ALTER TABLE "TESTUSER"."OpenBOXTest" DROP
> CONSTRAINT "SYS_C0013604";
> ALTER TABLE "OpenBOXTest" DROP COLUMN "ObxTestCol2" ;
> ALTER TABLE "OpenBOXTest" ADD ("ObxTestCol3" integer DEFAULT 0 );
> ALTER TABLE "TESTUSER"."OpenBOXTest" ADD "PKConstraint_OBXTest" primary
> key ("ObxTestCol1" ) ';
> END;
You could always create a stored procedure in oracle that has the commands that you want and then just execute that stored procedure.

BEGIN
     my_funky_named_stored_proc;
END; Received on Fri Oct 13 2006 - 10:12:29 CDT