Hi Larry,

Would putting the sql statements in an Oracle stored procedure restrict the rollback to the one table?

Paul

>Benn,
>One thing to add here is that you won't be able to specify a specific table to perform the Commit/Rollback on. These commands have session-wide functionality. If you had the following:

>sqlsetprop(nHandle,'Transaction',2)   && 1-Auto, 2-manual, see help
>sqlexec(nHandle,"INSERT INTO COUNTRY_ZONE VALUES ('12345','ABC')")
>sqlexec(nHandle,"INSERT INTO SOME_OTHER_TABLE VALUES ('Kilroy was here')")
>sqlexec(nHandle,"INSERT INTO SOME_OTHER_TABLE_AGAIN VALUES ('George Washington slept here')")
>sqlexec(nHandle,"commit/rollback")

>The other tables would be affected as well.
>