You are right, I keep forgetting that ORACLE does not support BEGIN TRANSACTION.
As Michel mentioned, in ORACLE transactions are implicit.
>really?
>I did not thing that would work. In fact, I think I tried before and got an error. That's the reason I said ORACLE, cause I did use it in MS SQL.
>I'll try it again.
>
>>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?
Hector Correa