Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: anonymous transaction and altering table
In article <1114611187.309591.175910_at_o13g2000cwo.googlegroups.com>, Mark
D Powell says...
> 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.
>
>
He didn't say he was using PL/SQL though - from my reading of it he is wanting to execute the script which contains DDL and PL/SQL and DML in one go - which of course is just what sqlplus will give him?
-- jeremyReceived on Wed Apr 27 2005 - 10:38:41 CDT