Python and Oracle
Date: 1997/12/29
Message-ID: <m2lnx441f8.fsf_at_k2.knowledge2000.com>#1/1
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 :
>>> conn = oracledb.oracledb("jayfoo/jayfoo")
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
>>> ^D
-- jeff putnam - jefu_at_knowledge2000.com - knowledge 2000Received on Mon Dec 29 1997 - 00:00:00 CET