On Apr 23, 2:44 pm, Ian <ian.g.ke...@gmail.com> wrote:
> Django cursors universally use the 'format' dbapi paramstyle rather
> than the 'named' style natively used by cx_Oracle [1].  To convert
> your query, replace the parameter markers with %s and pass the
> parameters as a list rather than a dictionary.
>
> If you instead want to work with the underlying cx_Oracle cursor
> directly, you can access that as cursor.cursor.  However, this is not
> documented API, so don't expect it to be stable.  I'm also not sure
> whether it works at all with the sqlite3 backend.

One other note:  if you just need to call a SP in the database, then
you can use cursor.callproc or cursor.callfunc and skirt this entire
issue.

HTH,
Ian

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To post to this group, send email to django-us...@googlegroups.com.
To unsubscribe from this group, send email to 
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/django-users?hl=en.

Reply via email to