Re: direct query to Oracle db view doesn't work

2011-10-19 Thread msbuck
I'm not sure how to check this. There are many other tables and views in the database which I have no trouble retrieving data from. I can use SQL Developer to execute the query on the view using the same username, password, and database name. When I used cx_Oracle directly, I am creating the connec

Re: direct query to Oracle db view doesn't work

2011-10-19 Thread dmitry b
I'm starting to doubt this is a Django issue. Double check that you are connecting to the database/schema you *think* you are connecting to and you are using the use account you *think* you are using :) D. On Oct 19, 11:46 am, msbuck wrote: > I just tried it and it doesn't. If I try an aggregat

Re: direct query to Oracle db view doesn't work

2011-10-19 Thread msbuck
I just tried it and it doesn't. If I try an aggregate query such as using COUNT(account_number) without the Where clause, I get a row with 0 in it (there are thousands of account_numbers). Thanks for the suggestion. On Oct 19, 1:30 pm, dmitry b wrote: > see if a pamaterized query works: > >  c

Re: direct query to Oracle db view doesn't work

2011-10-19 Thread dmitry b
see if a pamaterized query works: cursor.execute('SELECT account_number FROM vw_billed_summary_fact WHERE ippa=%s', ['col11-emnj00-1147']) d. On Oct 19, 8:25 am, msbuck wrote: > I'm having another strange problem. I'm executing SQL statements > directly rather than using the ORM and it is wor