DevOps, CI/CD and Automation

I've developed a web app using classic asp with Oracle XE as the database. I'm using ODBC to connect with the Oracle in XE driver. I can retrieve data and make simple inserts and updates. However, when I insert several rows at a time, some rows are not getting inserted. I receive no error messages as to why the statements fail. I get the feeling that perhaps it's too much for my configuration to handle (I don't have much hardware at my disposal, so I'm attempting to host the application and database on the same server running Windows XP Service Pack 1).

The logic to how my web app is attempting to perform the inserts is as follows:

Set oConn = Server.CreateObject("ADODB.Connection")
oConn.Open sConn

Set dbConn = oConn

sql = 'create sql statement to delete existing rows

dbConn.Execute sql

'for each row that needs to be inserted

sql = 'create sql statement to insert single row
dbConn.Execute sql

'Next row

'close the connection
dbConn.Close
Set dbConn = Nothing

Has anyone experienced a similar problem? Would there be a more efficient way to insert the rows? Any help would be appreciated. I've tried reworking my code several different ways, but in the end the same thing happens: the rows inexplicably don't end up in the database table.

Thanks!