General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only