Re: python for oracle 10g/12c

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 <[email protected]> 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 <
> <[email protected]>[email protected]> 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 < <[email protected]>
>> [email protected]> 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 < <[email protected]>
>>> [email protected]> 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-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
>>>> 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-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
>>> 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-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
>> 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 listcx-oracle-users-5NWGOfrQmneRv+LV9MX5ugtCRVl27V+i0wdF1cv0I5s@public.gmane.org://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-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
> 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-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users