On Fri, 16 Aug 2002 06:52:06 GMT, "Jim Kennedy"
<kennedy-family_at_attbi.com> wrote:
>Your problem is that you are doing DDL which does an implicit commit.
>alter table add....
>Jim
><abc_at_iom.com> wrote in message
>news:3d5c6fea.101823554_at_news.sf.sbcglobal.net...
>> On Thu, 15 Aug 2002 23:02:51 GMT, Daniel Morgan
>> <dmorgan_at_exesolutions.com> wrote:
>>
>> >abc_at_iom.com wrote:
>> >
>> >> New to Oracle, here.
>> >>
>> >> If I enter a batch of commands in SQL*PLUS, I want to have them all
>> >> execute if the script is ok, or NONE executed if there's an error.
>> >> Right now it looks like only the non-error lines of the script get
>> >> executed. I'm looking for All-or-none.
>> >>
>> >> Thanks.
>> >
>> >I tried looking over your shoulder but I just couldn't see well enough
>> >to be sure what you are doing.
>> >
>> >Post the script so that we have some idea what you are refering to.
>> >
>> >Daniel Morgan
>> >
>> That's Ok, Dan, I haven't showered in a week since I started learning
>> this stuff. You wouln't WANT be looking over my shoulder at this
>> present moment <g>
>>
>> Well it's not so important to understand the commands I was typing.
>> It's more the situation that happened to me and how to prevent it.
>>
>> In SQLPlus, here's the gist of what I did:
>>
>> ALTER TABLE FOO ADD (NEWCOLUMN VARCHAR(10));
>> UPDATE FOO SET NEWCOLUMN= OLDCOLUMN;
>> ALTER TABLE FOO DROP (OLDCOLUMN);
>>
>> Now, If statement #2 fails because of some dumb typo (which it did),
>> I've just lost my data (which I did).
>>
>> In MSSQL, when you type a series of statements as a batch and run it,
>> if there is a compile error/syntax error in one of the statements, the
>> whole batch fails and doesn't execute. How can I get SQL*Plus to
>> behave that way?
>>
>> Thanks.
>>
>
>
Right. MS SQL compiles the script before exectuting it. Any errors
in the script and it doesn't run it. SQL2000 doesn't run the parts to
"do" comple.
Received on Sat Aug 17 2002 - 14:16:32 CDT
