Can someone help me with cx_Oracle and Django?! :)
I have Oracle DB 11.2 with many PLSQL-procedures in it that return cursor
with various output. I want to work with them without django ORM and
directly call them.
First of all i ran my python code without django, with the cx_Oracle driver
and everything works well.
conn = cx_Oracle.connect('user', 'pass')
ora_cur = conn.cursor()
l_cur = ora_cur.var(cx_Oracle.CURSOR)
l_query = ora_cur.callproc('user.VIEW.procedure_with_cursor', (None, None,
None, None, l_cur,)) #None - "*in*" parameters and l_cur - *out *
l_query[0].fetchall()
but with the django and same code, i got the error:
import cx_Oracle
from django.db import connection
ora_cur = connection.cursor()
ora_cur.execute("SELECT * from v$version") #it works
l_cur = ora_cur.var(cx_Oracle.CURSOR) #-> *Error:
*Variable_TypeByPythonType():
unhandled data type
l_query = ora_cur.callproc('user.VIEW.procedure_with_cursor', (None, None,
None, None, l_cur,))
l_query[0].fetchall()
Django Version: 1.6.4 Exception Type: NotSupportedError Exception Value:
Variable_TypeByPythonType(): unhandled data type
Python Version: 2.7.3cx_Oracle 5.1.2
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/eb8be6ed-f9c4-4217-ada4-0deebcd3b87c%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
