How to use ASP & Oracle and Transaction (BeginTrans,CommitTrans,RollbackTrans)

Author: admin | Posted: 24-04-2010 | Category: ASP & Oracle

How to use ASP & Oracle and Transaction (BeginTrans,CommitTrans,RollbackTrans) This is tutorial asp developers ASP and Oracle Database on Transaction mode (BeginTrans,CommitTrans,RollbackTrans).

ShotDev Focus:
- ASP & Oracle Transaction mode (BeginTrans,CommitTrans,RollbackTrans)

Example

asp_oracle_transaction1.asp


<% Option Explicit %>
<html>
<head>
<title>ShotDev.Com Tutorial</title>
</head>
<body>
<form action="asp_oracle_transaction2.asp" name="frmAdd" method="post">
<table width="600" border="1">
<tr>
<th width="91"> <div align="center">CustomerID </div></th>
<th width="160"> <div align="center">Name </div></th>
<th width="198"> <div align="center">Email </div></th>
<th width="97"> <div align="center">CountryCode </div></th>
<th width="70"> <div align="center">Budget </div></th>
<th width="70"> <div align="center">Used </div></th>
</tr>
<tr>
<td><div align="center"><input type="text" name="txtCUSTOMERID" size="5"></div></td>
<td><input type="text" name="txtNAME" size="20"></td>
<td><input type="text" name="txtEMAIL" size="20"></td>
<td><div align="center"><input type="text" name="txtCOUNTRYCODE" size="2"></div></td>
<td align="right"><input type="text" name="txtBUDGET" size="5"></td>
<td align="right"><input type="text" name="txtUSED" size="5"></td>
</tr>
</table>
<input type="submit" name="submit" value="submit">
</form>
</body>
</html>

asp_oracle_transaction2.asp


<% Option Explicit %>
<html>
<head>
<title>ShotDev.Com Tutorial</title>
</head>
<body>
<%
Dim Conn,strSQL,objExec
Set Conn = Server.Createobject("ADODB.Connection")
Conn.Open "Driver={Oracle in OraHome92};DBQ=TCDB;UID=myuser;PWD=mypassword;"

On Error Resume Next '*** Error Resume ***'

'*** Transaction Start ***'
Conn.BeginTrans

'*** Save Form ***'
strSQL = ""
strSQL = strSQL &"INSERT INTO CUSTOMER "
strSQL = strSQL &"(CUSTOMERID,NAME,EMAIL,COUNTRYCODE,BUDGET,USED) "
strSQL = strSQL &"VALUES "
strSQL = strSQL &"('"&Request.Form("txtCustomerID")&"','"&Request.Form("txtName")&"', '"&Request.Form("txtEmail")&"' "
strSQL = strSQL &",'"&Request.Form("txtCountryCode")&"','"&Request.Form("txtBudget")&"', '"&Request.Form("txtUsed")&"') "
Set objExec = Conn.Execute(strSQL)
Set objExec = Nothing

'*** already exists save form (CUSTOMERID is PK)***'
strSQL = ""
strSQL = strSQL &"INSERT INTO CUSTOMER "
strSQL = strSQL &"(CUSTOMERID,NAME,EMAIL,COUNTRYCODE,BUDGET,USED) "
strSQL = strSQL &"VALUES "
strSQL = strSQL &"('"&Request.Form("txtCustomerID")&"','"&Request.Form("txtName")&"', '"&Request.Form("txtEmail")&"' "
strSQL = strSQL &",'"&Request.Form("txtCountryCode")&"','"&Request.Form("txtBudget")&"', '"&Request.Form("txtUsed")&"') "
Set objExec = Conn.Execute(strSQL)
Set objExec = Nothing

If Err.Number = 0 Then
'*** Commit Transaction ***'
Conn.CommitTrans
Response.write("Save Done.")
Else
'*** Rollback Transaction ***'
Conn.RollbackTrans
Response.write("Error Save ["&strSQL&"] ("&Err.Description&")")
End If

Conn.Close()
Set objExec = Nothing
Set Conn = Nothing
%>
</body>
</html>

Create a asp file and save to path root-path/myasp/

Run
http://localhost/myasp/asp_oracle_transaction1.asp

Screenshot

.
.
.