Jun 21, 2016 11:44 AM|Mikesdotnetting|LINK
If this was my task, I'd probably copy the text file contents into a DataTable and use the OracleBulkCopy class to insert it just like SqlBulkCopy: https://docs.oracle.com/cd/E11882_01/win.112/e23174/OracleBulkCopyClass.htm#ODPNT7518.
I would also use C# to validate the file contents before trying to insert them. If they fail validation, I wouldn't even bother trying to insert the data into a database. That way I don't have to worry about transactions.