Python and Oracle

From: Jefu! <jefu_at_k2.knowledge2000.com>
Date: 1997/12/29
Message-ID: <m2lnx441f8.fsf_at_k2.knowledge2000.com>#1/1


I'm still struggling with trying to get Python and Oracle 8 to work together and now have another problem (or three). I'm wondering if some of the secondary problems are just another manifestation of this one.

When I do the initial connect, it always fails. The second try always works. After that most things seem to work normally - but some things don't work at all - or erratically (for example a command string with '123456' fails. If the string is replaced by '1234567' it works).

I've tried this with both the "oramod" and the "oracledb" packages. And with both Python 1.5 and 1.4.

here is what the "oramod" stuff says:

Python 1.5b2 (#5, Dec 29 1997, 07:23:12) [GCC 2.7.2.1] on sunos5 Copyright 1991-1995 Stichting Mathematisch Centrum, Amsterdam
>>> import oracle
>>> c = oracle.logon('jayfoo/jayfoo')

Traceback (innermost last):
  File "<stdin>", line 1, in ?
oracle.error: oracle logon failed
>>> c = oracle.logon('jayfoo/jayfoo')
>>> ^D

And here is what the "oracledb" says :
Python 1.5b2 (#5, Dec 29 1997, 07:23:12) [GCC 2.7.2.1] on sunos5 Copyright 1991-1995 Stichting Mathematisch Centrum, Amsterdam
>>> import oracledb
>>> conn = oracledb.oracledb("jayfoo/jayfoo")
Traceback (innermost last):
  File "<stdin>", line 1, in ?
OracleDbError: LOGON caused a ORA-01019: unable to allocate memory in the user side

>>> conn = oracledb.oracledb("jayfoo/jayfoo")
>>> ^D

-- 
jeff putnam - jefu_at_knowledge2000.com - knowledge 2000
Received on Mon Dec 29 1997 - 00:00:00 CET

Original text of this message