>You could use SQLExec( nConnection, ‘BEGIN TRANSACTION’ )
>
>>I’m inserting into 3 tables in Oracle. Used to MS SQL server, I like to Begin transaction, End Transaction and Commit or Rollback using SPT.
>>The question is, how do I do that in Oracle?


No BEGIN and END TRANSACTION with Oracle.

The transaction begin with the first:
SELECT ... FOR UPDATE
UPDATE
DELETE
INSERT

and close with:
COMMIT
ROLLBACK



Ex.

SQLExec (1, "UPDATE XYZ SET COLNAME = 1") && New transaction
SQLExec (1, "DELETE ...") && Same transaction

SQLCommit (1) && or SQLExec (1, "Commit") && Close transaction