Re: Bind variables in Oracle backend - how to use them?

2010-08-20 Thread Tim Sawyer
Excellent, thanks Ian. It works a treat, post updated. Tim. > On Aug 19, 11:58 am, Tim Sawyer wrote: >> No, I don't think you're mistaken, especially if you want to use hints. >> >> I tried this code again today with the django database connection (using >> 1.2

Re: Bind variables in Oracle backend - how to use them?

2010-08-19 Thread Ian
On Aug 19, 11:58 am, Tim Sawyer wrote: > No, I don't think you're mistaken, especially if you want to use hints. > > I tried this code again today with the django database connection (using > 1.2 final), and it didn't work.  This only works with cx_Oracle connections.

Re: Bind variables in Oracle backend - how to use them?

2010-08-19 Thread buddhasystem
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. >>> >>> >>> >>

Re: Bind variables in Oracle backend - how to use them?

2010-08-19 Thread Tim Sawyer
No, I don't think you're mistaken, especially if you want to use hints. I tried this code again today with the django database connection (using 1.2 final), and it didn't work. This only works with cx_Oracle connections. See

Re: Bind variables in Oracle backend - how to use them?

2010-08-18 Thread buddhasystem
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 o

Re: Bind variables in Oracle backend - how to use them?

2010-08-18 Thread Tim Sawyer
Friends, I'm in need of an implementation which calls for using bind variables (in Oracle sense, not generic) in my SQL in a Django application. Any experience with that, anyone? Here's an example using bind variables to return output values from a PL/SQL block. >>> import cx_Oracle >>>

Re: Bind variables in Oracle backend - how to use them?

2010-08-18 Thread buddhasystem
> For more options, visit this group at > http://groups.google.com/group/django-users?hl=en. > > > -- View this message in context: http://old.nabble.com/Bind-variables-in-Oracle-backend---how-to-use-them--tp29431038p29472095.html Sent from the django-users mailing li

Re: Bind variables in Oracle backend - how to use them?

2010-08-18 Thread buddhasystem
> For more options, visit this group at > http://groups.google.com/group/django-users?hl=en. > > > -- View this message in context: http://old.nabble.com/Bind-variables-in-Oracle-backend---how-to-use-them--tp29431038p29471298.html Sent from the django-users mailing li

Re: Bind variables in Oracle backend - how to use them?

2010-08-17 Thread Ian
On Aug 17, 4:59 pm, buddhasystem wrote: > I guess the problem is that I need to use raw queries to provide "hints" to > Oracle. There has been some chatter recently on the developers list about adding support for optimizer hints, but I don't believe the syntax has settled yet.

Re: Bind variables in Oracle backend - how to use them?

2010-08-17 Thread buddhasystem
sers" 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. > > >

Re: Bind variables in Oracle backend - how to use them?

2010-08-13 Thread Ian
On Aug 13, 11:04 am, buddhasystem wrote: > Friends, > > I'm in need of an implementation which calls for using bind variables (in > Oracle sense, not generic) in my SQL in a Django application. > > Any experience with that, anyone? To use raw SQL with Django, see:

Bind variables in Oracle backend - how to use them?

2010-08-13 Thread buddhasystem
Friends, I'm in need of an implementation which calls for using bind variables (in Oracle sense, not generic) in my SQL in a Django application. Any experience with that, anyone? TIA -- View this message in context: http://old.nabble.com/Bind-variables-in-Oracle-backend---how-to-use-them