cx-oracle-users Mailing List for cx_Oracle (Page 7)
Brought to you by:
atuining
Menu
▾
▴
cx-oracle-users — Primary discussion list for users (and developers) of cx_Oracle
You can subscribe to this list here.
| 2003 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
(5) |
Aug
(9) |
Sep
(8) |
Oct
(12) |
Nov
(4) |
Dec
(8) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2004 |
Jan
(15) |
Feb
(12) |
Mar
(11) |
Apr
(5) |
May
(7) |
Jun
(8) |
Jul
(12) |
Aug
(2) |
Sep
(14) |
Oct
(17) |
Nov
(20) |
Dec
(3) |
| 2005 |
Jan
(16) |
Feb
(9) |
Mar
(22) |
Apr
(21) |
May
(73) |
Jun
(16) |
Jul
(15) |
Aug
(10) |
Sep
(32) |
Oct
(35) |
Nov
(22) |
Dec
(13) |
| 2006 |
Jan
(42) |
Feb
(36) |
Mar
(13) |
Apr
(18) |
May
(8) |
Jun
(17) |
Jul
(24) |
Aug
(30) |
Sep
(35) |
Oct
(33) |
Nov
(33) |
Dec
(11) |
| 2007 |
Jan
(35) |
Feb
(31) |
Mar
(35) |
Apr
(64) |
May
(38) |
Jun
(12) |
Jul
(18) |
Aug
(34) |
Sep
(75) |
Oct
(29) |
Nov
(51) |
Dec
(11) |
| 2008 |
Jan
(27) |
Feb
(46) |
Mar
(48) |
Apr
(36) |
May
(59) |
Jun
(42) |
Jul
(25) |
Aug
(34) |
Sep
(57) |
Oct
(97) |
Nov
(59) |
Dec
(57) |
| 2009 |
Jan
(48) |
Feb
(48) |
Mar
(45) |
Apr
(24) |
May
(46) |
Jun
(52) |
Jul
(52) |
Aug
(37) |
Sep
(27) |
Oct
(40) |
Nov
(37) |
Dec
(13) |
| 2010 |
Jan
(16) |
Feb
(9) |
Mar
(24) |
Apr
(6) |
May
(27) |
Jun
(28) |
Jul
(60) |
Aug
(16) |
Sep
(33) |
Oct
(20) |
Nov
(39) |
Dec
(30) |
| 2011 |
Jan
(23) |
Feb
(43) |
Mar
(16) |
Apr
(29) |
May
(23) |
Jun
(16) |
Jul
(10) |
Aug
(8) |
Sep
(18) |
Oct
(42) |
Nov
(26) |
Dec
(20) |
| 2012 |
Jan
(17) |
Feb
(27) |
Mar
|
Apr
(20) |
May
(18) |
Jun
(7) |
Jul
(24) |
Aug
(21) |
Sep
(23) |
Oct
(18) |
Nov
(12) |
Dec
(5) |
| 2013 |
Jan
(14) |
Feb
(10) |
Mar
(20) |
Apr
(65) |
May
(3) |
Jun
(8) |
Jul
(6) |
Aug
(3) |
Sep
|
Oct
(3) |
Nov
(28) |
Dec
(3) |
| 2014 |
Jan
(3) |
Feb
(9) |
Mar
(4) |
Apr
(7) |
May
(20) |
Jun
(2) |
Jul
(20) |
Aug
(7) |
Sep
(11) |
Oct
(8) |
Nov
(6) |
Dec
(12) |
| 2015 |
Jan
(16) |
Feb
(10) |
Mar
(14) |
Apr
(8) |
May
|
Jun
(8) |
Jul
(15) |
Aug
(7) |
Sep
(1) |
Oct
(33) |
Nov
(8) |
Dec
(5) |
| 2016 |
Jan
(18) |
Feb
(12) |
Mar
(6) |
Apr
(14) |
May
(5) |
Jun
(3) |
Jul
|
Aug
(21) |
Sep
|
Oct
(15) |
Nov
(8) |
Dec
|
| 2017 |
Jan
|
Feb
(14) |
Mar
(21) |
Apr
(9) |
May
(6) |
Jun
(11) |
Jul
(23) |
Aug
(6) |
Sep
(5) |
Oct
(7) |
Nov
(1) |
Dec
(1) |
| 2018 |
Jan
|
Feb
|
Mar
(16) |
Apr
(2) |
May
(1) |
Jun
|
Jul
(2) |
Aug
|
Sep
(2) |
Oct
|
Nov
|
Dec
|
| 2019 |
Jan
(2) |
Feb
(3) |
Mar
(1) |
Apr
(1) |
May
|
Jun
|
Jul
(2) |
Aug
(1) |
Sep
(2) |
Oct
|
Nov
|
Dec
(1) |
| 2020 |
Jan
|
Feb
(4) |
Mar
|
Apr
|
May
(2) |
Jun
(1) |
Jul
(4) |
Aug
|
Sep
(1) |
Oct
|
Nov
|
Dec
(3) |
| 2021 |
Jan
|
Feb
(5) |
Mar
|
Apr
(7) |
May
(6) |
Jun
(1) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(1) |
Dec
|
| 2022 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(1) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2023 |
Jan
|
Feb
(1) |
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Venky <ven...@gm...> - 2017-03-02 10:33:20
|
Sorry for spam abt last email. Right now i have downloaded below files: file:///Users/Venky/Downloads/oracle-instantclient12.2-devel-12.2.0.1.0-1.x86_64.rpm file:///Users/Venky/Downloads/oracle-instantclient12.2-sqlplus-12.2.0.1.0-1.x86_64.rpm file:///Users/Venky/Downloads/oracle-instantclient12.2-basic-12.2.0.1.0-1.x86_64.rpm What else i need to download for the linux version mentioned in last email. Regards, Venky On Thu, Mar 2, 2017 at 2:46 PM, Venky <ven...@gm...> wrote: > Right now i have below linux where i will have my python code to connect > to oracle 10g and 12c residing on some other linux machine with below > version. > > uname -a > > Linux localhost.localdomain 3.10.0-327.el7.x86_64 #1 SMP Thu Nov 19 > 22:10:57 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux > > cat /etc/centos-release > > CentOS Linux release 7.2.1511 (Core) > > > > On Wed, Mar 1, 2017 at 6:22 PM, Jani Tiainen <re...@gm...> wrote: > >> Oracle Instant Client and SDK can be obtained from Oracle site: >> >> http://www.oracle.com/technetwork/database/features/instant- >> client/index-097480.html >> >> Note that you have to register yourself before downloading. >> >> Depending on your operating system what else you need varies. >> >> >> >> On 01.03.2017 14:27, Venky wrote: >> >> Thanks for clarifying the details. >> >> So can you please help me with the location from where i can get all the >> ones you mentioned ( like Instant Client, Instant Client SDK, >> cx_Oracle,etc) so that i would be able to connect to oracle 10g/12c >> using python once i installed it. >> >> >> >> On Tue, Feb 28, 2017 at 3:50 PM, Jani Tiainen <re...@gm...> wrote: >> >>> Instant Client is set of OCI libraries that are used to communicate to >>> Oracle database. >>> >>> And they are required, it's also required to have Instant Client SDK >>> files for compilation, and libaio1 installed from system packages. >>> cx_Oracle itself merely contains just bindings to communicate from >>> Python to Oracle through OCI libraries (Instant Client) and do some >>> conversions for certain datatypes. >>> >>> >>> >>> On 28.02.2017 12:00, Venky wrote: >>> >>> Thanks for the quick reply. >>> >>> Few queries, since i am a starter, what are InstantClient files? Is >>> this compulsory? >>> >>> Also installing "pip install cx_Oracle" on my linux box will install >>> the latest Oracle driver and does this has the support for which i was >>> asking? >>> Anything else i need to install as part of this cx_Oracle? >>> >>> >>> ~Venky >>> >>> On Mon, Feb 27, 2017 at 10:49 PM, Anthony Tuininga < >>> ant...@gm...> wrote: >>> >>>> If you use the Oracle 12c Release 1 instant client you can access an >>>> Oracle 10g Release 2 or higher database. Anything earlier than that would >>>> require the use of the Oracle 11g Release 2 instant client instead. Since >>>> Oracle 10g Release 1 is no longer supported the use of the Oracle 12c >>>> Release 1 instant client should work perfectly for you. >>>> >>>> Anthony >>>> >>>> On Mon, Feb 27, 2017 at 9:22 AM, Chris Gould < >>>> <chr...@to...>chr...@to...> wrote: >>>> >>>>> If you use the Oracle 12c driver (and the 12c InstantClient files) it >>>>> should be backward compatible with earlier versions of the database. >>>>> >>>>> >>>>> On 27 February 2017 at 16:12, Venky < <ven...@gm...> >>>>> ven...@gm...> wrote: >>>>> >>>>>> Hi Folks, >>>>>> >>>>>> Need you help. I wanted to automate few things for Oracle 10g using >>>>>> python. >>>>>> >>>>>> So can you guys, help me locate the library for the same. Also, in >>>>>> near future would be working on the same but with Oracle 12c. >>>>>> >>>>>> So do we have a single oracle lib for python which can work for all >>>>>> oracle versions or do we have lib for oracle specific to versions? >>>>>> >>>>>> Anticipating your quick reply. >>>>>> >>>>>> >>>>>> ~Venky >>>>>> >>>>>> ------------------------------------------------------------ >>>>>> ------------------ >>>>>> Check out the vibrant tech community on one of the world's most >>>>>> engaging tech sites, SlashDot.org! <http://sdm.link/slashdot> >>>>>> http://sdm.link/slashdot >>>>>> _______________________________________________ >>>>>> cx-oracle-users mailing list >>>>>> <cx-...@li...>cx-...@li...urcefo >>>>>> rge.net >>>>>> <https://lists.sourceforge.net/lists/listinfo/cx-oracle-users> >>>>>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >>>>>> >>>>>> >>>>> >>>>> ------------------------------------------------------------ >>>>> ------------------ >>>>> Check out the vibrant tech community on one of the world's most >>>>> engaging tech sites, SlashDot.org! <http://sdm.link/slashdot> >>>>> http://sdm.link/slashdot >>>>> _______________________________________________ >>>>> cx-oracle-users mailing list >>>>> cx-...@li... >>>>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >>>>> >>>>> >>>> >>>> ------------------------------------------------------------ >>>> ------------------ >>>> Check out the vibrant tech community on one of the world's most >>>> engaging tech sites, SlashDot.org! <http://sdm.link/slashdot> >>>> http://sdm.link/slashdot >>>> _______________________________________________ >>>> cx-oracle-users mailing list >>>> cx-...@li... >>>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >>>> >>>> >>> >>> >>> -- >>> Hi >>> >>> >>> ~Venky >>> >>> >>> ------------------------------------------------------------------------------ >>> Check out the vibrant tech community on one of the world's most >>> engaging tech sites, SlashDot.org! http://sdm.link/slashdot >>> >>> _______________________________________________ >>> cx-oracle-users mailing lis...@li...https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >>> >>> -- >>> Jani Tiainen >>> >>> ------------------------------------------------------------------------------ >>> Check out the vibrant tech community on one of the world's most engaging >>> tech sites, SlashDot.org! http://sdm.link/slashdot >>> _______________________________________________ cx-oracle-users mailing >>> list cx-...@li... >>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >> >> -- >> Hi ~Venky >> >> ------------------------------------------------------------------------------ >> Check out the vibrant tech community on one of the world's most >> engaging tech sites, SlashDot.org! http://sdm.link/slashdot >> >> _______________________________________________ >> cx-oracle-users mailing lis...@li...https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >> >> -- >> Jani Tiainen >> >> >> ------------------------------------------------------------ >> ------------------ >> Check out the vibrant tech community on one of the world's most >> engaging tech sites, SlashDot.org! http://sdm.link/slashdot >> _______________________________________________ >> cx-oracle-users mailing list >> cx-...@li... >> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >> >> > > > -- > Hi > > > ~Venky > -- Hi ~Venky |
|
From: Venky <ven...@gm...> - 2017-03-02 10:30:57
|
So right now i have downloaded On Thu, Mar 2, 2017 at 2:46 PM, Venky <ven...@gm...> wrote: > Right now i have below linux where i will have my python code to connect > to oracle 10g and 12c residing on some other linux machine with below > version. > > uname -a > > Linux localhost.localdomain 3.10.0-327.el7.x86_64 #1 SMP Thu Nov 19 > 22:10:57 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux > > cat /etc/centos-release > > CentOS Linux release 7.2.1511 (Core) > > > > On Wed, Mar 1, 2017 at 6:22 PM, Jani Tiainen <re...@gm...> wrote: > >> Oracle Instant Client and SDK can be obtained from Oracle site: >> >> http://www.oracle.com/technetwork/database/features/instant- >> client/index-097480.html >> >> Note that you have to register yourself before downloading. >> >> Depending on your operating system what else you need varies. >> >> >> >> On 01.03.2017 14:27, Venky wrote: >> >> Thanks for clarifying the details. >> >> So can you please help me with the location from where i can get all the >> ones you mentioned ( like Instant Client, Instant Client SDK, >> cx_Oracle,etc) so that i would be able to connect to oracle 10g/12c >> using python once i installed it. >> >> >> >> On Tue, Feb 28, 2017 at 3:50 PM, Jani Tiainen <re...@gm...> wrote: >> >>> Instant Client is set of OCI libraries that are used to communicate to >>> Oracle database. >>> >>> And they are required, it's also required to have Instant Client SDK >>> files for compilation, and libaio1 installed from system packages. >>> cx_Oracle itself merely contains just bindings to communicate from >>> Python to Oracle through OCI libraries (Instant Client) and do some >>> conversions for certain datatypes. >>> >>> >>> >>> On 28.02.2017 12:00, Venky wrote: >>> >>> Thanks for the quick reply. >>> >>> Few queries, since i am a starter, what are InstantClient files? Is >>> this compulsory? >>> >>> Also installing "pip install cx_Oracle" on my linux box will install >>> the latest Oracle driver and does this has the support for which i was >>> asking? >>> Anything else i need to install as part of this cx_Oracle? >>> >>> >>> ~Venky >>> >>> On Mon, Feb 27, 2017 at 10:49 PM, Anthony Tuininga < >>> ant...@gm...> wrote: >>> >>>> If you use the Oracle 12c Release 1 instant client you can access an >>>> Oracle 10g Release 2 or higher database. Anything earlier than that would >>>> require the use of the Oracle 11g Release 2 instant client instead. Since >>>> Oracle 10g Release 1 is no longer supported the use of the Oracle 12c >>>> Release 1 instant client should work perfectly for you. >>>> >>>> Anthony >>>> >>>> On Mon, Feb 27, 2017 at 9:22 AM, Chris Gould < >>>> <chr...@to...>chr...@to...> wrote: >>>> >>>>> If you use the Oracle 12c driver (and the 12c InstantClient files) it >>>>> should be backward compatible with earlier versions of the database. >>>>> >>>>> >>>>> On 27 February 2017 at 16:12, Venky < <ven...@gm...> >>>>> ven...@gm...> wrote: >>>>> >>>>>> Hi Folks, >>>>>> >>>>>> Need you help. I wanted to automate few things for Oracle 10g using >>>>>> python. >>>>>> >>>>>> So can you guys, help me locate the library for the same. Also, in >>>>>> near future would be working on the same but with Oracle 12c. >>>>>> >>>>>> So do we have a single oracle lib for python which can work for all >>>>>> oracle versions or do we have lib for oracle specific to versions? >>>>>> >>>>>> Anticipating your quick reply. >>>>>> >>>>>> >>>>>> ~Venky >>>>>> >>>>>> ------------------------------------------------------------ >>>>>> ------------------ >>>>>> Check out the vibrant tech community on one of the world's most >>>>>> engaging tech sites, SlashDot.org! <http://sdm.link/slashdot> >>>>>> http://sdm.link/slashdot >>>>>> _______________________________________________ >>>>>> cx-oracle-users mailing list >>>>>> <cx-...@li...>cx-...@li...urcefo >>>>>> rge.net >>>>>> <https://lists.sourceforge.net/lists/listinfo/cx-oracle-users> >>>>>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >>>>>> >>>>>> >>>>> >>>>> ------------------------------------------------------------ >>>>> ------------------ >>>>> Check out the vibrant tech community on one of the world's most >>>>> engaging tech sites, SlashDot.org! <http://sdm.link/slashdot> >>>>> http://sdm.link/slashdot >>>>> _______________________________________________ >>>>> cx-oracle-users mailing list >>>>> cx-...@li... >>>>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >>>>> >>>>> >>>> >>>> ------------------------------------------------------------ >>>> ------------------ >>>> Check out the vibrant tech community on one of the world's most >>>> engaging tech sites, SlashDot.org! <http://sdm.link/slashdot> >>>> http://sdm.link/slashdot >>>> _______________________________________________ >>>> cx-oracle-users mailing list >>>> cx-...@li... >>>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >>>> >>>> >>> >>> >>> -- >>> Hi >>> >>> >>> ~Venky >>> >>> >>> ------------------------------------------------------------------------------ >>> Check out the vibrant tech community on one of the world's most >>> engaging tech sites, SlashDot.org! http://sdm.link/slashdot >>> >>> _______________________________________________ >>> cx-oracle-users mailing lis...@li...https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >>> >>> -- >>> Jani Tiainen >>> >>> ------------------------------------------------------------------------------ >>> Check out the vibrant tech community on one of the world's most engaging >>> tech sites, SlashDot.org! http://sdm.link/slashdot >>> _______________________________________________ cx-oracle-users mailing >>> list cx-...@li... >>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >> >> -- >> Hi ~Venky >> >> ------------------------------------------------------------------------------ >> Check out the vibrant tech community on one of the world's most >> engaging tech sites, SlashDot.org! http://sdm.link/slashdot >> >> _______________________________________________ >> cx-oracle-users mailing lis...@li...https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >> >> -- >> Jani Tiainen >> >> >> ------------------------------------------------------------ >> ------------------ >> Check out the vibrant tech community on one of the world's most >> engaging tech sites, SlashDot.org! http://sdm.link/slashdot >> _______________________________________________ >> cx-oracle-users mailing list >> cx-...@li... >> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >> >> > > > -- > Hi > > > ~Venky > -- Hi ~Venky |
|
From: Jani T. <re...@gm...> - 2017-03-02 09:49:38
|
Hi, Having a CentOS is good, you can install rpm-packages and it should setup all your environment right so after installing instant client + sdk just reload/relogin and try to install cx_Oracle, it should work out of the box. On 02.03.2017 11:16, Venky wrote: > Right now i have below linux where i will have my python code to > connect to oracle 10g and 12c residing on some other linux machine > with below version. > > uname -a > > Linux localhost.localdomain 3.10.0-327.el7.x86_64 #1 SMP Thu Nov 19 > 22:10:57 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux > > > cat /etc/centos-release > > CentOS Linux release 7.2.1511 (Core) > > > > On Wed, Mar 1, 2017 at 6:22 PM, Jani Tiainen <re...@gm... > <mailto:re...@gm...>> wrote: > > Oracle Instant Client and SDK can be obtained from Oracle site: > > http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html > <http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html> > > Note that you have to register yourself before downloading. > > > Depending on your operating system what else you need varies. > > > > On 01.03.2017 14:27, Venky wrote: >> Thanks for clarifying the details. >> >> So can you please help me with the location from where i can get >> all the ones you mentioned ( like Instant Client, Instant Client >> SDK, cx_Oracle,etc) so that i would be able to connect to oracle >> 10g/12c using python once i installed it. >> >> >> >> On Tue, Feb 28, 2017 at 3:50 PM, Jani Tiainen <re...@gm... >> <mailto:re...@gm...>> wrote: >> >> Instant Client is set of OCI libraries that are used to >> communicate to Oracle database. >> >> And they are required, it's also required to have Instant >> Client SDK files for compilation, and libaio1 installed from >> system packages. >> >> cx_Oracle itself merely contains just bindings to communicate >> from Python to Oracle through OCI libraries (Instant Client) >> and do some conversions for certain datatypes. >> >> >> >> On 28.02.2017 12:00, Venky wrote: >>> Thanks for the quick reply. >>> >>> Few queries, since i am a starter, what are InstantClient >>> files? Is this compulsory? >>> >>> Also installing "pip install cx_Oracle" on my linux box will >>> install the latest Oracle driver and does this has the >>> support for which i was asking? >>> Anything else i need to install as part of this cx_Oracle? >>> >>> >>> ~Venky >>> >>> On Mon, Feb 27, 2017 at 10:49 PM, Anthony Tuininga >>> <ant...@gm... >>> <mailto:ant...@gm...>> wrote: >>> >>> If you use the Oracle 12c Release 1 instant client you >>> can access an Oracle 10g Release 2 or higher database. >>> Anything earlier than that would require the use of the >>> Oracle 11g Release 2 instant client instead. Since >>> Oracle 10g Release 1 is no longer supported the use of >>> the Oracle 12c Release 1 instant client should work >>> perfectly for you. >>> >>> Anthony >>> >>> On Mon, Feb 27, 2017 at 9:22 AM, Chris Gould >>> <chr...@to... >>> <mailto:chr...@to...>> wrote: >>> >>> If you use the Oracle 12c driver (and the 12c >>> InstantClient files) it should be backward >>> compatible with earlier versions of the database. >>> >>> >>> On 27 February 2017 at 16:12, Venky >>> <ven...@gm... >>> <mailto:ven...@gm...>> wrote: >>> >>> Hi Folks, >>> >>> Need you help. I wanted to automate few things >>> for Oracle 10g using python. >>> >>> So can you guys, help me locate the library for >>> the same. Also, in near future would be working >>> on the same but with Oracle 12c. >>> >>> So do we have a single oracle lib for python >>> which can work for all oracle versions or do we >>> have lib for oracle specific to versions? >>> >>> Anticipating your quick reply. >>> >>> >>> ~Venky >>> >>> ------------------------------------------------------------------------------ >>> Check out the vibrant tech community on one of >>> the world's most >>> engaging tech sites, SlashDot.org! >>> http://sdm.link/slashdot >>> _______________________________________________ >>> cx-oracle-users mailing list >>> cx-...@li...urcefo >>> <mailto:cx-...@li...urcefo>rge.net >>> <http://rge.net> >>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >>> >>> >>> >>> ------------------------------------------------------------------------------ >>> Check out the vibrant tech community on one of the >>> world's most >>> engaging tech sites, SlashDot.org! >>> http://sdm.link/slashdot >>> _______________________________________________ >>> cx-oracle-users mailing list >>> cx-...@li... >>> <mailto:cx-...@li...> >>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >>> <https://lists.sourceforge.net/lists/listinfo/cx-oracle-users> >>> >>> >>> >>> ------------------------------------------------------------------------------ >>> Check out the vibrant tech community on one of the >>> world's most >>> engaging tech sites, SlashDot.org! http://sdm.link/slashdot >>> _______________________________________________ >>> cx-oracle-users mailing list >>> cx-...@li... >>> <mailto:cx-...@li...> >>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >>> <https://lists.sourceforge.net/lists/listinfo/cx-oracle-users> >>> >>> >>> >>> >>> -- >>> Hi >>> >>> >>> ~Venky >>> >>> >>> ------------------------------------------------------------------------------ >>> Check out the vibrant tech community on one of the world's most >>> engaging tech sites, SlashDot.org!http://sdm.link/slashdot >>> >>> _______________________________________________ >>> cx-oracle-users mailing list >>> cx-...@li... >>> <mailto:cx-...@li...> >>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >>> <https://lists.sourceforge.net/lists/listinfo/cx-oracle-users> >> >> -- >> Jani Tiainen >> >> ------------------------------------------------------------------------------ >> Check out the vibrant tech community on one of the world's >> most engaging tech sites, SlashDot.org! >> http://sdm.link/slashdot >> _______________________________________________ >> cx-oracle-users mailing list >> cx-...@li... >> <mailto:cx-...@li...> >> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >> <https://lists.sourceforge.net/lists/listinfo/cx-oracle-users> >> >> -- >> Hi ~Venky >> >> ------------------------------------------------------------------------------ >> Check out the vibrant tech community on one of the world's most >> engaging tech sites, SlashDot.org!http://sdm.link/slashdot >> >> _______________________________________________ >> cx-oracle-users mailing list >> cx-...@li... >> <mailto:cx-...@li...> >> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >> <https://lists.sourceforge.net/lists/listinfo/cx-oracle-users> > -- > Jani Tiainen > > ------------------------------------------------------------------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, SlashDot.org! http://sdm.link/slashdot > _______________________________________________ cx-oracle-users > mailing list cx-...@li... > <mailto:cx-...@li...> > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > <https://lists.sourceforge.net/lists/listinfo/cx-oracle-users> > > -- > Hi ~Venky > > ------------------------------------------------------------------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, SlashDot.org! http://sdm.link/slashdot > > _______________________________________________ > cx-oracle-users mailing list > cx-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users -- Jani Tiainen |
|
From: Venky <ven...@gm...> - 2017-03-02 09:16:40
|
Right now i have below linux where i will have my python code to connect to oracle 10g and 12c residing on some other linux machine with below version. uname -a Linux localhost.localdomain 3.10.0-327.el7.x86_64 #1 SMP Thu Nov 19 22:10:57 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux cat /etc/centos-release CentOS Linux release 7.2.1511 (Core) On Wed, Mar 1, 2017 at 6:22 PM, Jani Tiainen <re...@gm...> wrote: > Oracle Instant Client and SDK can be obtained from Oracle site: > > http://www.oracle.com/technetwork/database/features/ > instant-client/index-097480.html > > Note that you have to register yourself before downloading. > > Depending on your operating system what else you need varies. > > > > On 01.03.2017 14:27, Venky wrote: > > Thanks for clarifying the details. > > So can you please help me with the location from where i can get all the > ones you mentioned ( like Instant Client, Instant Client SDK, > cx_Oracle,etc) so that i would be able to connect to oracle 10g/12c > using python once i installed it. > > > > On Tue, Feb 28, 2017 at 3:50 PM, Jani Tiainen <re...@gm...> wrote: > >> Instant Client is set of OCI libraries that are used to communicate to >> Oracle database. >> >> And they are required, it's also required to have Instant Client SDK >> files for compilation, and libaio1 installed from system packages. >> cx_Oracle itself merely contains just bindings to communicate from Python >> to Oracle through OCI libraries (Instant Client) and do some conversions >> for certain datatypes. >> >> >> >> On 28.02.2017 12:00, Venky wrote: >> >> Thanks for the quick reply. >> >> Few queries, since i am a starter, what are InstantClient files? Is this >> compulsory? >> >> Also installing "pip install cx_Oracle" on my linux box will install the >> latest Oracle driver and does this has the support for which i was >> asking? >> Anything else i need to install as part of this cx_Oracle? >> >> >> ~Venky >> >> On Mon, Feb 27, 2017 at 10:49 PM, Anthony Tuininga < >> ant...@gm...> wrote: >> >>> If you use the Oracle 12c Release 1 instant client you can access an >>> Oracle 10g Release 2 or higher database. Anything earlier than that would >>> require the use of the Oracle 11g Release 2 instant client instead. Since >>> Oracle 10g Release 1 is no longer supported the use of the Oracle 12c >>> Release 1 instant client should work perfectly for you. >>> >>> Anthony >>> >>> On Mon, Feb 27, 2017 at 9:22 AM, Chris Gould < >>> <chr...@to...>chr...@to...> wrote: >>> >>>> If you use the Oracle 12c driver (and the 12c InstantClient files) it >>>> should be backward compatible with earlier versions of the database. >>>> >>>> >>>> On 27 February 2017 at 16:12, Venky < <ven...@gm...> >>>> ven...@gm...> wrote: >>>> >>>>> Hi Folks, >>>>> >>>>> Need you help. I wanted to automate few things for Oracle 10g using >>>>> python. >>>>> >>>>> So can you guys, help me locate the library for the same. Also, in >>>>> near future would be working on the same but with Oracle 12c. >>>>> >>>>> So do we have a single oracle lib for python which can work for all >>>>> oracle versions or do we have lib for oracle specific to versions? >>>>> >>>>> Anticipating your quick reply. >>>>> >>>>> >>>>> ~Venky >>>>> >>>>> ------------------------------------------------------------ >>>>> ------------------ >>>>> Check out the vibrant tech community on one of the world's most >>>>> engaging tech sites, SlashDot.org! <http://sdm.link/slashdot> >>>>> http://sdm.link/slashdot >>>>> _______________________________________________ >>>>> cx-oracle-users mailing list >>>>> <cx-...@li...>cx-...@li...urcefo >>>>> rge.net >>>>> <https://lists.sourceforge.net/lists/listinfo/cx-oracle-users> >>>>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >>>>> >>>>> >>>> >>>> ------------------------------------------------------------ >>>> ------------------ >>>> Check out the vibrant tech community on one of the world's most >>>> engaging tech sites, SlashDot.org! <http://sdm.link/slashdot> >>>> http://sdm.link/slashdot >>>> _______________________________________________ >>>> cx-oracle-users mailing list >>>> cx-...@li... >>>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >>>> >>>> >>> >>> ------------------------------------------------------------ >>> ------------------ >>> Check out the vibrant tech community on one of the world's most >>> engaging tech sites, SlashDot.org! <http://sdm.link/slashdot> >>> http://sdm.link/slashdot >>> _______________________________________________ >>> cx-oracle-users mailing list >>> cx-...@li... >>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >>> >>> >> >> >> -- >> Hi >> >> >> ~Venky >> >> >> ------------------------------------------------------------------------------ >> Check out the vibrant tech community on one of the world's most >> engaging tech sites, SlashDot.org! http://sdm.link/slashdot >> >> _______________________________________________ >> cx-oracle-users mailing lis...@li...https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >> >> -- >> Jani Tiainen >> >> ------------------------------------------------------------------------------ >> Check out the vibrant tech community on one of the world's most engaging >> tech sites, SlashDot.org! http://sdm.link/slashdot >> _______________________________________________ cx-oracle-users mailing >> list cx-...@li... https://lists.sourceforge.net/ >> lists/listinfo/cx-oracle-users > > -- > Hi ~Venky > > ------------------------------------------------------------------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, SlashDot.org! http://sdm.link/slashdot > > _______________________________________________ > cx-oracle-users mailing lis...@li...https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > > -- > Jani Tiainen > > > ------------------------------------------------------------ > ------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, SlashDot.org! http://sdm.link/slashdot > _______________________________________________ > cx-oracle-users mailing list > cx-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > > -- Hi ~Venky |
|
From: <jos...@si...> - 2017-03-02 08:26:27
|
Hi folks,
Need you help. I wrote a python script to create several tables which select huge data from other tables in different python threads. I ran the script several times and it always turn out to unable to complete. So i ran gdb to check what the script was doing. The function stack show the Cursor_InternalExecute invoking did not return. I can't fix it then I see you help. The python code is like this:
def split_credit(user_name, region_code):
with CDB(zc_dbUser, zc_dbPasswd, zc_dbCon) as db: #thread's own cx_Oracle.Connection
credittable = "XXXX_XXXXX_08{0}".format(region_code)
creditsql = """CREATE TABLE XX.XX_XXXXX_08{0} tablespace {1} AS
SELECT ....."""
db.tabledrop(user_name, credittable)
db.dosql(creditsql)
time.sleep(1)
workers = []
for i in range(0, 10):
region_code = "5"+str(i)
workerCredit= threading.Thread(target=split_credit, name="credit_"+region_code, args=(zc_dbUser, region_code))
workers.append(workerCredit)
workerCredit.start()
|
|
From: Jani T. <re...@gm...> - 2017-03-01 12:52:40
|
Oracle Instant Client and SDK can be obtained from Oracle site: http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html Note that you have to register yourself before downloading. Depending on your operating system what else you need varies. On 01.03.2017 14:27, Venky wrote: > Thanks for clarifying the details. > > So can you please help me with the location from where i can get all > the ones you mentioned ( like Instant Client, Instant Client > SDK, cx_Oracle,etc) so that i would be able to connect to oracle > 10g/12c using python once i installed it. > > > > On Tue, Feb 28, 2017 at 3:50 PM, Jani Tiainen <re...@gm... > <mailto:re...@gm...>> wrote: > > Instant Client is set of OCI libraries that are used to > communicate to Oracle database. > > And they are required, it's also required to have Instant Client > SDK files for compilation, and libaio1 installed from system packages. > > cx_Oracle itself merely contains just bindings to communicate from > Python to Oracle through OCI libraries (Instant Client) and do > some conversions for certain datatypes. > > > > On 28.02.2017 12:00, Venky wrote: >> Thanks for the quick reply. >> >> Few queries, since i am a starter, what are InstantClient files? >> Is this compulsory? >> >> Also installing "pip install cx_Oracle" on my linux box will >> install the latest Oracle driver and does this has the support >> for which i was asking? >> Anything else i need to install as part of this cx_Oracle? >> >> >> ~Venky >> >> On Mon, Feb 27, 2017 at 10:49 PM, Anthony Tuininga >> <ant...@gm... <mailto:ant...@gm...>> >> wrote: >> >> If you use the Oracle 12c Release 1 instant client you can >> access an Oracle 10g Release 2 or higher database. Anything >> earlier than that would require the use of the Oracle 11g >> Release 2 instant client instead. Since Oracle 10g Release 1 >> is no longer supported the use of the Oracle 12c Release 1 >> instant client should work perfectly for you. >> >> Anthony >> >> On Mon, Feb 27, 2017 at 9:22 AM, Chris Gould >> <chr...@to... <mailto:chr...@to...>> >> wrote: >> >> If you use the Oracle 12c driver (and the 12c >> InstantClient files) it should be backward compatible >> with earlier versions of the database. >> >> >> On 27 February 2017 at 16:12, Venky >> <ven...@gm... >> <mailto:ven...@gm...>> wrote: >> >> Hi Folks, >> >> Need you help. I wanted to automate few things for >> Oracle 10g using python. >> >> So can you guys, help me locate the library for the >> same. Also, in near future would be working on the >> same but with Oracle 12c. >> >> So do we have a single oracle lib for python which >> can work for all oracle versions or do we have lib >> for oracle specific to versions? >> >> Anticipating your quick reply. >> >> >> ~Venky >> >> ------------------------------------------------------------------------------ >> Check out the vibrant tech community on one of the >> world's most >> engaging tech sites, SlashDot.org! >> http://sdm.link/slashdot >> _______________________________________________ >> cx-oracle-users mailing list >> cx-...@li... >> <mailto:cx-...@li...> >> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >> <https://lists.sourceforge.net/lists/listinfo/cx-oracle-users> >> >> >> >> ------------------------------------------------------------------------------ >> Check out the vibrant tech community on one of the >> world's most >> engaging tech sites, SlashDot.org! http://sdm.link/slashdot >> _______________________________________________ >> cx-oracle-users mailing list >> cx-...@li... >> <mailto:cx-...@li...> >> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >> <https://lists.sourceforge.net/lists/listinfo/cx-oracle-users> >> >> >> >> ------------------------------------------------------------------------------ >> Check out the vibrant tech community on one of the world's most >> engaging tech sites, SlashDot.org! http://sdm.link/slashdot >> _______________________________________________ >> cx-oracle-users mailing list >> cx-...@li... >> <mailto:cx-...@li...> >> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >> <https://lists.sourceforge.net/lists/listinfo/cx-oracle-users> >> >> >> >> >> -- >> Hi >> >> >> ~Venky >> >> >> ------------------------------------------------------------------------------ >> Check out the vibrant tech community on one of the world's most >> engaging tech sites, SlashDot.org!http://sdm.link/slashdot >> >> _______________________________________________ >> cx-oracle-users mailing list >> cx-...@li... >> <mailto:cx-...@li...> >> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >> <https://lists.sourceforge.net/lists/listinfo/cx-oracle-users> > > -- > Jani Tiainen > > ------------------------------------------------------------------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, SlashDot.org! http://sdm.link/slashdot > _______________________________________________ cx-oracle-users > mailing list cx-...@li... > <mailto:cx-...@li...> > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > <https://lists.sourceforge.net/lists/listinfo/cx-oracle-users> > > -- > Hi ~Venky > > ------------------------------------------------------------------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, SlashDot.org! http://sdm.link/slashdot > > _______________________________________________ > cx-oracle-users mailing list > cx-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users -- Jani Tiainen |
|
From: Venky <ven...@gm...> - 2017-03-01 12:28:05
|
Thanks for clarifying the details. So can you please help me with the location from where i can get all the ones you mentioned ( like Instant Client, Instant Client SDK, cx_Oracle,etc) so that i would be able to connect to oracle 10g/12c using python once i installed it. On Tue, Feb 28, 2017 at 3:50 PM, Jani Tiainen <re...@gm...> wrote: > Instant Client is set of OCI libraries that are used to communicate to > Oracle database. > > And they are required, it's also required to have Instant Client SDK files > for compilation, and libaio1 installed from system packages. > cx_Oracle itself merely contains just bindings to communicate from Python > to Oracle through OCI libraries (Instant Client) and do some conversions > for certain datatypes. > > > > On 28.02.2017 12:00, Venky wrote: > > Thanks for the quick reply. > > Few queries, since i am a starter, what are InstantClient files? Is this > compulsory? > > Also installing "pip install cx_Oracle" on my linux box will install the > latest Oracle driver and does this has the support for which i was asking? > Anything else i need to install as part of this cx_Oracle? > > > ~Venky > > On Mon, Feb 27, 2017 at 10:49 PM, Anthony Tuininga < > <ant...@gm...>ant...@gm...> wrote: > >> If you use the Oracle 12c Release 1 instant client you can access an >> Oracle 10g Release 2 or higher database. Anything earlier than that would >> require the use of the Oracle 11g Release 2 instant client instead. Since >> Oracle 10g Release 1 is no longer supported the use of the Oracle 12c >> Release 1 instant client should work perfectly for you. >> >> Anthony >> >> On Mon, Feb 27, 2017 at 9:22 AM, Chris Gould < <chr...@to...> >> chr...@to...> wrote: >> >>> If you use the Oracle 12c driver (and the 12c InstantClient files) it >>> should be backward compatible with earlier versions of the database. >>> >>> >>> On 27 February 2017 at 16:12, Venky < <ven...@gm...> >>> ven...@gm...> wrote: >>> >>>> Hi Folks, >>>> >>>> Need you help. I wanted to automate few things for Oracle 10g using >>>> python. >>>> >>>> So can you guys, help me locate the library for the same. Also, in near >>>> future would be working on the same but with Oracle 12c. >>>> >>>> So do we have a single oracle lib for python which can work for all >>>> oracle versions or do we have lib for oracle specific to versions? >>>> >>>> Anticipating your quick reply. >>>> >>>> >>>> ~Venky >>>> >>>> ------------------------------------------------------------ >>>> ------------------ >>>> Check out the vibrant tech community on one of the world's most >>>> engaging tech sites, SlashDot.org! <http://sdm.link/slashdot> >>>> http://sdm.link/slashdot >>>> _______________________________________________ >>>> cx-oracle-users mailing list >>>> cx-...@li... >>>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >>>> >>>> >>> >>> ------------------------------------------------------------ >>> ------------------ >>> Check out the vibrant tech community on one of the world's most >>> engaging tech sites, SlashDot.org! <http://sdm.link/slashdot> >>> http://sdm.link/slashdot >>> _______________________________________________ >>> cx-oracle-users mailing list >>> cx-...@li... >>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >>> >>> >> >> ------------------------------------------------------------ >> ------------------ >> Check out the vibrant tech community on one of the world's most >> engaging tech sites, SlashDot.org! <http://sdm.link/slashdot> >> http://sdm.link/slashdot >> _______________________________________________ >> cx-oracle-users mailing list >> cx-...@li... >> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >> >> > > > -- > Hi > > > ~Venky > > > ------------------------------------------------------------------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, SlashDot.org! http://sdm.link/slashdot > > > > _______________________________________________ > cx-oracle-users mailing lis...@li...https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > > > -- > Jani Tiainen > > > ------------------------------------------------------------ > ------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, SlashDot.org! http://sdm.link/slashdot > _______________________________________________ > cx-oracle-users mailing list > cx-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > > -- Hi ~Venky |
|
From: Jani T. <re...@gm...> - 2017-02-28 10:20:15
|
Instant Client is set of OCI libraries that are used to communicate to Oracle database. And they are required, it's also required to have Instant Client SDK files for compilation, and libaio1 installed from system packages. cx_Oracle itself merely contains just bindings to communicate from Python to Oracle through OCI libraries (Instant Client) and do some conversions for certain datatypes. On 28.02.2017 12:00, Venky wrote: > Thanks for the quick reply. > > Few queries, since i am a starter, what are InstantClient files? Is > this compulsory? > > Also installing "pip install cx_Oracle" on my linux box will install > the latest Oracle driver and does this has the support for which i was > asking? > Anything else i need to install as part of this cx_Oracle? > > > ~Venky > > On Mon, Feb 27, 2017 at 10:49 PM, Anthony Tuininga > <ant...@gm... <mailto:ant...@gm...>> wrote: > > If you use the Oracle 12c Release 1 instant client you can access > an Oracle 10g Release 2 or higher database. Anything earlier than > that would require the use of the Oracle 11g Release 2 instant > client instead. Since Oracle 10g Release 1 is no longer supported > the use of the Oracle 12c Release 1 instant client should work > perfectly for you. > > Anthony > > On Mon, Feb 27, 2017 at 9:22 AM, Chris Gould > <chr...@to... <mailto:chr...@to...>> wrote: > > If you use the Oracle 12c driver (and the 12c InstantClient > files) it should be backward compatible with earlier versions > of the database. > > > On 27 February 2017 at 16:12, Venky <ven...@gm... > <mailto:ven...@gm...>> wrote: > > Hi Folks, > > Need you help. I wanted to automate few things for Oracle > 10g using python. > > So can you guys, help me locate the library for the same. > Also, in near future would be working on the same but with > Oracle 12c. > > So do we have a single oracle lib for python which can > work for all oracle versions or do we have lib for oracle > specific to versions? > > Anticipating your quick reply. > > > ~Venky > > ------------------------------------------------------------------------------ > Check out the vibrant tech community on one of the world's > most > engaging tech sites, SlashDot.org! http://sdm.link/slashdot > _______________________________________________ > cx-oracle-users mailing list > cx-...@li... > <mailto:cx-...@li...> > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > <https://lists.sourceforge.net/lists/listinfo/cx-oracle-users> > > > > ------------------------------------------------------------------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, SlashDot.org! http://sdm.link/slashdot > _______________________________________________ > cx-oracle-users mailing list > cx-...@li... > <mailto:cx-...@li...> > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > <https://lists.sourceforge.net/lists/listinfo/cx-oracle-users> > > > > ------------------------------------------------------------------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, SlashDot.org! http://sdm.link/slashdot > _______________________________________________ > cx-oracle-users mailing list > cx-...@li... > <mailto:cx-...@li...> > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > <https://lists.sourceforge.net/lists/listinfo/cx-oracle-users> > > > > > -- > Hi > > > ~Venky > > > ------------------------------------------------------------------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, SlashDot.org! http://sdm.link/slashdot > > > _______________________________________________ > cx-oracle-users mailing list > cx-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users -- Jani Tiainen |
|
From: Venky <ven...@gm...> - 2017-02-28 10:01:00
|
Thanks for the quick reply. Few queries, since i am a starter, what are InstantClient files? Is this compulsory? Also installing "pip install cx_Oracle" on my linux box will install the latest Oracle driver and does this has the support for which i was asking? Anything else i need to install as part of this cx_Oracle? ~Venky On Mon, Feb 27, 2017 at 10:49 PM, Anthony Tuininga < ant...@gm...> wrote: > If you use the Oracle 12c Release 1 instant client you can access an > Oracle 10g Release 2 or higher database. Anything earlier than that would > require the use of the Oracle 11g Release 2 instant client instead. Since > Oracle 10g Release 1 is no longer supported the use of the Oracle 12c > Release 1 instant client should work perfectly for you. > > Anthony > > On Mon, Feb 27, 2017 at 9:22 AM, Chris Gould <chr...@to...> > wrote: > >> If you use the Oracle 12c driver (and the 12c InstantClient files) it >> should be backward compatible with earlier versions of the database. >> >> >> On 27 February 2017 at 16:12, Venky <ven...@gm...> wrote: >> >>> Hi Folks, >>> >>> Need you help. I wanted to automate few things for Oracle 10g using >>> python. >>> >>> So can you guys, help me locate the library for the same. Also, in near >>> future would be working on the same but with Oracle 12c. >>> >>> So do we have a single oracle lib for python which can work for all >>> oracle versions or do we have lib for oracle specific to versions? >>> >>> Anticipating your quick reply. >>> >>> >>> ~Venky >>> >>> ------------------------------------------------------------ >>> ------------------ >>> Check out the vibrant tech community on one of the world's most >>> engaging tech sites, SlashDot.org! http://sdm.link/slashdot >>> _______________________________________________ >>> cx-oracle-users mailing list >>> cx-...@li... >>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >>> >>> >> >> ------------------------------------------------------------ >> ------------------ >> Check out the vibrant tech community on one of the world's most >> engaging tech sites, SlashDot.org! http://sdm.link/slashdot >> _______________________________________________ >> cx-oracle-users mailing list >> cx-...@li... >> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >> >> > > ------------------------------------------------------------ > ------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, SlashDot.org! http://sdm.link/slashdot > _______________________________________________ > cx-oracle-users mailing list > cx-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > > -- Hi ~Venky |
|
From: Anthony T. <ant...@gm...> - 2017-02-27 17:20:00
|
If you use the Oracle 12c Release 1 instant client you can access an Oracle 10g Release 2 or higher database. Anything earlier than that would require the use of the Oracle 11g Release 2 instant client instead. Since Oracle 10g Release 1 is no longer supported the use of the Oracle 12c Release 1 instant client should work perfectly for you. Anthony On Mon, Feb 27, 2017 at 9:22 AM, Chris Gould <chr...@to...> wrote: > If you use the Oracle 12c driver (and the 12c InstantClient files) it > should be backward compatible with earlier versions of the database. > > > On 27 February 2017 at 16:12, Venky <ven...@gm...> wrote: > >> Hi Folks, >> >> Need you help. I wanted to automate few things for Oracle 10g using >> python. >> >> So can you guys, help me locate the library for the same. Also, in near >> future would be working on the same but with Oracle 12c. >> >> So do we have a single oracle lib for python which can work for all >> oracle versions or do we have lib for oracle specific to versions? >> >> Anticipating your quick reply. >> >> >> ~Venky >> >> ------------------------------------------------------------ >> ------------------ >> Check out the vibrant tech community on one of the world's most >> engaging tech sites, SlashDot.org! http://sdm.link/slashdot >> _______________________________________________ >> cx-oracle-users mailing list >> cx-...@li... >> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >> >> > > ------------------------------------------------------------ > ------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, SlashDot.org! http://sdm.link/slashdot > _______________________________________________ > cx-oracle-users mailing list > cx-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > > |
|
From: Chris G. <chr...@to...> - 2017-02-27 16:22:56
|
If you use the Oracle 12c driver (and the 12c InstantClient files) it should be backward compatible with earlier versions of the database. On 27 February 2017 at 16:12, Venky <ven...@gm...> wrote: > Hi Folks, > > Need you help. I wanted to automate few things for Oracle 10g using python. > > So can you guys, help me locate the library for the same. Also, in near > future would be working on the same but with Oracle 12c. > > So do we have a single oracle lib for python which can work for all oracle > versions or do we have lib for oracle specific to versions? > > Anticipating your quick reply. > > > ~Venky > > ------------------------------------------------------------ > ------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, SlashDot.org! http://sdm.link/slashdot > _______________________________________________ > cx-oracle-users mailing list > cx-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > > |
|
From: Venky <ven...@gm...> - 2017-02-27 16:14:19
|
I need for linux support. On Mon, Feb 27, 2017 at 9:42 PM, Venky <ven...@gm...> wrote: > Hi Folks, > > Need you help. I wanted to automate few things for Oracle 10g using python. > > So can you guys, help me locate the library for the same. Also, in near > future would be working on the same but with Oracle 12c. > > So do we have a single oracle lib for python which can work for all oracle > versions or do we have lib for oracle specific to versions? > > Anticipating your quick reply. > > > ~Venky > |
|
From: Venky <ven...@gm...> - 2017-02-27 16:12:23
|
Hi Folks, Need you help. I wanted to automate few things for Oracle 10g using python. So can you guys, help me locate the library for the same. Also, in near future would be working on the same but with Oracle 12c. So do we have a single oracle lib for python which can work for all oracle versions or do we have lib for oracle specific to versions? Anticipating your quick reply. ~Venky |
|
From: Derry H. <con...@de...> - 2017-02-27 13:17:52
|
Hi Anthony, I followed some of the points on SO and got it resolved (I updated my post). Thanks again! Derry. > Anthony Tuininga <ant...@gm...> hat am 23. Februar 2017 um 15:43 > geschrieben: > > > Hi Derry, > > It looks like you have a comprehensive answer on your Stack Overflow > question. If that doesn't help, let us know. > > Anthony > > On Thu, Feb 23, 2017 at 5:10 AM, Derry Holding <con...@de... > > wrote: > > > Hello, > > > > I'm wondering if you may be able to help me. I'm trying to install > > cx_Oracle and > > for some reason I'm not able to get it up an running. I've already posted > > something on Stackoverflow > > (http://stackoverflow.com/questions/42411600/installing- > > the-python-cx-oracle-module-in-windows-and-connecting-to-an-oracle-da) > > > > Kind regards, > > Derry. > > > > ------------------------------------------------------------ > > ------------------ > > Check out the vibrant tech community on one of the world's most > > engaging tech sites, SlashDot.org! http://sdm.link/slashdot > > _______________________________________________ > > cx-oracle-users mailing list > > cx-...@li... > > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > > |
|
From: Anthony T. <ant...@gm...> - 2017-02-23 14:43:40
|
Hi Derry, It looks like you have a comprehensive answer on your Stack Overflow question. If that doesn't help, let us know. Anthony On Thu, Feb 23, 2017 at 5:10 AM, Derry Holding <con...@de... > wrote: > Hello, > > I'm wondering if you may be able to help me. I'm trying to install > cx_Oracle and > for some reason I'm not able to get it up an running. I've already posted > something on Stackoverflow > (http://stackoverflow.com/questions/42411600/installing- > the-python-cx-oracle-module-in-windows-and-connecting-to-an-oracle-da) > > Kind regards, > Derry. > > ------------------------------------------------------------ > ------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, SlashDot.org! http://sdm.link/slashdot > _______________________________________________ > cx-oracle-users mailing list > cx-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > |
|
From: Derry H. <con...@de...> - 2017-02-23 12:29:26
|
Hello, I'm wondering if you may be able to help me. I'm trying to install cx_Oracle and for some reason I'm not able to get it up an running. I've already posted something on Stackoverflow (http://stackoverflow.com/questions/42411600/installing-the-python-cx-oracle-module-in-windows-and-connecting-to-an-oracle-da) Kind regards, Derry. |
|
From: Christopher J. <chr...@or...> - 2017-02-20 17:18:22
|
The intent is to make binaries available but the release is pending some "big-company, slow-wheels" legal and business reviews. This is out of Anthony's hands, so go easy on him! Chris On 20/2/17 9:04 pm, Jani Tiainen wrote: > Hard to tell really. > > This is latest word on 3.6: > > https://bitbucket.org/anthony_tuininga/cx_oracle/issues/45/next-release-planned > > On 20.02.2017 11:27, Marti Raudsepp wrote: >> On Thu, Feb 16, 2017 at 3:15 PM, Jani Tiainen <re...@gm...> wrote: >>> I think you only need to download Visual C++ 14 (2015) from Microsoft [1] >>> and Instant Client libs from Oracle [2]. Then you should be able to compile >>> it yourself. >> Thanks, but that didn't answer my question. Is there any hope to have >> official Windows binaries for Python 3.6 in PyPI like there are for >> earlier Python versions? >> >> Regards, >> Marti >> >> ------------------------------------------------------------------------------ >> Check out the vibrant tech community on one of the world's most >> engaging tech sites, SlashDot.org! http://sdm.link/slashdot >> _______________________________________________ >> cx-oracle-users mailing list >> cx-...@li... >> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > -- http://twitter.com/ghrd |
|
From: Jani T. <re...@gm...> - 2017-02-20 10:04:34
|
Hard to tell really. This is latest word on 3.6: https://bitbucket.org/anthony_tuininga/cx_oracle/issues/45/next-release-planned On 20.02.2017 11:27, Marti Raudsepp wrote: > On Thu, Feb 16, 2017 at 3:15 PM, Jani Tiainen <re...@gm...> wrote: >> I think you only need to download Visual C++ 14 (2015) from Microsoft [1] >> and Instant Client libs from Oracle [2]. Then you should be able to compile >> it yourself. > Thanks, but that didn't answer my question. Is there any hope to have > official Windows binaries for Python 3.6 in PyPI like there are for > earlier Python versions? > > Regards, > Marti > > ------------------------------------------------------------------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, SlashDot.org! http://sdm.link/slashdot > _______________________________________________ > cx-oracle-users mailing list > cx-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users -- Jani Tiainen |
|
From: Marti R. <ma...@ju...> - 2017-02-20 09:57:14
|
On Thu, Feb 16, 2017 at 3:15 PM, Jani Tiainen <re...@gm...> wrote: > I think you only need to download Visual C++ 14 (2015) from Microsoft [1] > and Instant Client libs from Oracle [2]. Then you should be able to compile > it yourself. Thanks, but that didn't answer my question. Is there any hope to have official Windows binaries for Python 3.6 in PyPI like there are for earlier Python versions? Regards, Marti |
|
From: Jani T. <re...@gm...> - 2017-02-16 13:15:18
|
I think you only need to download Visual C++ 14 (2015) from Microsoft [1] and Instant Client libs from Oracle [2]. Then you should be able to compile it yourself. Note that you need also SDK libs as well for Instant Client. [1] http://landinghub.visualstudio.com/visual-cpp-build-tools [2] http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html On 16.02.2017 14:34, Marti Raudsepp wrote: > Hi! > > Python 3.6.0 has been out for a while now and I've been successfully > using it with cx_Oracle on macOS and Linux. > > However, PyPI is still missing Windows packages for cx_Oracle: > https://pypi.python.org/pypi/cx_Oracle > > Can someone please build new binaries for Windows or give some > indication when they might be expected? > > Regards, > Marti Raudsepp > > > > ------------------------------------------------------------------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, SlashDot.org! http://sdm.link/slashdot > > > _______________________________________________ > cx-oracle-users mailing list > cx-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users -- Jani Tiainen |
|
From: Marti R. <ma...@ju...> - 2017-02-16 12:59:11
|
Hi! Python 3.6.0 has been out for a while now and I've been successfully using it with cx_Oracle on macOS and Linux. However, PyPI is still missing Windows packages for cx_Oracle: https://pypi.python.org/pypi/cx_Oracle Can someone please build new binaries for Windows or give some indication when they might be expected? Regards, Marti Raudsepp |
|
From: Pavel S. <pav...@ho...> - 2016-11-22 07:44:48
|
Hi everybody,
I been trying to use cx_Oracle with the newest gettype feature together with "executemany" function (version 5.2.1 built from the bitbucket repository). For some reason after creating around 1000 objects (stored in a list) the performance start to degrade, taking approximate half of a second to create a single object, I am not sure what is the reason behind this behavior.
Below is code I try to execute:
#------------------------------------------------------------------------------
# InsertGeometry.py
# This script demonstrates the ability to create Oracle objects (this example
# uses SDO_GEOMETRY) and insert them into a table.
#------------------------------------------------------------------------------
from __future__ import print_function
from random import randint
import cx_Oracle
import time
# create and populate Oracle objects
connection = cx_Oracle.Connection('[your db here]')
#print(connection)
#print(dir(connection))
# create table, if necessary
cursor = connection.cursor()
cursor.execute("""
select count(*)
from user_tables
where table_name = 'TESTGEOMETRY2'""")
count, = cursor.fetchone()
if count == 0:
print("Creating table...")
cursor.execute("""
create table TestGeometry2 (
IntCol number(9) not null,
Geometry SDO_GEOMETRY not null
)""")
# remove all existing rows and then add a new one
print("Removing any existing rows...")
cursor.execute("delete from TestGeometry2")
print("Adding row to table...")
geometries = []
typeObj = connection.gettype("MDSYS.SDO_GEOMETRY")
elementInfoTypeObj = connection.gettype("MDSYS.SDO_ELEM_INFO_ARRAY")
ordinateTypeObj = connection.gettype("MDSYS.SDO_ORDINATE_ARRAY")
start_time = time.time()
for i in xrange(0, 4000):
print(i)
ordinates = [randint(1,9) for t in xrange(0, 30)]
geom = typeObj.newobject()
geom.SDO_GTYPE = 2003
geom.SDO_ELEM_INFO = elementInfoTypeObj.newobject()
geom.SDO_ELEM_INFO.extend([1, 1003, 3])
geom.SDO_ORDINATES = ordinateTypeObj.newobject()
geom.SDO_ORDINATES.extend(ordinates)
geometries.append((i, geom))
cursor.executemany("insert into TestGeometry2 values (:1, :2)", geometries)
connection.commit()
elapsed_time = (time.time() - start_time)
print(elapsed_time)
print("Success!")
Thanks,
Pavel Simo
|
|
From: Codiga, D. <Dan...@mw...> - 2016-11-14 15:35:20
|
Ok... to wrap this up now. I have it working. I found https://anaconda.org/dhirschfeld/cx_oracle and added that channel to my environment.yml file, with the cx_Oracle dependency. (That's easier and seems more efficient than doing the installation on my machine myself using what I found at https://pypi.python.org/pypi/cx_Oracle/5.2.1 .) Now, conda finds and installs cx_Oracle 5.2.1 with python 3.5, instead of giving me the conflict error. So I'm no longer limited to using python 3.4. Note that using this additional channel is a workaround, because conda-forge doesn't yet include cx_Oracle 5.2.1-a colleague indicates adding it to conda-forge is in the works. So I am all set for now. Thank you for your help and suggestions. From: Codiga, Daniel Sent: Wednesday, November 09, 2016 3:18 PM To: 'cx-...@li...' Subject: RE: anaconda python 3.5 + windows 7 + cx_Oracle 5.2? Thanks for the suggestions. An update now. Because I was not the person who configured my PC for the existing cx_Oracle 5.1.2 that I have used successfully in Python 2.7, I did not realize there was more to installing/configuring it than just including cx_Oracle in my environment.yml file; the latter step I had done but the other steps prior to that were done by others. Now, I have learned that to get this working I need to have (at least) these elements in place with the properly aligned versions: a. Python b. cx_Oracle c. The client/driver version ... and that I need to put that final one on to the path. ( Is there a good set of step by step instructions for how to do this? If so please point me to it. I did a lot of searching around and found lots specifically about cx_Oracle's functionality, but not so much-basically some third-party blog posts-- in terms of the needed steps to fully install/configure all the elements needed to get it working. ) So... my Oracle version is 11g (11.2.0.4.0) and I downloaded the instantclient_11_2 from the Oracle website and added it to my path. Now, when I create an anaconda environment with python=3.4 and include cx_Oracle in it, all goes well, and I can successfully open a connection to the database-within that new environment, in Python 3.4.5. So that is progress for sure. I would ideally be able to do this in Python 3.5 as well as 3.4 though. And when I try (by creating an environment using python=3.5 and including cx_Oracle as a dependency in environment.yml) I still get the "specifications were found to be in conflict" error ( " - cx_oracle -> python 2.7*|3.4* and - python 3.5* "), just like before, and the environment does not get created successfully. Does this mean I have to install cx_Oracle (i.e. part b above) myself-- instead of (or in addition to) asking for it to be included as a dependency in my environment.yml file and hoping conda will find and install the proper version? When I do "conda info cx_Oracle" I get listings for: cx_oracle 5.1.2 py2.7_0 cx_oracle 5.1.2 py2.7_1 cx_oracle 5.2 py3.4 but py3.5 is not included. So it seemed like maybe I needed to download and install cx_Oracle from https://pypi.python.org/pypi/cx_Oracle/5.2.1 ? If so, it seems like Anaconda is not able to find and install 3.5 for me as part of an environment. Suggestions, advice? From: Codiga, Daniel Sent: Tuesday, November 08, 2016 11:14 AM To: 'cx-...@li...' Subject: RE: anaconda python 3.5 + windows 7 + cx_Oracle 5.2? To be a little more complete regarding my final comment, ... When I create the environment using python 3.4, it appears that cx_Oracle 5.2 has been installed successfully (according to Anaconda Navigator, at least). Then when I try "import cx_Oracle" the problem is not exactly that it can't find the win32 file; the error message is this: ImportError: DLL load failed: %1 is not a valid Win32 application. From: Codiga, Daniel Sent: Monday, November 07, 2016 3:55 PM To: 'cx-...@li...' Subject: anaconda python 3.5 + windows 7 + cx_Oracle 5.2? >From what I have read in the documentation, it looks like I should be able to install anaconda python 3.5 on my windows 7 64-bit PC and include cx_Oracle 5.2 in a conda virtual environment. However I am encountering problems in trying. ( Previously I was using Anaconda python 2.7 with cx_Oracle 5.1.2 in a conda environment without trouble. I mention this because it seems possible that my problems are associated with not fully/successfully uninstalling cx_Oracle 5.1.2? Just a thought.) Anyway I do a clean wipe of python from my system and then install Miniconda (64 bit windows) and all is well. I then try to create an environment "conda env create environment.yml" -- with "python=3.5" and "cx_Oracle" both listed as dependencies in the environment.yml file-- and get the "specifications were found to be in conflict" error. It says " - cx_oracle -> python 2.7*|3.4*" and " - python 3.5*". So then, to troubleshoot a little, I try same but with "python=3.4" in the environment.yml file. The environment gets created ok. But when I try "import cx_Oracle" I get an error saying it couldn't find the win32 file. Suggestions? |
|
From: James C. M. <Jam...@or...> - 2016-11-09 20:45:03
|
Hi Daniel, Yes, you need to bump cx_Oracle to 5.2.1 - the first line of the release notes for that version states https://cx-oracle.readthedocs.io/en/latest/releasenotes.html Version 5.2.1 Added support for Python 3.5. James On 10/11/16 06:17 am, Codiga, Daniel wrote: > Thanks for the suggestions. An update now. > > > > Because I was not the person who configured my PC for the existing > cx_Oracle 5.1.2 that I have used successfully in Python 2.7, I did not > realize there was more to installing/configuring it than just including > cx_Oracle in my environment.yml file; the latter step I had done but the > other steps prior to that were done by others. > > > > Now, I have learned that to get this working I need to have (at least) > these elements in place with the properly aligned versions: > > a. Python > > b. cx_Oracle > > c. The client/driver version > > … and that I need to put that final one on to the path. > > > > ( Is there a good set of step by step instructions for how to do this? If > so please point me to it. I did a lot of searching around and found lots > specifically about cx_Oracle’s functionality, but not so much—basically > some third-party blog posts-- in terms of the needed steps to fully > install/configure all the elements needed to get it working. ) > > > > So… my Oracle version is 11g (11.2.0.4.0) and I downloaded the > instantclient_11_2 from the Oracle website and added it to my path. Now, > when I create an anaconda environment with python=3.4 and include > cx_Oracle in it, all goes well, and I can successfully open a connection > to the database—within that new environment, in Python 3.4.5. So that is > progress for sure. > > > > I would ideally be able to do this in Python 3.5 as well as 3.4 though. > And when I try (by creating an environment using python=3.5 and including > cx_Oracle as a dependency in environment.yml) I still get the > “specifications were found to be in conflict” error ( “ – cx_oracle -> > python 2.7*|3.4* and – python 3.5* “), just like before, and the > environment does not get created successfully. > > > > Does this mean I have to install cx_Oracle (i.e. part b above) myself-- > instead of (or in addition to) asking for it to be included as a > dependency in my environment.yml file and hoping conda will find and > install the proper version? > > > > When I do “conda info cx_Oracle” I get listings for: > > > > cx_oracle 5.1.2 py2.7_0 > > cx_oracle 5.1.2 py2.7_1 > > cx_oracle 5.2 py3.4 > > > > but py3.5 is not included. So it seemed like maybe I needed to download > and install cx_Oracle from https://pypi.python.org/pypi/cx_Oracle/5.2.1 ? > > > > If so, it seems like Anaconda is not able to find and install 3.5 for me > as part of an environment. > > > > Suggestions, advice? > > > > *From:*Codiga, Daniel > *Sent:* Tuesday, November 08, 2016 11:14 AM > *To:* 'cx-...@li...' > *Subject:* RE: anaconda python 3.5 + windows 7 + cx_Oracle 5.2? > > > > To be a little more complete regarding my final comment, … > > > > When I create the environment using python 3.4, it appears that cx_Oracle > 5.2 has been installed successfully (according to Anaconda Navigator, at > least). Then when I try “import cx_Oracle” the problem is not exactly that > it can’t find the win32 file; the error message is this: > > > > ImportError: DLL load failed: %1 is not a valid Win32 application. > > > > > > > > *From:*Codiga, Daniel > *Sent:* Monday, November 07, 2016 3:55 PM > *To:* 'cx-...@li...' > *Subject:* anaconda python 3.5 + windows 7 + cx_Oracle 5.2? > > > > From what I have read in the documentation, it looks like I should be able > to install anaconda python 3.5 on my windows 7 64-bit PC and include > cx_Oracle 5.2 in a conda virtual environment. > > > > However I am encountering problems in trying. > > > > ( Previously I was using Anaconda python 2.7 with cx_Oracle 5.1.2 in a > conda environment without trouble. I mention this because it seems > possible that my problems are associated with not fully/successfully > uninstalling cx_Oracle 5.1.2? Just a thought.) > > > > Anyway I do a clean wipe of python from my system and then install > Miniconda (64 bit windows) and all is well. I then try to create an > environment “conda env create environment.yml” -- with “python=3.5” and > “cx_Oracle” both listed as dependencies in the environment.yml file-- and > get the “specifications were found to be in conflict” error. It says “ – > cx_oracle -> python 2.7*|3.4*” and “ – python 3.5*”. > > > > So then, to troubleshoot a little, I try same but with “python=3.4” in the > environment.yml file. The environment gets created ok. But when I try > “import cx_Oracle” I get an error saying it couldn’t find the win32 file. > > > > Suggestions? > > > > > > > > ------------------------------------------------------------------------------ > Developer Access Program for Intel Xeon Phi Processors > Access to Intel Xeon Phi processor-based developer platforms. > With one year of Intel Parallel Studio XE. > Training and support from Colfax. > Order your platform today. http://sdm.link/xeonphi > > > > _______________________________________________ > cx-oracle-users mailing list > cx-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > -- James C. McPherson -- Oracle Systems / Solaris / Core https://www.jmcpdotcom.com/blog |
|
From: Codiga, D. <Dan...@mw...> - 2016-11-09 20:17:45
|
Thanks for the suggestions. An update now. Because I was not the person who configured my PC for the existing cx_Oracle 5.1.2 that I have used successfully in Python 2.7, I did not realize there was more to installing/configuring it than just including cx_Oracle in my environment.yml file; the latter step I had done but the other steps prior to that were done by others. Now, I have learned that to get this working I need to have (at least) these elements in place with the properly aligned versions: a. Python b. cx_Oracle c. The client/driver version ... and that I need to put that final one on to the path. ( Is there a good set of step by step instructions for how to do this? If so please point me to it. I did a lot of searching around and found lots specifically about cx_Oracle's functionality, but not so much-basically some third-party blog posts-- in terms of the needed steps to fully install/configure all the elements needed to get it working. ) So... my Oracle version is 11g (11.2.0.4.0) and I downloaded the instantclient_11_2 from the Oracle website and added it to my path. Now, when I create an anaconda environment with python=3.4 and include cx_Oracle in it, all goes well, and I can successfully open a connection to the database-within that new environment, in Python 3.4.5. So that is progress for sure. I would ideally be able to do this in Python 3.5 as well as 3.4 though. And when I try (by creating an environment using python=3.5 and including cx_Oracle as a dependency in environment.yml) I still get the "specifications were found to be in conflict" error ( " - cx_oracle -> python 2.7*|3.4* and - python 3.5* "), just like before, and the environment does not get created successfully. Does this mean I have to install cx_Oracle (i.e. part b above) myself-- instead of (or in addition to) asking for it to be included as a dependency in my environment.yml file and hoping conda will find and install the proper version? When I do "conda info cx_Oracle" I get listings for: cx_oracle 5.1.2 py2.7_0 cx_oracle 5.1.2 py2.7_1 cx_oracle 5.2 py3.4 but py3.5 is not included. So it seemed like maybe I needed to download and install cx_Oracle from https://pypi.python.org/pypi/cx_Oracle/5.2.1 ? If so, it seems like Anaconda is not able to find and install 3.5 for me as part of an environment. Suggestions, advice? From: Codiga, Daniel Sent: Tuesday, November 08, 2016 11:14 AM To: 'cx-...@li...' Subject: RE: anaconda python 3.5 + windows 7 + cx_Oracle 5.2? To be a little more complete regarding my final comment, ... When I create the environment using python 3.4, it appears that cx_Oracle 5.2 has been installed successfully (according to Anaconda Navigator, at least). Then when I try "import cx_Oracle" the problem is not exactly that it can't find the win32 file; the error message is this: ImportError: DLL load failed: %1 is not a valid Win32 application. From: Codiga, Daniel Sent: Monday, November 07, 2016 3:55 PM To: 'cx-...@li...' Subject: anaconda python 3.5 + windows 7 + cx_Oracle 5.2? >From what I have read in the documentation, it looks like I should be able to install anaconda python 3.5 on my windows 7 64-bit PC and include cx_Oracle 5.2 in a conda virtual environment. However I am encountering problems in trying. ( Previously I was using Anaconda python 2.7 with cx_Oracle 5.1.2 in a conda environment without trouble. I mention this because it seems possible that my problems are associated with not fully/successfully uninstalling cx_Oracle 5.1.2? Just a thought.) Anyway I do a clean wipe of python from my system and then install Miniconda (64 bit windows) and all is well. I then try to create an environment "conda env create environment.yml" -- with "python=3.5" and "cx_Oracle" both listed as dependencies in the environment.yml file-- and get the "specifications were found to be in conflict" error. It says " - cx_oracle -> python 2.7*|3.4*" and " - python 3.5*". So then, to troubleshoot a little, I try same but with "python=3.4" in the environment.yml file. The environment gets created ok. But when I try "import cx_Oracle" I get an error saying it couldn't find the win32 file. Suggestions? |
31 messages has been excluded from this view by a project administrator.
