Re: anonymous transaction and altering table

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Wed, 27 Apr 2005 11:28:32 -0700
Message-ID: <1114626273.274736@yasure>

Jeremy wrote:

> 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?

Please re-read what you wrote:

"He didn't say he was using PL/SQL"
"execute the script which contains DDL and PL/SQL"

Perhaps it is just me but I do believe you contradicted yourself within a single sentence.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Wed Apr 27 2005 - 13:28:32 CDT