import cx_Oracle

[GrayGeek]

Waldemar Osuch wrote:

> GrayGeek <jkrepsBEAR at FISHneb.rr.com> wrote in message
> news:<PqDpb.109407$%C5.82494 at twister.rdc-kc.rr.com>...
>> Andy Todd wrote:
>> 
>> > GrayGeek wrote:
>> > 
>> >> Uwe Hoffmann wrote:
>> >> 
>> >> 
>> >>>GrayGeek wrote:
>> >>>
>> >>>>Bernard Delmée wrote:
>> >>>>
>> >>>>
>> >>>>
>> >>>>>>It gives me an error about being unable to find the OCISetDefault
>> >>>>>>entry point in 'oci.dll'.
>> >>>>>
>> >>>>>cx_Oracle works on top of the regular oracle client, which you'll
>> >>>>>need to install before it works. The OCI libraries are
>> >>>>>parOCISetDefault t of that.
>> >>>>
>> >>>>
>> >>>>I have it installed, and have used it to create webpages using
>> >>>>Oracle's HTP.P function, and I also accessed tables on the Oracle9
>> >>>>server from JDev9
>> >>>>and from PLSQLDeveloper.   The oci.dll is in the Oracle Home/dll
>> >>>>directory. As my first post indicated, cx_Oracle is able to see
>> >>>>oci.dll, it just can't communicate with it properly.
>> >>>>???
>> >>>
>> >>>  i think that the binaries were built against another version of
>> >>>  oracle. i had a similar problem with DCOracle2 (versions 8.0.5 vs.
>> >>>  8.1.7 or
>> >>>7.3.3 vs. 8.0.5).
>> >>>  As far as i remember OCISetDefault was one of the problematic
>> >>>  symbols.
>> >> 
>> >> 
>> >> I'm hoping that we can switch from Java to Python but since we are
>> >> standardizing on Oracle having a reliable Python connection to Oracle
>> >> 9i is
>> >> important.   mmm... Maybe I can use PostgreSQL for a proof of
>> >> concept...
>> > 
>> > Is $ORACLE_HOME/bin on your path? This is how cx_Oracle picks up the
>> > oci.dll. Its not necessary for the Oracle toolks like JDeveloper and
>> > SQL*Plus, but its essential for third party tools.
>> 
>> Yes.  cx_Oracle has no problem finding oci.dll, it just can find the
>> right 'entry point'.
>> 
>> > 
>> > You don't mention which version of Oracle you are using. There are
>> > binaries for either Oracle 8i or 9i with Python 2.2 on the home page
>> > (http://www.computronix.com/utilities.shtml#Oracle) but they won't work
>> > with earlier versions of Oracle. Although, with a bit of luck and a
>> > following wind the 8i binary can be used to access a 9i database (it
>> > just can't do anything with the new features). But on the whole you
>> > will be better off getting the appropriate driver for your database
>> > version.
>> 
>> I started using Python 2.3 and when I ran into this problem my first tack
>> was to remove Python 2.3 and revert to Python 2.2, but Python 2.2 shows
>> the
>> same problem.  We use both Oracle 8i and Oracle 9i.  I am attempting to
>> connect to my Oracle 9i database.  I have tried both binaries and the
>> "import cx_Oracle" dies in both using Python 2.2 against Oracle 9i.
> 
> I had similar problem once on a machine with two Oracle installations.
> cx_Oracle was finding oci.dll all right but it was the wrong one.
> When I found a machine with only one version of Oracle the problem
> went away.
> After this hurdle was over I had nothing but positive impressions from
> using cx_Oracle module.
> 
> waldemar

mmm... the only Oracle onnection on my box is for the 9i database.

-- 

-
GrayGeek