Original Message
>What is the easiest way to connect to an Oracle Database >using python in
>order to run queries?
You should check module cx_Oracle
--
https://mail.python.org/mailman/listinfo/python-list
On Wed, Mar 8, 2017 at 6:21 AM, Robert James Liguori
wrote:
> What is the easiest way to connect to an Oracle Database using python in
> order to run queries?
There's a Python package called cx_oracle that provides a standardized
interface. You can run queries using t
What is the easiest way to connect to an Oracle Database using python in order
to run queries?
--
https://mail.python.org/mailman/listinfo/python-list
No One don't no ? how to insert data from one table to another table using
oracle?
--
https://mail.python.org/mailman/listinfo/python-list
On Tuesday, February 28, 2017 at 6:30:54 PM UTC+5:30, Murthy Jn wrote:
> I have the table structure in one db is number,photo,date,name.
> the same structure is there in other database in other machine.
>
> I want to insert table1 data from db1 into table2 in db2 using python script.
>
> Some one
I have the table structure in one db is number,photo,date,name.
the same structure is there in other database in other machine.
I want to insert table1 data from db1 into table2 in db2 using python script.
Some one could please help me in this.. I have tried like below.
for fetching rows
db conn
I have created Python with Oracle Database Course, and offer 50% discount till
10-5-2016.
Any one interested in course just click on below link.
https://www.udemy.com/using-python-with-oracle-db/?
Then write coupon Code=PYTHON_ORACLE_50%25
--
https://mail.python.org/mailman/listinfo/python
I'm installing an app that requires Carbon and some other Python 2.7 features.
The version of Oracle Linux we're using comes with 2.6.
I've read that it is not a good idea to directly update the O/S as it "may
break things" so I'm doing make altinstall.
I've
On Wed, Sep 30, 2015 at 11:25 AM, wrote:
> Hi
> New to Python and just downloaded 3.5
> Trying to connect to Oracle but failing - eg
>
> import cx_oracle
> connstr = 'userid/password@@99.999.9.99:PORT/SID'
> connection = cx_oracle.connect(connstr)
> cursor = co
Hi
New to Python and just downloaded 3.5
Trying to connect to Oracle but failing - eg
import cx_oracle
connstr = 'userid/password@@99.999.9.99:PORT/SID'
connection = cx_oracle.connect(connstr)
cursor = connection.cursor()
cursor.execu
"Gary Furash" wrote in message
news:135759bf-0823-480c-9631-106d6cf1a...@googlegroups.com...
I need to be able to access Oracle from both Windows and *nix, however, it
seems kind of tortuous getting everything working each time on each server.
With Java I can just drop (usuall
I need to be able to access Oracle from both Windows and *nix, however, it
seems kind of tortuous getting everything working each time on each server.
With Java I can just drop (usually the same) JDBC library files in a location
and everything works. I'm sure there's some easier wa
Oracle
In Classical Antiquity, an oracle was a person or agency considered to be a
source of wise counsel or prophetic predictions or precognition of the future,
inspired by the gods. As such it is a form of divination.
The word oracle comes from the Latin verb ōrāre "to speak" an
VAM SYSTEMS is a Business Consulting, IT Solutions and Services
company with operations in UAE, Qatar, Bahrain, USA, Australia,
Singapore & India.
VAM SYSTEMS is currently looking for Oracle E-Business Suite Techno
Functional Consultant for our UAE operations with the following skill
set and t
Hi,
Hope you are doing good,,
Skill SetCurrent-location
RelocationAvailability
oracal DBAtennessee
yes immediately
As per your requirement for Oracle DBA position, I’m forwarding you
one of my
2011/12/9 André Lopes :
> Hi all,
>
>
>
> I wrote a simple Java program to be called within an Oracle database. The
> goal is to execute a Python program within the DB itself, by the means of a
> Java program. The problem is that when I execute the procedure inside the
Hi all,
I wrote a simple Java program to be called within an Oracle database.
The goal is to execute a Python program within the DB itself, by the means
of a Java program. The problem is that when I execute the procedure inside
the DB, nothing happens…
If I create the same Java class
Hello,
On Thu, Feb 17, 2011 at 02:40:22AM -0800, pstatham
wrote:
> I've installed the cx_Oracle module for Python
> and I'm trying to connect to my remote Oracle
> db.
Can you tnsping your remote Oracle DB
successfully?
> >>> uid = "scott"
> >&
t;> From: Anurag Chourasia [mailto:anurag.choura...@gmail.com]
>> Sent: 17 February 2011 14:41
>> To: Paul Statham
>> Cc: python-list@python.org
>> Subject: Re: Connecting to remote Oracle db via Python
>>
>> Could you try by using a connecting string in t
u, Feb 17, 2011 at 8:18 PM, Paul Statham wrote:
> Doesn't seem to work
>
> -Original Message-
> From: Anurag Chourasia [mailto:anurag.choura...@gmail.com]
> Sent: 17 February 2011 14:41
> To: Paul Statham
> Cc: python-list@python.org
> Subject: Re: Connecting to r
b 17, 2011 at 4:10 PM, pstatham wrote:
> Hi Guys,
>
> I've installed the cx_Oracle module for Python and I'm trying to
> connect to my remote Oracle db. Like so (username, password and ip
> below aren't real don't worry)
>
>>>> uid = "scott
Hi Guys,
I've installed the cx_Oracle module for Python and I'm trying to
connect to my remote Oracle db. Like so (username, password and ip
below aren't real don't worry)
>>> uid = "scott"
>>> pwd = "tiger"
>>> service
On Tue, Jan 4, 2011 at 12:57 PM, Mauricio Martinez Garcia
wrote:
>
> Hi, i need help with the next error:
>
> "ERR_PYTHON:Oracle-Error-Message: ORA-01036: illegal variable name/number",
> i used the cx_Oracle module, and the error not is only Oracle Error.
>
> The
Hi, i need help with the next error:
"ERR_PYTHON:Oracle-Error-Message: ORA-01036: illegal variable
name/number", i used the cx_Oracle module, and the error not is only
Oracle Error.
The error its for that python don't translate the query, with the
variables ":VARIABLE&q
I want to do a select from...for update in python, update the selected
row and then commit;
However cannot seem to get it to work...the update statement seems to
be waiting because the row is locked. Presumably oracle thinks the
update is another transaction.
How can I get this to work? What
VAM SYSTEMS is a Business Consulting, IT Solutions and Services
company with operations in UAE, Qatar, Bahrain, USA, Australia,
Singapore & India.
VAM SYSTEMS is currently looking for Oracle DBA for our Qatar
operations with the following skill set and terms and conditions:
Skill Set requ
LL to your PATH variable.
No, isn't that only if I have an actual Oracle client installed (not
the instant client)?
Whether you use the instant client or an actual Oracle client is not
the issue. You may or may not need LD_LIBRARY_PATH either way.
When you import cx_Oracle on Linux, it lo
On Aug 12, 12:30 pm, Alexander Gattin wrote:
> Does Windows have anything like
> LD_LIBRARY_PATH/SHLIB_PATH?
No, isn't that only if I have an actual Oracle client installed (not
the instant client)?
But great tip, wasn't exactly the solution, but your question
triggered me to c
ython -d (--debug IIRC)
and then loading cx_Oracle manually
(>>> import cx_Oracle).
Usually it succeeds (sic!) but outputs a lot
of symbol errors. // Problem with Oracle libs
--
With best regards,
xrgtn (+380501102966/+380636177128/xr...@jabber.kiev.ua)
--
http://mail.python.org/mailman/listinfo/python-list
thout errors. I can install without errors. I fail to
import.
I'm using an NT box (os:Win7)
Downloaded Oracle Instant Client 10.2.0.4
instantclient-basic-win32-10.2.0.4.zip --> extracted to C:\TEMP
\ORAIC10\bin
instantclient-sdk-win32-10.2.0.4.zip --> extracted to C:\TEMP
\ORAIC10\sdk
Do
; crash strangely. We'd get crashes in applications. All applications.
> Crashes in the kernel.
>
> Stallman took over his EMACS
> Oracle's Larry Ellison, took over his SUN-JAVA
> Steve Jobs has Apple
>
> A free competitor to Oracle must be there to limit this fie
; crash strangely. We'd get crashes in applications. All applications.
> Crashes in the kernel.
>
> Stallman took over his EMACS
> Oracle's Larry Ellison, took over his SUN-JAVA
> Steve Jobs has Apple
>
> A free competitor to Oracle must be there to limit this fie
plications.
Crashes in the kernel.
Stallman took over his EMACS
Oracle's Larry Ellison, took over his SUN-JAVA
Steve Jobs has Apple
A free competitor to Oracle must be there to limit this fiend from
taking over the world.
There was VICIOUS propaganda against Microsoft's, Bill Gates.
1981
CONVICTED RAPIST, ROMAN POLANSKY is RELEASED by a KANGAROO court in
Switzerland
We all know that Germans are paying a big tribute to the polanskys and
the swiss paid for the gold in the teeth.
Israeli Professor:
'We Could Destroy All European Capitals'
By Nadim Ladki
2-6-3
(IAP News) -- A
allman hated unix, if not more thanMicrosoft, and
> > thehatredof unix was a major reason he started GNU's Not Unix, by
>
> ORACLE by Larry Ellison is a more dangerous monopoly with boundless
> GREED
>
> Bill Gates is a decent family man and a genuine PHILANTHROPIST
&g
Dear Partners
I have Raja Rao, Oracle Apps Technical consultant available
immediately for your client requirements. Has worked for Tekelec,
Hitachi Data Systems etc. He is in NC right now and is willing to
relocate. Pl. let me know if you have any direct client positions for
him.
Location: NC
Gabor Urban wrote:
Hi guys,
2. We have tp write a module that will be imported a couple of places.
Though we must be sure, this module's initialization is performed only
once. How can we implement this? I do not know what to google for.
There are two ways to have one file executed twice
On Mon, Dec 7, 2009 at 6:57 AM, Gabor Urban wrote:
> 1. I have choice to introduce Python to my new employee. We are to
> write and application that uses databases stored partially in Oracle
> 10 and partially in Oracle 11. We have to execute standard SQL
> commands and stored proced
Hi guys,
I have two questions.
1. I have choice to introduce Python to my new employee. We are to
write and application that uses databases stored partially in Oracle
10 and partially in Oracle 11. We have to execute standard SQL
commands and stored procedures as well. Which is best conection
Hi,
I am trying to use cx_Oracle and SQLAlchemy with Oracle 11gR1 (11.1)
on Windows Vista 64 bit.
When I import cx_Oracle, I get this error:
>>> import cx_Oracle
Traceback (most recent call last):
File "", line 1, in
ImportError: DLL load failed: %1 is not a valid Win32 a
Dear colleges,
I read BLOBs from oracle database and write these in a loop to a the file
system.
Some documents (e.g.PDF) are not correct and I can't open these.
Database size of these blobs is different to size on the file system.
Which code I should use for readig blob from oracle dat
which website have you tested it on ?
My tests were basically on https://www.orange.sk and http://www.orange.sk
(the first fails, and not the second one, which led me to think
there's a bug in python's SSL implementation for this particular web
server) (Oracle) with python 2.5
On Fe
ac OS X, Python 2.5 yielded no problems.
On Jan 19, 3:48 pm, ak wrote:
> On Jan 19, 10:00 pm, ak wrote:
>
>
>
> > Hi everyone,
>
> > I have a problem with urllib2 on this particular url, hosted on an
> > Oracle HTTP Server
>
> >http://www.orange.sk/eshop/
Hello
On my Debian server I'm using cx Oracle 5.1 (installation from a
package made from rpm by alien) with Python 2.5.2
and Oracle Instant Client 10.2.0.4.0. Installation went well but
simple test such as connecting to the db shows that only user root can
make a connection to a database, bu
On Jan 20, 1:14 am, Steven D'Aprano
wrote:
> On Mon, 19 Jan 2009 13:00:44 -0800, ak wrote:
> > Hi everyone,
>
> > I have a problem with urllib2 on this particular url, hosted on an
> > Oracle HTTP Server
>
> >http://www.orange.sk/eshop/sk/portal/catalog.
On Mon, 19 Jan 2009 13:00:44 -0800, ak wrote:
> Hi everyone,
>
> I have a problem with urllib2 on this particular url, hosted on an
> Oracle HTTP Server
>
> http://www.orange.sk/eshop/sk/portal/catalog.html?
type=post&subtype=phone&null
>
> which gets 302 redir
On Jan 19, 10:00 pm, ak wrote:
> Hi everyone,
>
> I have a problem with urllib2 on this particular url, hosted on an
> Oracle HTTP Server
>
> http://www.orange.sk/eshop/sk/portal/catalog.html?type=post&subtype=p...
>
> which gets 302 redirected
> tohttps://www.
Hi everyone,
I have a problem with urllib2 on this particular url, hosted on an
Oracle HTTP Server
http://www.orange.sk/eshop/sk/portal/catalog.html?type=post&subtype=phone&null
which gets 302 redirected to
https://www.orange.sk/eshop/sk/catalog/post/phones.html,
after setting a cookie
On 2008-02-15 17:06, Ahmed, Shakir wrote:
> I was used import odbc to connect oracle or access table before, now I
> switched to python 2.4 and is giving me error message. I appreciate any
> help on that.
The win32 odbc module is very old and no longer maintained.
If you're
Ahmed, Shakir wrote:
> I was used import odbc to connect oracle or access table before, now I
> switched to python 2.4 and is giving me error message. I appreciate any
> help on that.
>
So this error message is a secret?
One possibility is that you are trying to use a 2.3 exte
I was used import odbc to connect oracle or access table before, now I
switched to python 2.4 and is giving me error message. I appreciate any
help on that.
Thanks
sh
--
http://mail.python.org/mailman/listinfo/python-list
t_rectenwald schrieb:
> Hello,
>
> I attempting to execute an Oracle query, and write the results to a
> file in CSV format. To do so, I've done the following:
>
> import cx_Oracle
> db = cx_Oracle.connect('user/[EMAIL PROTECTED]')
> cursor
Ralf Schönian schrieb:
> t_rectenwald schrieb:
>> Hello,
>>
>> I attempting to execute an Oracle query, and write the results to a
>> file in CSV format. To do so, I've done the following:
>>
>> import cx_Oracle
>> db = cx_Oracle.conne
lt;[EMAIL PROTECTED]> wrote:
>
> > > > Hello,
>
> > > > I attempting to execute an Oracle query, and write the results to a
> > > > file in CSV format. To do so, I've done the following:
>
> > > > import cx_Oracle
> > > > d
On Dec 26, 12:06 pm, Paul Hankin <[EMAIL PROTECTED]> wrote:
> On Dec 26, 4:51 pm, t_rectenwald <[EMAIL PROTECTED]> wrote:
>
>
>
>
>
> > On Dec 26, 10:36 am, t_rectenwald <[EMAIL PROTECTED]> wrote:
>
> > > Hello,
>
> > > I attempting
On Dec 26, 4:51 pm, t_rectenwald <[EMAIL PROTECTED]> wrote:
> On Dec 26, 10:36 am, t_rectenwald <[EMAIL PROTECTED]> wrote:
>
>
>
> > Hello,
>
> > I attempting to execute an Oracle query, and write the results to a
> > file in CSV format. To do so, I&
On Dec 26, 10:36 am, t_rectenwald <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I attempting to execute an Oracle query, and write the results to a
> file in CSV format. To do so, I've done the following:
>
> import cx_Oracle
> db = cx_Oracle.connect('user/[EM
Hello,
I attempting to execute an Oracle query, and write the results to a
file in CSV format. To do so, I've done the following:
import cx_Oracle
db = cx_Oracle.connect('user/[EMAIL PROTECTED]')
cursor = db.cursor()
cursor.arraysize = 500
cursor.execute(sql)
result = cursor.
Hi
Greets!
This is sandy,Working in TechRecruit Consultants,Chennai as Head
Operaitons - Recruitment.
Currently we have openning in Unix/SQL/Oracle/JAVA for ISO 9001:2000/
CMM LEVEL 5 Company in US.
About the company:An ISO 9001:2000 /SEI-CMM Level 5 accreditation.
Experience:4 - 7 Years
[EMAIL PROTECTED] wrote:
> Learn Oracle Database Administration in 10 Minutes. No kidding. Check
> it yourself,
>
> http://www.takveen.com
It already takes longer than 10 minutes to install, so I have the time to
learn more than I find in that book before I even get to using it.
B
Learn Oracle Database Administration in 10 Minutes. No kidding. Check
it yourself,
http://www.takveen.com
Only good analogy makes complex concepts simple!
--
http://mail.python.org/mailman/listinfo/python-list
On Mar 23, 9:50 am, Steve Holden <[EMAIL PROTECTED]> wrote:
> Godzilla wrote:
> > On Mar 23, 4:38 am, Dennis Lee Bieber <[EMAIL PROTECTED]> wrote:
> >> On 22 Mar 2007 05:36:46 -0700, "Godzilla" <[EMAIL PROTECTED]>
> >> declaimed the following in comp.lang.python:
>
> >>> Steve, I think I've tried w
Godzilla wrote:
> On Mar 23, 4:38 am, Dennis Lee Bieber <[EMAIL PROTECTED]> wrote:
>> On 22 Mar 2007 05:36:46 -0700, "Godzilla" <[EMAIL PROTECTED]>
>> declaimed the following in comp.lang.python:
>>
>>> Steve, I think I've tried what you have suggested without any luck as
>>> well... The statement
On Mar 23, 4:38 am, Dennis Lee Bieber <[EMAIL PROTECTED]> wrote:
> On 22 Mar 2007 05:36:46 -0700, "Godzilla" <[EMAIL PROTECTED]>
> declaimed the following in comp.lang.python:
>
> > Steve, I think I've tried what you have suggested without any luck as
> > well... The statement works fine, but what
On Mar 23, 4:38 am, Dennis Lee Bieber <[EMAIL PROTECTED]> wrote:
> On 22 Mar 2007 05:36:46 -0700, "Godzilla" <[EMAIL PROTECTED]>
> declaimed the following in comp.lang.python:
>
> > Steve, I think I've tried what you have suggested without any luck as
> > well... The statement works fine, but what
On Mar 22, 10:56 pm, Steve Holden <[EMAIL PROTECTED]> wrote:
> Godzilla wrote:
> > Dear all,
>
> > I cannot find a solution for my problem with inserting a blob object
> > (>4000 in length) into an ORACLE database via ODBC.
>
> > I have tried the two way
On 22 Mar, 10:21, "Godzilla" <[EMAIL PROTECTED]> wrote:
>
> I cannot find a solution for my problem with inserting a blob object
> (>4000 in length) into an ORACLE database via ODBC.
This brings back "happy" memories with Oracle 9i and JDBC.
> I have
Godzilla wrote:
> Dear all,
>
> I cannot find a solution for my problem with inserting a blob object
> (>4000 in length) into an ORACLE database via ODBC.
>
>
> I have tried the two ways of inserting the blob object (a zip file):
>
>
> 1)
> fp = op
Godzilla wrote:
> Dear all,
>
> I cannot find a solution for my problem with inserting a blob object
> (>4000 in length) into an ORACLE database via ODBC.
>
>
> I have tried the two ways of inserting the blob object (a zip file):
>
>
> 1)
> fp = op
Dear all,
I cannot find a solution for my problem with inserting a blob object
(>4000 in length) into an ORACLE database via ODBC.
I have tried the two ways of inserting the blob object (a zip file):
1)
fp = open("c:/test/test.zip", "r+b")
data = fp.read()
s = odbc.
Facundo Batista wrote:
> Hi! I need to connect to Oracle.
>
> I found this binding,
>
> http://www.zope.org/Members/matt/dco2
>
> that is the recommended in the Python page.
>
> But that page seems a bit confuse to me. In the upper right corner says
> that th
On Mar 14, 12:01 pm, Facundo Batista <[EMAIL PROTECTED]>
wrote:
> Hi! I need to connect to Oracle.
>
> I found this binding,
>
> http://www.zope.org/Members/matt/dco2
>
> that is the recommended in the Python page.
>
> But that page seems a bit confuse to me. In t
So do I !
2007/3/14, Josh Bloom <[EMAIL PROTECTED]>:
> I would suggest using cx_Oracle as I have had good experience with it.
> http://www.cxtools.net/default.aspx?nav=cxorlb
>
> -Josh
>
>
> On 3/14/07, Facundo Batista <[EMAIL PROTECTED]> wrote:
> > Hi!
I would suggest using cx_Oracle as I have had good experience with it.
http://www.cxtools.net/default.aspx?nav=cxorlb
-Josh
On 3/14/07, Facundo Batista <[EMAIL PROTECTED]> wrote:
Hi! I need to connect to Oracle.
I found this binding,
http://www.zope.org/Members/matt/dco2
that
Hi! I need to connect to Oracle.
I found this binding,
http://www.zope.org/Members/matt/dco2
that is the recommended in the Python page.
But that page seems a bit confuse to me. In the upper right corner says
that the last release is PreRelease 1, from 2001-11-15.
At the bottom, however, it
On 8 Mar, 15:35, "Giles Brown" <[EMAIL PROTECTED]> wrote:
> On 8 Mar, 22:19, "Greg Copeland" <[EMAIL PROTECTED]> wrote:
>
> > I'm using SQLAlchemy and have a need to call an Oracle function; which
> > is not the same as a stored proced
On Mar 8, 3:35 pm, "Giles Brown" <[EMAIL PROTECTED]> wrote:
http://www.sqlalchemy.org/docs/sqlconstruction.myt#sql_whereclause_fu...
> SQLAlchemy has its own google group
>
> http://groups.google.co.uk/group/sqlalchemy
>
> You could try asking there too.
>
> Giles
Very nice. That exactly answered
On 8 Mar, 22:19, "Greg Copeland" <[EMAIL PROTECTED]> wrote:
> I'm using SQLAlchemy and have a need to call an Oracle function; which
> is not the same as a stored procedure. Can this be done directory or
> indirectly with SQLAlchemy? If so, can someone please prov
Helpful Links
http://sourceforge.net/projects/cx-oracle
http://www.python.net/crew/atuining/cx_Oracle/html/cursorobj.html
==
Example:
Replace the data types as appropriate.
v_Vars = v_Cursor.setinputsizes(p_Result = cx_Oracle.NUMBER)
v_Cursor.execute(""
I'm using SQLAlchemy and have a need to call an Oracle function; which
is not the same as a stored procedure. Can this be done directory or
indirectly with SQLAlchemy? If so, can someone please provide an
example? If not, how do I obtain the raw cx_Oracle cursor so I can
use callfunc dir
I have a need to call an Oracle function, which is not the same thing
as a stored procedure. Can SQLAlchemy do this directly? Indirectly?
If so, an example would be appreciated. If not, how do I obtain the
raw cx_Oracle cursor so I can use that directly?
Thanks,
Greg
--
http
On Oct 5, 9:05 am, Tor Erik Soenvisen <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I need to export an Oracle database to a DDL-formated file. On the Web, I
> found a Python script that did exactly this for a MS Access database, but
> not one for Oracle databases.
>
> Does an
Tor Erik Soenvisen wrote:
> Hi,
>
> I need to export an Oracle database to a DDL-formated file. On the Web, I
> found a Python script that did exactly this for a MS Access database, but
> not one for Oracle databases.
How does the Python script connect to the MS Access database?
Tor Erik Soenvisen wrote:
> Hi,
>
> I need to export an Oracle database to a DDL-formated file. On the Web, I
> found a Python script that did exactly this for a MS Access database, but
> not one for Oracle databases.
>
> Does anyone know of such a tool or Python script
Hi,
I need to export an Oracle database to a DDL-formated file. On the Web, I
found a Python script that did exactly this for a MS Access database, but
not one for Oracle databases.
Does anyone know of such a tool or Python script.
regards tores
--
http://mail.python.org/mailman/listinfo
Title: Pure Python Oracle module
Does anyone know of a pure Python module for Oracle similar to Java's pure Oracle module?
Thank you!
Lance Ellinghaus
--
http://mail.python.org/mailman/listinfo/python-list
st
convert it into a number. But the problem is if we use float to convert
a string like '0.1' will be translated into 0.10001, which
is invalid for oracle type NUMBER(5,4).
How to resolve the problem?
--
http://mail.python.org/mailman/listinfo/python-list
Hello,
I'm planning on starting some database work on an Oracle 9i database,
any suggestions on which module I should use.
>From the python.org website I see that the options are:
- DCOracle2
- cx_Oracle
- mxODBC
Any help would be appreciated but please, support your answers
Cihal Josef wrote:
> Hi,
>
> how can I connect to oracle database as SYSDBA
>
> as usually: "sqlplus anc/psw as sysdba"
>
> It is a parsing problem? (blanks,etc.?)
>
> or it is not implmented in DCOracle2? [...]
From a quick glance at the code, it doe
Hi,
how can I connect to
oracle database as SYSDBA
as usually: "sqlplus
anc/psw as sysdba"
It is a parsing
problem? (blanks,etc.?)
or it is not
implmented in DCOracle2?
>DCOracle.Connect('user/psw as sysdba') ->
NOK
normal (without
sysdba clause)
Hi,
how can I connect
please to DB Oracle9i
via DCOracle.Connect
as SYSDBA?
>>> dbc =
DCOracle2.connect(user='', password= ' as sysdba'
)u,p2: sys,'pTraceback (most recent call last): File
"", line 1, in ? File "C:\Program
Files\Python21\lib\DCOracle2\DCOracle2\DCOracle2.py", line 1
A.M wrote:
>
> "Bill Scherer" <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]
> > A.M wrote:
> >
> >> Hi,
> >>
> >>
> >>
> >> I am familiar with Perl's DBI programming.
> >>
> >
"Bill Scherer" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> A.M wrote:
>
>> Hi,
>>
>>
>>
>> I am familiar with Perl's DBI programming.
>>
>>
>>
>> In Python, do we access to Oracle by using DB
A.M wrote:
> Hi,
>
>
>
> I am familiar with Perl's DBI programming.
>
>
>
> In Python, do we access to Oracle by using DBI?
>
No.
> Is Oracle DBD driver included with Python distributions?
>
No.
> What is the most common strategy for accessing to Ora
Hi,
I am familiar with Perl's DBI programming.
In Python, do we access to Oracle by using DBI? Is Oracle DBD driver
included with Python distributions?
What is the most common strategy for accessing to Oracle data through
Python?
Any help would be appreciated,
Alan
--
Hi!!
I'd like to install Oracle 10 g express edition over Ubuntu to use with
Python 2.4. I have installed Ubuntu, Python 2.4 and Oracle database. I
think that I have installed correctly cx_Oracle because I have
cx_Oracle.so in /usr/share/python2.4/site-packages/ directory. My
enviro
Thanks Andrew.
> I've been bugging ESRI about upgrading, and I'm sure others have too.
The beta of ArcGIS Desktop 9.2 ships with Python 2.4, so I imagine the
release of ArcGIS Desktop 9.2 this summer will also ship with Python
2.4. I've read threads recently on the geoprocessing / scripting
suppo
>[EMAIL PROTECTED] wrote:
> dananrg> Are you saying I'm getting the "L" as an artifact of printing?
>
> No, you're getting the "L" because you're printing a long integer. If you
> execute
>
> x = 872L
> y = 872
>
> at a Python prompt, x will be a long integer and y will be an integer. Lon
[EMAIL PROTECTED] wrote:
> # Print new list
> print recordList
>
>
[872L, 'ACTIVE', , >>>00EA1428>, None, '1.0.0.0', None, None, None]
Read the Python library manual chapter 2. Read all of it, it's all
very useful information, but take a particular look at str() and
repr(). All Python object
[posted & mailed]
[EMAIL PROTECTED] wrote:
> The only issue I've had so far is retrieving data from Oracle when an
> integer has been defined like:
>
>number(p)[same thing as number(p,0) evidently]
>
> This is from a database I didn't design and can
1 - 100 of 159 matches
Mail list logo
