Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: anonymous transaction and altering table
Daniel is correct in that without the error messages all anyone can do
is guess. I am going to take a guess that you tried to mix DDL
commands and pl/sql. You cannot directly issue DDL statements from
within pl/sql. You have to use dbms_sql or execute immediate to issue
the DDL operation.
HTH -- Mark D Powell -- Received on Wed Apr 27 2005 - 09:13:07 CDT