id summary reporter owner description type status component version severity resolution keywords cc stage has_patch needs_docs needs_tests needs_better_patch easy ui_ux 11580 Unable to query TextField against oracle nclob 10Gr4 Mark Anderson "I have tried __icontains and __regex against a TextField on an oracle database and get the following error: DatabaseError: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at line 1 The code was ported directly over from mysql where the i_contains query worked. The column was created as an NCLOB. I can query against other fields fine. Environment: {{{ Request Method: GET Request URL: http://django/eis/banobj/search/?q=class Django Version: 1.1 rc 1 SVN-11348 Python Version: 2.4.3 Installed Applications: ['django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.sites', 'eis.banobj', 'django.contrib.admin', 'django.contrib.admindocs', 'eis.ldapauth', 'eis.emailLogs'] Installed Middleware: ('django.middleware.common.CommonMiddleware', 'django.contrib.sessions.middleware.SessionMiddleware', 'django.contrib.auth.middleware.AuthenticationMiddleware') Template error: In template /opt/django/eis/templates/banobj/arealist.html, error at line 17 Caught an exception while rendering: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at line 1 7 : {% block content %} 8 :

{{heading}}

9 : 10 : 11 : 12 : 13 : 14 : 15 : 16 : 17 : {% for obj in obj_list %} 18 : 19 : 20 : 25 :
Banner ObjectReady For TestingTestedPrimary UserObject Type
{{ obj.name|upper }}{% if obj.prod_svn %} 21 : 22 : {% else %} 23 : 24 : {% endif %}{% if obj.user_tested %} 26 : 27 : {% else %} Traceback: File ""/usr/lib/python2.4/site-packages/django/core/handlers/base.py"" in get_response 92. response = callback(request, *callback_args, **callback_kwargs) File ""/usr/lib/python2.4/site-packages/django/contrib/auth/decorators.py"" in __call__ 78. return self.view_func(request, *args, **kwargs) File ""/opt/django/eis/banobj/views.py"" in search 172. context_instance=RequestContext(request)) File ""/usr/lib/python2.4/site-packages/django/shortcuts/__init__.py"" in render_to_response 20. return HttpResponse(loader.render_to_string(*args, **kwargs), **httpresponse_kwargs) File ""/usr/lib/python2.4/site-packages/django/template/loader.py"" in render_to_string 108. return t.render(context_instance) File ""/usr/lib/python2.4/site-packages/django/template/__init__.py"" in render 178. return self.nodelist.render(context) File ""/usr/lib/python2.4/site-packages/django/template/__init__.py"" in render 779. bits.append(self.render_node(node, context)) File ""/usr/lib/python2.4/site-packages/django/template/debug.py"" in render_node 71. result = node.render(context) File ""/usr/lib/python2.4/site-packages/django/template/loader_tags.py"" in render 97. return compiled_parent.render(context) File ""/usr/lib/python2.4/site-packages/django/template/__init__.py"" in render 178. return self.nodelist.render(context) File ""/usr/lib/python2.4/site-packages/django/template/__init__.py"" in render 779. bits.append(self.render_node(node, context)) File ""/usr/lib/python2.4/site-packages/django/template/debug.py"" in render_node 71. result = node.render(context) File ""/usr/lib/python2.4/site-packages/django/template/loader_tags.py"" in render 24. result = self.nodelist.render(context) File ""/usr/lib/python2.4/site-packages/django/template/__init__.py"" in render 779. bits.append(self.render_node(node, context)) File ""/usr/lib/python2.4/site-packages/django/template/debug.py"" in render_node 81. raise wrapped Exception Type: TemplateSyntaxError at /banobj/search/ Exception Value: Caught an exception while rendering: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at line 1 Original Traceback (most recent call last): File ""/usr/lib/python2.4/site-packages/django/template/debug.py"", line 71, in render_node result = node.render(context) File ""/usr/lib/python2.4/site-packages/django/template/defaulttags.py"", line 126, in render len_values = len(values) File ""/usr/lib/python2.4/site-packages/django/db/models/query.py"", line 81, in __len__ self._result_cache = list(self.iterator()) File ""/usr/lib/python2.4/site-packages/django/db/models/query.py"", line 238, in iterator for row in self.query.results_iter(): File ""/usr/lib/python2.4/site-packages/django/db/models/sql/query.py"", line 287, in results_iter for rows in self.execute_sql(MULTI): File ""/usr/lib/python2.4/site-packages/django/db/models/sql/query.py"", line 2383, in result = iter((lambda: cursor.fetchmany(GET_ITERATOR_CHUNK_SIZE)), File ""/usr/lib/python2.4/site-packages/django/db/backends/oracle/base.py"", line 469, in fetchmany return tuple([self._rowfactory(r) DatabaseError: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at line }}}" Bug new Database layer (models, ORM) dev Normal oracle TextField Matt Boersma carsten.fuchs@… Accepted 0 0 0 0 0 0