Re: [DB-SIG] Query on using cx_Oracle

om: c...@ghum.de [mailto:c...@ghum.de] On Behalf Of Harald Armin > Massa[legacy] > Sent: 29 May 2012 11:57 > To: Rupinder Mudher > Cc: db-sig@python.org > Subject: Re: [DB-SIG] Query on using cx_Oracle > > Hello Rupinder, > >> Traceback (most recent call last): >

Re: [DB-SIG] Query on using cx_Oracle

Hello Rupinder, > Traceback (most recent call last): >   File "C:\workspace\databaseproject\src\datbaasemodule.py", line 13, in > >     import cx_Oracle > ImportError: DLL load failed: The specified procedure could not be found. most likely: the Oracle-OCI-Librarys are not in your path. Make sur

Re: [DB-SIG] Example python x oracle

info/db-sig > > -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 no fx, no carrier pidgeon - EuroPython 2008 will take place in Vilnius, Lithuania - Stay tuned! ___ DB-SIG mail

Re: [DB-SIG] how do I execute a query likte 'select * from mytable where id in (1, 2, 3)'?

-- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 fx 01212-5-13695179 - EuroPython 2008 will take place in Vilnius, Lithuania - Stay tuned! ___ DB-SIG maillist - DB-SIG@python.org http://mail.python.org/mailman/listinfo/db-sig

Re: [DB-SIG] Reading DB2 on AIX in Python scripts

number > 3390839 > > Registered offices: Miller Street, Manchester M60 0AL > Internet http://www.cis.co.uk > > > CIS & the CIS logo (R) Co-operative Insurance Society Limited > > > ********* > ___ > DB-SIG maillist - DB-SIG@python.org > http://mail.python.org/ma

[DB-SIG] cx_Oracle: Out-Var with type Record

NUMERIC,[n]) n.getvalue() but now the return of whateverrecord is RECORD ... what can I do? Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Reinsburgstraße 202b 70197 Stuttgart 0173/9409607 fx 01212-5-13695179 - Python: the only language with more web frameworks tha

Re: [DB-SIG] cx_Oracle: getting names of present TNS entries

ad in mind --- TOAD displays the Oraclehomes, and partially also the TNS-names. I was really hoping there is a way to detect that; building a setup helper for an application. So, thanks for sparing me the futil search ! Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Reinsburgs

[DB-SIG] cx_Oracle: getting names of present TNS entries

Hello, is there a fine method to query the defined TNS-names on a computer? with "fine" I am asking for something higherlevel then "find tnsnames.ora, parse it" Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Reinsburgstraße 202b 70197 Stuttgart 0

Re: [DB-SIG] comparing with lists via cx_Oracle

> BTW, sequences in DB-talk are objects which you can use as > auto-increment integer source, e.g. for creating ids of > new rows. Yes. Maybe that makes it hard to google up a solution for my challenge :) Thanks for your great hints, best wishes, Harald (cu @ EP2007 ? ) -- GHUM Harald

Re: [DB-SIG] comparing with lists via cx_Oracle

ve to deal with all the escaping challenges - that's the entrence door of most PHP vulnerabilities. Parameters should be escaped via the database adapter. So I am looking for the way to pass sequence parameters into Oracles throat :) Best wishes, Harald -- GHUM Harald Massa per

[DB-SIG] comparing with lists via cx_Oracle

... how can I get that list of ID_S from Python to Oracle via cx_Oracle? Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Reinsburgstraße 202b 70197 Stuttgart 0173/9409607 - Python: the only language with more web frameworks than keywords.

[DB-SIG] cx_Oracle: RuntimeError: Unable to acquire Oracle environment handle

give me a push to check something in addition? Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Reinsburgstraße 202b 70197 Stuttgart 0173/9409607 - Python: the only language with more web frameworks than keywords. ___ DB-SIG

Re: [DB-SIG] cx_Oracle - any way to change the user of a connection?

Andy,thanks for takeing the time to explain it fully. Especially your explanation of that Oracle way of the world is very helpfull. Technically no. The definition of a connection to an Oracle database isthe user you connect as and the database you connect to. Change one orthe other and you have a d

Re: [DB-SIG] Proposed improvements to DBAPI 2.0 Cursor.execute() method.

I skimmed them, and in my eyes these changes involve a bit too much magic to be helpfull in the full range of database accesses."Since columns is a sequence, and sequences in SQL are always joined by ,, "That is clearly wrong. With the SQL engine I use (PostgreSQL); there is the data type of "ARRAY

[DB-SIG] cx_Oracle - any way to change the user of a connection?

I want to have a connections which stays activated:cn=cx_Oracle.connect("dataset", "lowprivuser", "password")and change the user of that connection.Reason: I want to have a web application, which connects ONE TIME (per process/thread) to Oracle, and switches the privileges on the fly. I looked into