Re: Why Oracle does not allow rollback of DDL statements?

Good discussion!

TSQL did (I think that is a statement of the past) suffer from a lack of modern exception handling.
However the problem of a lost/unhandled error condition appears to be orthogonal to what is actually lost.
I.e. assume SQL Server did auto commit its DDL (would that be what you get if you do not state BEGIN TRANSACTION??) and a statement failed. The script would continue just the same without the error being handled, correct?
So I think we cannot blame transactional DDL for lacking of exception handlers. ANSI SQL/PSM does provide these handlers btw.

Cheers
Serge

PS: When porting SQL Server apps to another DBMS (be it Oracle or DB2) the problem of lost errors is a major issue in general since TSQL developers have this nasty tendency to only do error checking wherher they think an error could appear (in SQL Server). Have spent oodles of time fixing these (and writing tools to track them)

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
.

Relevant Pages

  • Re: DTS object model
    ... Can I do validation & mapping, if I use BulkInsert Command in TSQL? ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... I want to create a text file connection and set the ...
    (microsoft.public.sqlserver.dts)
  • Re: Access Project
    ... Although I have never worked in an Access ADP I believe you need to use TSQL ... You probably want to replace the IIF() constructs with TSQL CASE function. ... Sql Server BOL has a good explanation and lots of examples. ...
    (microsoft.public.access.forms)
  • Re: Importing Multiple text files into one sql table
    ... >the working table you then need to run a series of TSQL ... >ExecuteSQL task. ... >www.allisonmitchell.com - Expert SQL Server Consultancy. ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL Server - Filter
    ... match their selection criteria. ... > and Sql Server and what worked for me. ... > have millions of records, then yes, you can write regular Access queries ... is to write my tSql statements through com ADO. ...
    (comp.databases.ms-access)
  • Re: DTS and DB2/400
    ... If you want the Key then you will have to rewrite to TSQL and apply ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... > I am in the process of migrating my database from DB2/400 to SQL Server ... A table with a primary key is being migrated without the primary key ...
    (microsoft.public.sqlserver.dts)