Re: [cx-oracle-users] ORA-01461 when inserting into VARCHAR2 column

[Rodney B. <ba...@pl...>]

In case the lack of response is due to the absence of any sample code,
here's a patch that adds a couple of tests to illustrate the problem.  The
test in StringVar.py succeeds while the equivalent test in uStringVar.py
fails.

Rodney

 diff -Naur cx_Oracle-5.1/test/SetupTest.sql
cx_Oracle-5.1test/test/SetupTest.sql
--- cx_Oracle-5.1/test/SetupTest.sql    2011-03-19 18:05:30.000000000 -0500
+++ cx_Oracle-5.1test/test/SetupTest.sql        2011-05-31
11:35:50.458172563 -0500
@@ -102,7 +102,7 @@

 create table cx_Oracle.TestExecuteMany (
   IntCol                number(9) not null,
-  StringCol             varchar2(100)
+  StringCol             varchar2(4000)
 ) tablespace users;

 create table cx_Oracle.TestObjects (
diff -Naur cx_Oracle-5.1/test/StringVar.py
cx_Oracle-5.1test/test/StringVar.py
--- cx_Oracle-5.1/test/StringVar.py     2011-03-19 18:05:30.000000000 -0500
+++ cx_Oracle-5.1test/test/StringVar.py 2011-05-31 12:07:49.142192794 -0500
@@ -248,6 +248,17 @@
         inString = "X" * badStringSize
         self.failUnlessRaises(ValueError, var.setvalue, 0, inString)

+    def testInsert2001(self):
+        """test inserting 2001 characters into varchar2 column"""
+        self.cursor.execute("truncate table TestExecuteMany")
+        inString = "x" * 2001
+        sql = "insert into TestExecuteMany (IntCol, StringCol) " \
+              "values (:1, :2)"
+        self.cursor.execute(sql, [1, inString])
+        self.cursor.execute("select count(*) from TestExecuteMany")
+        count, = self.cursor.fetchone()
+        self.failUnlessEqual(count, 1)
+
     def testCursorDescription(self):
         "test cursor description is accurate"
         self.cursor.execute("select * from TestStrings")
diff -Naur cx_Oracle-5.1/test/uStringVar.py
cx_Oracle-5.1test/test/uStringVar.py
--- cx_Oracle-5.1/test/uStringVar.py    2011-03-19 18:05:29.000000000 -0500
+++ cx_Oracle-5.1test/test/uStringVar.py        2011-05-31
12:08:28.850211512 -0500
@@ -228,6 +228,17 @@
         inString = u"X" * badStringSize
         self.failUnlessRaises(ValueError, var.setvalue, 0, inString)

+    def testInsert2001(self):
+        """test inserting 2001 characters into varchar2 column"""
+        self.cursor.execute("truncate table TestExecuteMany")
+        inString = u"x" * 2001
+        sql = "insert into TestExecuteMany (IntCol, StringCol) " \
+              "values (:1, :2)"
+        self.cursor.execute(sql, [1, inString])
+        self.cursor.execute("select count(*) from TestExecuteMany")
+        count, = self.cursor.fetchone()
+        self.failUnlessEqual(count, 1)
+
     def testCursorDescription(self):
         "test cursor description is accurate"
         self.cursor.execute(u"select * from TestStrings")