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 :
Banner Object | 12 :Ready For Testing | 13 :Tested | 14 :Primary User | 15 :Object Type | 16 :
---|---|---|---|---|
{{ obj.name|upper }} | 20 :{% if obj.prod_svn %} 21 : 22 : {% else %} 23 : 24 : {% endif %} | 25 :{% 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 |