Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: anonymous transaction and altering table

Re: anonymous transaction and altering table

From: Jeremy <newspostings_at_hazelweb.co.uk>
Date: Wed, 27 Apr 2005 16:38:41 +0100
Message-ID: <MPG.1cd9c259bd826073989e52@news.individual.net>


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?

-- 

jeremy
Received on Wed Apr 27 2005 - 10:38:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US