Skip to content

Instantly share code, notes, and snippets.

@jogibear9988
Created October 9, 2013 09:59
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jogibear9988/6898962 to your computer and use it in GitHub Desktop.
Save jogibear9988/6898962 to your computer and use it in GitHub Desktop.
Source/Data/DataProvider/OdpDataProvider.cs | 4 +++-
1 file changed, 3 insertions(+), 1 deletion(-)
diff --git a/Source/Data/DataProvider/OdpDataProvider.cs b/Source/Data/DataProvider/OdpDataProvider.cs
index c7234ca..6274527 100644
--- a/Source/Data/DataProvider/OdpDataProvider.cs
+++ b/Source/Data/DataProvider/OdpDataProvider.cs
@@ -1629,6 +1629,7 @@ namespace BLToolkit.Data.DataProvider
var sp = new OracleSqlProvider();
var n = 0;
var cnt = 0;
+ var parCnt = 0;
var str = "\t" + insertText
.Substring(0, insertText.IndexOf(") VALUES ("))
.Substring(7)
@@ -1665,7 +1666,7 @@ namespace BLToolkit.Data.DataProvider
}
else if (value is string && ((string) value).Length >= 2000)
{
- var par = db.Parameter("Par" + cnt, value);
+ var par = db.Parameter("Par" + parCnt++, value);
parameters.Add(par);
sb.Append(":" + par.ParameterName);
}
@@ -1691,6 +1692,7 @@ namespace BLToolkit.Data.DataProvider
cnt += db.SetCommand(sql, parameters.ToArray()).ExecuteNonQuery();
parameters = new List<IDbDataParameter>();
+ parCnt = 0;
n = 0;
sb.Length = 0;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment