problem about cx-oracle-Collection of common programming errors

• 
  Danny Beckett
  django centos mod-wsgi cx-oracle centos6
  I´m having serious trouble to get Django to work with my Apache/mod_wsgi installation accessing Oracle. I have this setup running on a CentOS 6 host, and I’m getting this error in my Apache logs:Error loading cx_Oracle module: libclntsh.so.10.1: cannot open shared object file: No such file or directoryIf I try to import cx_Oracle from the Python command line it works fine in both root and apache users. I set ORACLE_HOME and LD_LIBRARY_PATH ($ORACLE_HOME/lib) correctly: in ~/.bashrc, /etc/ld.so.c
• 
  ftartaggia
  django apache oracle11g httpd cx-oracle
  This is my application environment:Redhat 6.0 Apache 2.2 Django 1.3.0 Python 2.6.6 cx_Oracle 5.1 mod_wsgi 3.2 Oracle DBMS 11.2 (on a different machine)Issue: accessing my django website from a web browser fails because cx_Oracle can’t acquire Oracle handle.Tests:running django-admin.py shell to query the db DOES WORK (running from a bash session with ORACLE_HOME and LD_LIBRARY_PATH vars set) running a custom script that adds ORACLE_HOME and LD_LIBRARY_PATH to os.environ and uses cx_Oracle to con
• 
  Sean McCully
  python cx-oracle
  My python application is dying, this oracle trace file is being generated. I am using cx_Oracle, how do I go about using this trace file to resolve this crash?ora_18225_139690296567552.trc kpedbg_dmp_stack()+360<-kpeDbgCrash()+192<-kpureq2()+3194<-OCIStmtPrepare2()+157<-Cursor_InternalPrepare()+298<-0000000000EA3010<-0000000000EA3010<-0000000000EA3010<-0000000000EA3010<-0000000000EA3010<-0000000000EA3010<-0000000000EA3010<-0000000000EA3010<-0000000000EA3010
• 
  Dougman
  python oracle pyodbc cx-oracle instantclient
  I can connect to a Oracle 10g release 2 server using instant client. Using pyodbc and cx_Oracle.Using either module, I can execute a select query without any problems, but when I try to update a table, my program crashes.For example,SELECT * FROM table WHERE col1 = ‘value’; works fine.UPDATE table SET col2 = ‘value’ WHERE col1 = ‘val’; does not workIs this a known limitation with instant client, or is there a problem with my installation?Thanks in advance for your help.
• 
  Uniphase38
  python cx-oracle
  I’m trying to call an oracle pl/sql function returning an oracle object by using cx_Oracle’s cursor.callfunc() but cannot bring it to work and found no help neither in the documentation nor on the net. my code:connection = cx_Oracle.connect(‘myuser/mypass@myservice’) cursor = connection.cursor() result = cursor.var(cx_Oracle.OBJECT) cursor.callfunc(‘myfunction’, result , [an_arg]) Traceback (most recent call last):File “…”, line nn, in <module>result = cursor.var(cx_Oracle.OBJECT) TypeEr
• 
  Pat
  python cx-oracle
  First, the SQL that I’m dealing with:CREATE OR REPLACE TYPE address_t AS OBJECT ( street VARCHAR2(80), city VARCHAR2(80), state_abbr CHAR(2), zip_code DECIMAL(5) ) /CREATE TABLE branch ( id DECIMAL(12) NOT NULL, address address_t PRIMARY KEY(id) ) /I’ve verified that the data is correct in the database (after putting in some test data). I’m trying to now write a JSONEncoder for parsing the Oracle address_t type as a serializable JSON type. Here’s the function I’ve been
• 
  Mark
  python osx oracle cx-oracle instantclient
  So I followed these directions here to install Oracle InstantClient,installing Oracle Instantclient on Mac OS/X without setting environment variables?But when I try to install cx_oracle I get the following stack trace,python setup.py build running build running build_ext building ‘cx_Oracle’ extension creating build creating build/temp.macosx-10.6-universal-2.6-10g gcc-4.2 -fno-strict-aliasing -fno-common -dynamic -DNDEBUG -g -fwrapv -Os -Wall -Wstrict-prototypes -DENABLE_DTRACE -arch i386 -arc
• 
  Andrew
  python apache2 mingw lxml cx-oracle
  when I launch my application with apache2+modwsgi I catch Exception Type: ImportError Exception Value: DLL load failed: The specified module could not be found.in linefrom lxml import etreewith Django dev server all works fine Visual C++ Redistributable 2008 installedDependency walker told that msvcrt90.dll is missed but there is same situation with cx_Oracle, but cx_Oracle’s dll loads correctany ideas?windows 2003 server 64bit and windows XP sp3 32bit python 2.7 32 bit cx_Oracle 5.0.4 32bitU
• 
  nashr rafeeg
  python cx-oracle
  I am having issiues installing cx_oracle. I have installed oracle instantclient and cx_oracle oracle packages ones installed i am getting this error while importing cx_oracle. i am running ubuntu 11.10 as host. import cx_Oracle Traceback (most recent call last): File “<console>”, line 1, in <module> ImportError: /usr/lib/python2.7/dist-packages/cx_Oracle.so: undefined symbol:PyUnicodeUCS2_AsEncodedStringany one have any idea how to resolve this issue cheers
• 
  cwallenpoole
  python cx-oracle
  I’m trying to install the cx_Oracle for Python 2.6, but it is failing. I don’t know enough about C or MS Vis. Studio’s compiler to even approach fixing it myself.This is what is output on the command line:C:\pydev\cx_Oracle-5.0.1>C:\python26\python setup.py install running install running build running build_ext building ‘cx_Oracle’ extension C:\Program Files\Microsoft Visual Studio 9.0\VC\BIN\cl.exe /c /nologo /Ox /MD /W3 /GS- /DNDEBUG -IC:\Oracle\instantclient\sdk\include -IC:\p ython26\in
• 
  mnky9800n
  oracle cx-oracle ora-00911
  I am using python 2.7 and the cx_Oracle module. When I try to run the following query:UPDATE bs_cartSET qty = qty + :moreBooksWHERE userid = :userID AND isbn = :bookNumber;IF SQL%ROWCOUNT = 0 THENINSERT INTO bs_cart(userid,isbn)VALUES(:userID,:bookNumber)using Cursor.execute() from cx_Oracle I get the following error:DatabaseError: ORA-00911: invalid characterWhen I put it in SQL plus it says:SP2-0734: unknown command beginning “IF SQL%ROW…” – rest of line ignored.I am trying to make the cart

Web site is in building