cx-oracle Questions
1
Solved
Hy,
I'm new in python and I want import some data from a Oracle Database to python (pandas dataframe) using this simple query
SELECT*
FROM TRANSACTION
WHERE DIA_DAT >=to_date('15.02.28 00:0...
3
Currently i have a virtualenv created with the virtualenvwrapper. In that virtualenv i installed the cx_Oracle extension with pip install cx_Oracle.
I have a python script using several commands ...
Manheim asked 29/1, 2015 at 21:22
1
Solved
I'm doing some database benchmarking in Python using the cx_Oracle module. To benchmark results, I'm running 150 unique queries and timing the execution of each one. I'm running something like this...
3
Solved
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 com...
1
I have following code to execute sql quesry in Oracle db:
try:
conn = cx_Oracle.connect(DB_LOGIN+"/"+DB_PWD+"@"+SID)
cursor = connection.cursor()
cursor.execute(sql)
connection.commit()
curso...
1
Solved
Currently i am writing query in python which export data from oracle dbo to .csv file. I am not sure how to write headers within file.
try:
connection = cx_Oracle.connect('user','pass','tns_name...
Homan asked 12/9, 2015 at 8:40
1
Trying to install cx_Oracle for Python 3.4 on Centos.
I have installed Oracle client 11.2.0.1 (actually has two copies, as one requires encrypted connection while the other doesn't, so I have /usr/...
Eames asked 15/7, 2015 at 16:27
1
I have a model object in django like so...
from django.db import models
class Person(models.Model):
employee_title = models.CharField(max_length=150)
pk_person_id = models.IntegerField(primary_...
1
Solved
2
Solved
I am building a Django website with an Oracle backend, and I observe very slow performance even when doing simple lookups on the primary key. The same code works very fast when the same data are lo...
Solo asked 24/9, 2013 at 10:3
1
Solved
I am trying to export a Pandas DataFrame to an Oracle database. I have come across the Write_Frame function in Pandas which sounds like exactly what I need.
However, I have done tons of searches ...
1
I'm relatively new to Python.
I'm currently working on SQL statement execution in Oracle DB.
When I execute query:
query = 'select * from table'
cursor.execute(query)
result = cursor.fetchall()
...
2
In order to demonstrate the security feature of Oracle one has to call OCIServerVersion() or OCIServerRelease() when the user session has not yet been established.
While having the database parame...
2
Solved
I'm trying to use cx_Oracle module in python to access a remote database and insert or delete rows in tables. BTW I have downloaded oracle instant client 11.1 and also odbc and sqlplus versions. I ...
3
Solved
I have the following: (using ipython)
In [30]: con = cx_Oracle.connect('refill_test02/******@MYDB')
In [31]: cur = con.cursor()
In [32]: cur.execute("ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM...
1
Solved
I need to substitute the following values into select query. but i got the error as i mentioned below
self.jobNo = J-12060
qcActivity = C173
self.wrkArea = 1666339
cursor.execute("""SELECT A.MAR...
Arsenate asked 6/5, 2013 at 5:10
1
Solved
I am having an issue inserting unicode into an Oracle schema, I think the database is an Oracle 11g instance but am not certain at this point. I'm using python 2.6.1 on OS X 10.6.8 (this is the sys...
1
I have var='smth' and I need to check if var exists in the table 'smtb'
I tried something this, but it does not work:
rows=curs.fetchall()
for row in rows:
if var==row:
print("Yes")
When I pr...
Flow asked 6/3, 2013 at 2:31
1
Solved
Im using python 2.7 and cx_oracle ( Windows x86 Installer (Oracle 10g, Python 2.7) ) and 'm having a bad time to set this simple example bellow to work:
import cx_Oracle
connection = cx_Orac...
Eyra asked 4/12, 2012 at 17:57
3
Solved
I want to execute a query that selects data from a different schema than the one specified in the DB connection (same Oracle server, same database, different schema)
I have an python app talking t...
1
Solved
I'm using cx_Oracle to access our database. I would like the user to be able to input the station ID, for example:
stationID=(whatever the user inputs upon prompting)
cursor.execute('''select cru...
Dyeing asked 30/11, 2012 at 18:1
1
Solved
I'm developing part of a system where processes are limited to about 350MB of RAM; we use cx_Oracle to download files from an external system for processing.
The external system stores files as BL...
Whaler asked 1/10, 2012 at 14:2
2
Solved
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 1...
2
Solved
I've Googled a bit but I haven't found any substantial results. Is it possible to use key-based authentication to connect to an Oracle server using Python? My objective is to be able to automate so...
Terrie asked 7/5, 2012 at 15:53
9
Solved
I'm coding a webservice on python that uses an Oracle database. I have cx_Oracle installed and working but I'm having some problems when I run my python code as CGI using Apache.
For example the f...
© 2022 - 2024 — McMap. All rights reserved.