When i try the same code from python Shell then it is working fine.
Here is the working output:
>>> import cx_Oracle
>>> from pprint import pprint
>>> connection = cx_Oracle.Connection("%s/%s@%s" % ('foo', 'bar', 'db'))
>>> cursor = cx_Oracle.Cursor(connection)
>>> sql = "SELECT xyz FROM table_name where rownum < 10"
>>> cursor.execute(sql)
[<cx_Oracle.STRING object at 0x33c00>]
>>> data = cursor.fetchall()
>>> pprint(data)
[('Robert Craig',),
('Darren Kerr',),
('Aviva Garrett',),
('Pasvorn Boonmark',),
('Dave Wittbrodt',),
('Pasvorn Boonmark',),
('Rajkumaran Chandrasekaran',),
('Pasvorn Boonmark',),
('Pasvorn Boonmark',)]
But when i use the same code in django views.py then it does not work
and Getting error as:
Exception Value:
Error while trying to retrieve text for error ORA-01804
def cases(request, db_name, prnum=None, message=''):
connection = cx_Oracle.Connection("%s/%s@%s" % ('foo', 'bar', 'db'))
cursor = cx_Oracle.Cursor(connection)
sql = "SELECT xyz FROM table_name where rownum < 10"
cursor.execute(sql)
data = cursor.fetchall()
pprint(data)
cursor.close()
connection.close()
return render_to_response('web/cases.html', {}, RequestContext(request,
{
'first': 'test1',
'last': 'test2',
}))
Thanks,
On Fri, Apr 22, 2011 at 1:01 AM, Ian <[email protected]> wrote:
> On Apr 21, 11:03 am, kamal sharma <[email protected]> wrote:
> > Error while trying to retrieve text for error ORA-01804
> >
> > Here is my code to fetch the data from database.
> >
> > def cases(request, dbname, prnum=None, message=''):
> >
> > connection = cx_Oracle.Connection("%s/%s@%s" % ('foo', 'bar',
> 'xyz'))
> > cursor = cx_Oracle.Cursor(connection)
> > sql = "SELECT fielname FROM tablename where rownum < 10"
> > cursor.execute(sql)
> > names = [row[0] for row in cursor.fetchall()]
> > cursor.close()
> > connection.close()
>
> First of all, why are you creating your own connection instead of
> using the Django ORM?
>
> Anyway, the proper way to create a cx_Oracle connection is with the
> cx_Oracle.connect factory function, and the proper way to create a
> cursor is with the connection.cursor() method. See the cx_Oracle docs
> and the DB-API docs for details. However, I think there is something
> more going on here.
>
> ORA-01804: failure to initialize timezone information
> Cause: The timezone information file was not properly read.
> Action: Please contact Oracle Customer Support.
>
> This and the fact that cx_Oracle wasn't able to look up the error code
> itself suggest that there may be something wrong with your Oracle
> client installation. Or it may be that your webserver is also
> blocking access to the files in the client directory. What happens if
> you try the same code from a Python shell?
>
> --
> You received this message because you are subscribed to the Google Groups
> "Django users" group.
> To post to this group, send email to [email protected].
> To unsubscribe from this group, send email to
> [email protected].
> For more options, visit this group at
> http://groups.google.com/group/django-users?hl=en.
>
>
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en.
