anonymous transaction and altering table

From: DaLoverhino <DaLoveRhino_at_hotmail.com>
Date: 26 Apr 2005 15:44:11 -0700
Message-ID: <1114555451.255648.98810@g14g2000cwa.googlegroups.com>

Hello.

I have a table named PAIR with a column that contains name=value pairs.

Now, I have a conversion script which goes through each row of this table, and parses the contents of the name-value column putting the results into two separate tables. The script kinda looks like this:

DECLARE
    ---
BEGIN

• Parse PAIRS and extract the name-value column data.
• Put the extracted data in another table. END

COMMIT; --- Complains

ALTER TABLE PAIRS drop column colname; --- Complains here too.

Forgetting about the COMMIT; for now, the anonymous block and the alter table commands work separately, but not together in a script. Why is that? I know I can use separate scripts to do it, but it would be great to put it all in one script.

Is there a command I can give to oracle that will allow me to do so?

thanks! Received on Tue Apr 26 2005 - 17:44:11 CDT