Thanks Arnon,

I'll have a look at 'SAVEPOINT' in the Oracle Docs.

Paul


>If you put a single transaction (open and commit/rollback) then yes.
>But you can do that within your programs as well.
>
>If you want to increase your rollback granularity you'd probably be better off with setting SAVEPOINTs i.e.
>SAVEPOINT TABLEA
>INSERT INTO TABLEA...
>SAVEPOINT TABLEB
>INSERT INTO TABLEB
>
>ROLLBACK TO SAVEPOINT TABLEA //will rollback the 2 inserts
>ROLLBACK TO SAVEPOINT TABLEB //will rollback only the second insert
>I havn't tried that in VFP - but it works in ADO and should work with SQLEXEC
>
>Arnon
>>Hi Larry,
>>
>>Would putting the sql statements in an Oracle stored procedure restrict the rollback to the one table?
>>
>>Paul
>>