cx-oracle-users — Primary discussion list for users (and developers) of cx_Oracle

Re: [cx-oracle-users] oracle 10g support

[Anthony T. <an...@co...>]

Oracle 10g is definitely supported. I simply haven't provided binaries 
yet -- you'll have to build it yourself. I have only built cx_Oracle for 
10g on Linux (where it works just fine) but don't have access to a 
Windows box running Oracle 10g just yet. Does that answer your question?

Zed Lopez wrote:
> Hi,
> 
> I'm working on advocating the use of Python for a large project at
> work and something that could be a deal-breaker is whether there's
> support for a direct (non-ODBC) connection to Oracle 10g. Could anyone
> please tell me whether there are plans for a 10g version of cx-oracle?
> 
> Thanks.
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by: IT Product Guide on ITManagersJournal
> Use IT products in your business? Tell us what you think of them. Give us
> Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more
> http://productguide.itmanagersjournal.com/guidepromo.tmpl
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

-- 
Anthony Tuininga
an...@co...

Computronix
Distinctive Software. Real People.
Suite 200, 10216 - 124 Street NW
Edmonton, AB, Canada  T5N 4A3
Phone:	(780) 454-3700
Fax:	(780) 454-3838
http://www.computronix.com

[cx-oracle-users] oracle 10g support

[Zed L. <zed...@gm...>]

Hi,

I'm working on advocating the use of Python for a large project at
work and something that could be a deal-breaker is whether there's
support for a direct (non-ODBC) connection to Oracle 10g. Could anyone
please tell me whether there are plans for a 10g version of cx-oracle?

Thanks.

Re: [cx-oracle-users] OCI.DLL cannot be found ?

[Anthony T. <an...@co...>]

Correct. 9.0.1 does not have the procedure OCISessionGet() or many of 
the other features that make 9i what it is. Oracle has also stated that 
users of 9.0.1 should upgrade in favor of 9.2.0 since 9.0.1 is no longer 
supported (or won't be soon -- I can't remember which).

The use of the 8i version works on Windows only. On Unix where the name 
of the shared library changes on major versions a recompile is necessary.

The documentation says 9.2 instead of simply "9i" but only in passing so 
perhaps this should be more obviously stated. That said, you are only 
the second person that has been bitten by this "discrepancy". :-)

Philip SION wrote:
> OK so just for curiosity :
> 
> According to windows file properties, the version of my 
> c:\oracle\ora9i\bin\oci.dll is 9.0.1.1.1
> 
> It is the version which DOESN'T work with cx_Oracle-4.0.1-win32-9i-py23 
> but which WORKS with cx_Oracle-4.0.1-win32-8i-py23.
> 
> Normal ?
> 
> Philip.
> 
> Anthony Tuininga wrote:
> 
>> Interesting. What client version are you using, exactly? You wouldn't 
>> happen to be using 9.0.1, would you? The 9i version of cx_Oracle will 
>> not work with an 8i client at all but it should work with a 9i client 
>> -- we've never noticed otherwise, anyway. Regardless, if you have it 
>> working now, no need to continue this thread except from curiousity, 
>> of course! ;-)
>>
>> Philip SION wrote:
>>
>>> Sorry but no :-(
>>>
>>> cx_Oracle-4.0.1-win32-9i-py23 did'nt work with either the 9i or 81 
>>> version of oci.dll, and cx_Oracle-4.0.1-win32-8i-py23 works with both 
>>> 9i and 81 version of the DLL...
>>> (I switch from one DLL to the other by renaming the one I don't want 
>>> to Aci.dll).
>>>
>>> So I will go on like this for the moment...
>>>
>>> Thanks,
>>>
>>> Philip.
>>>
>>> Anthony Tuininga wrote:
>>>
>>>> This is definitely an Oracle client issue -- the server software is 
>>>> irrelevant, actually. In general, make sure that if you are running 
>>>> Oracle 8i on the client you are using the Oracle 8i version of 
>>>> cx_Oracle and if you are running Oracle 9i on the client make sure 
>>>> you are using the Oracle 9i version of cx_Oracle. As mentioned 
>>>> earlier, the only exception is Oracle 9.0.1 which doesn't have the 
>>>> required procedure. Make sense?
>>>>
>>>> Nik Barron wrote:
>>>>
>>>>>> c) With cx_Oracle-4.0.1-win32-9i-py23.exe uninstalled and 
>>>>>> cx_Oracle-4.0.1-win32-8i-py23.exe installed back, oracle9i (or 
>>>>>> 81)/bin/aci.dll renamed to the right name, everything runs fine.
>>>>>>
>>>>>> Finally, am I using oracle 9i or 81 ??? It depends on the DLL I 
>>>>>> left on the machine ? Or is it the cx_oracle version which rules ?
>>>>>>   
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> It's complicated. It appears to depend on both the server and client
>>>>> versions installed. I had to recompile cx_Oracle for one of our
>>>>> configurations (8i client/server) although foolishly didn't write 
>>>>> down the
>>>>> step by step process (but it was pretty much in line with the docs I
>>>>> recall).
>>>>>
>>>>> This is more of an Oracle issue than cx_oracle I think; I've had 
>>>>> similar
>>>>> problems with a number of client-side tools that interact with Oracle
>>>>> directly, often having to swap ORACLE_HOME according to which 
>>>>> specific tool
>>>>> was being used!
>>>>>
>>>>> Nick Barron
>>>>>
>>>>>
>>>>> -------------------------------------------------------
>>>>> This SF.net email is sponsored by: IT Product Guide on 
>>>>> ITManagersJournal
>>>>> Use IT products in your business? Tell us what you think of them. 
>>>>> Give us
>>>>> Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find 
>>>>> out more
>>>>> http://productguide.itmanagersjournal.com/guidepromo.tmpl
>>>>> _______________________________________________
>>>>> cx-oracle-users mailing list
>>>>> cx-...@li...
>>>>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>>>>>  
>>>>>
>>>>
>>>>
>>>> -------------------------------------------------------
>>>> This SF.net email is sponsored by: IT Product Guide on 
>>>> ITManagersJournal
>>>> Use IT products in your business? Tell us what you think of them. 
>>>> Give us
>>>> Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find 
>>>> out more
>>>> http://productguide.itmanagersjournal.com/guidepromo.tmpl
>>>> _______________________________________________
>>>> cx-oracle-users mailing list
>>>> cx-...@li...
>>>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>>>>
>>>
>>>
>>>
>>> -------------------------------------------------------
>>> This SF.net email is sponsored by: IT Product Guide on ITManagersJournal
>>> Use IT products in your business? Tell us what you think of them. 
>>> Give us
>>> Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find 
>>> out more
>>> http://productguide.itmanagersjournal.com/guidepromo.tmpl
>>> _______________________________________________
>>> cx-oracle-users mailing list
>>> cx-...@li...
>>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>>
>>
>>
>>
>>
>> -------------------------------------------------------
>> This SF.net email is sponsored by: IT Product Guide on ITManagersJournal
>> Use IT products in your business? Tell us what you think of them. Give us
>> Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out 
>> more
>> http://productguide.itmanagersjournal.com/guidepromo.tmpl
>> _______________________________________________
>> cx-oracle-users mailing list
>> cx-...@li...
>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>>
> 
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by: IT Product Guide on ITManagersJournal
> Use IT products in your business? Tell us what you think of them. Give us
> Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more
> http://productguide.itmanagersjournal.com/guidepromo.tmpl
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

-- 
Anthony Tuininga
an...@co...

Computronix
Distinctive Software. Real People.
Suite 200, 10216 - 124 Street NW
Edmonton, AB, Canada  T5N 4A3
Phone:	(780) 454-3700
Fax:	(780) 454-3838
http://www.computronix.com

Re: [cx-oracle-users] Query about executing SQLPLUS commands

[Jean-François G. <jf...@ne...>]

Message d'origine (07:45 07/10/2004 -0600) :
>No. However, I have another project hosted at http://starship.python.net/crew/atuining (cx_OracleTools) which has a tool called DescribeObject which uses cx_Oracle which does what you are looking for.

cursor.description gives a brief description of columns of the request.

If the request is "select * from ...", we obtain a subset of DESCR TABLE result.

Re: [cx-oracle-users] Query about executing SQLPLUS commands

[Anthony T. <an...@co...>]

No. However, I have another project hosted at 
http://starship.python.net/crew/atuining (cx_OracleTools) which has a 
tool called DescribeObject which uses cx_Oracle which does what you are 
looking for.

tim...@in... wrote:
> 
> 
> Hi,
> 
>  
> 
> Is it possible via cx_Oracle to execute something like DESC <TABLE_NAME> 
> to retrieve the format of a table?
> 
>  
> 
> Cheers
> 
> Tim.
> 
> This e-mail and any attachments are confidential and may also be legally 
> privileged and/or copyright material of Intec Telecom Systems PLC (or 
> its affiliated companies). If you are not an intended or authorised 
> recipient of this e-mail or have received it in error, please delete it 
> immediately and notify the sender by e-mail. In such a case, reading, 
> reproducing, printing or further dissemination of this e-mail or its 
> contents is strictly prohibited and may be unlawful.
> 
> Intec Telecom Systems PLC does not represent or warrant that an 
> attachment hereto is free from computer viruses or other defects. The 
> opinions expressed in this e-mail and any attachments may be those of 
> the author and are not necessarily those of Intec Telecom Systems PLC.
> 

-- 
Anthony Tuininga
an...@co...

Computronix
Distinctive Software. Real People.
Suite 200, 10216 - 124 Street NW
Edmonton, AB, Canada  T5N 4A3
Phone:	(780) 454-3700
Fax:	(780) 454-3838
http://www.computronix.com

[cx-oracle-users] Query about executing SQLPLUS commands

[<tim...@in...>]

Hi,

 

Is it possible via cx_Oracle to execute something like DESC <TABLE_NAME> to
retrieve the format of a table?

 

Cheers

Tim.



This e-mail and any attachments are confidential and may also be legally privileged and/or copyright material of Intec Telecom Systems PLC (or its affiliated companies). If you are not an intended or authorised recipient of this e-mail or have received it in error, please delete it immediately and notify the sender by e-mail. In such a case, reading, reproducing, printing or further dissemination of this e-mail or its contents is strictly prohibited and may be unlawful. 

Intec Telecom Systems PLC does not represent or warrant that an attachment hereto is free from computer viruses or other defects. The opinions expressed in this e-mail and any attachments may be those of the author and are not necessarily those of Intec Telecom Systems PLC.

Re: [cx-oracle-users] OCI.DLL cannot be found ?

[Philip S. <phi...@cg...>]

OK so just for curiosity :

According to windows file properties, the version of my 
c:\oracle\ora9i\bin\oci.dll is 9.0.1.1.1

It is the version which DOESN'T work with cx_Oracle-4.0.1-win32-9i-py23 
but which WORKS with cx_Oracle-4.0.1-win32-8i-py23.

Normal ?

Philip.

Anthony Tuininga wrote:
> Interesting. What client version are you using, exactly? You wouldn't 
> happen to be using 9.0.1, would you? The 9i version of cx_Oracle will 
> not work with an 8i client at all but it should work with a 9i client -- 
> we've never noticed otherwise, anyway. Regardless, if you have it 
> working now, no need to continue this thread except from curiousity, of 
> course! ;-)
> 
> Philip SION wrote:
> 
>> Sorry but no :-(
>>
>> cx_Oracle-4.0.1-win32-9i-py23 did'nt work with either the 9i or 81 
>> version of oci.dll, and cx_Oracle-4.0.1-win32-8i-py23 works with both 
>> 9i and 81 version of the DLL...
>> (I switch from one DLL to the other by renaming the one I don't want 
>> to Aci.dll).
>>
>> So I will go on like this for the moment...
>>
>> Thanks,
>>
>> Philip.
>>
>> Anthony Tuininga wrote:
>>
>>> This is definitely an Oracle client issue -- the server software is 
>>> irrelevant, actually. In general, make sure that if you are running 
>>> Oracle 8i on the client you are using the Oracle 8i version of 
>>> cx_Oracle and if you are running Oracle 9i on the client make sure 
>>> you are using the Oracle 9i version of cx_Oracle. As mentioned 
>>> earlier, the only exception is Oracle 9.0.1 which doesn't have the 
>>> required procedure. Make sense?
>>>
>>> Nik Barron wrote:
>>>
>>>>> c) With cx_Oracle-4.0.1-win32-9i-py23.exe uninstalled and 
>>>>> cx_Oracle-4.0.1-win32-8i-py23.exe installed back, oracle9i (or 
>>>>> 81)/bin/aci.dll renamed to the right name, everything runs fine.
>>>>>
>>>>> Finally, am I using oracle 9i or 81 ??? It depends on the DLL I 
>>>>> left on the machine ? Or is it the cx_oracle version which rules ?
>>>>>   
>>>>
>>>>
>>>>
>>>>
>>>> It's complicated. It appears to depend on both the server and client
>>>> versions installed. I had to recompile cx_Oracle for one of our
>>>> configurations (8i client/server) although foolishly didn't write 
>>>> down the
>>>> step by step process (but it was pretty much in line with the docs I
>>>> recall).
>>>>
>>>> This is more of an Oracle issue than cx_oracle I think; I've had 
>>>> similar
>>>> problems with a number of client-side tools that interact with Oracle
>>>> directly, often having to swap ORACLE_HOME according to which 
>>>> specific tool
>>>> was being used!
>>>>
>>>> Nick Barron
>>>>
>>>>
>>>> -------------------------------------------------------
>>>> This SF.net email is sponsored by: IT Product Guide on 
>>>> ITManagersJournal
>>>> Use IT products in your business? Tell us what you think of them. 
>>>> Give us
>>>> Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find 
>>>> out more
>>>> http://productguide.itmanagersjournal.com/guidepromo.tmpl
>>>> _______________________________________________
>>>> cx-oracle-users mailing list
>>>> cx-...@li...
>>>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>>>>  
>>>>
>>>
>>>
>>> -------------------------------------------------------
>>> This SF.net email is sponsored by: IT Product Guide on ITManagersJournal
>>> Use IT products in your business? Tell us what you think of them. 
>>> Give us
>>> Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find 
>>> out more
>>> http://productguide.itmanagersjournal.com/guidepromo.tmpl
>>> _______________________________________________
>>> cx-oracle-users mailing list
>>> cx-...@li...
>>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>>>
>>
>>
>>
>> -------------------------------------------------------
>> This SF.net email is sponsored by: IT Product Guide on ITManagersJournal
>> Use IT products in your business? Tell us what you think of them. Give us
>> Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out 
>> more
>> http://productguide.itmanagersjournal.com/guidepromo.tmpl
>> _______________________________________________
>> cx-oracle-users mailing list
>> cx-...@li...
>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
> 
> 
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by: IT Product Guide on ITManagersJournal
> Use IT products in your business? Tell us what you think of them. Give us
> Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more
> http://productguide.itmanagersjournal.com/guidepromo.tmpl
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
> 

Re: [cx-oracle-users] OCI.DLL cannot be found ?

[Anthony T. <an...@co...>]

Interesting. What client version are you using, exactly? You wouldn't 
happen to be using 9.0.1, would you? The 9i version of cx_Oracle will 
not work with an 8i client at all but it should work with a 9i client -- 
we've never noticed otherwise, anyway. Regardless, if you have it 
working now, no need to continue this thread except from curiousity, of 
course! ;-)

Philip SION wrote:

> Sorry but no :-(
>
> cx_Oracle-4.0.1-win32-9i-py23 did'nt work with either the 9i or 81 
> version of oci.dll, and cx_Oracle-4.0.1-win32-8i-py23 works with both 
> 9i and 81 version of the DLL...
> (I switch from one DLL to the other by renaming the one I don't want 
> to Aci.dll).
>
> So I will go on like this for the moment...
>
> Thanks,
>
> Philip.
>
> Anthony Tuininga wrote:
>
>> This is definitely an Oracle client issue -- the server software is 
>> irrelevant, actually. In general, make sure that if you are running 
>> Oracle 8i on the client you are using the Oracle 8i version of 
>> cx_Oracle and if you are running Oracle 9i on the client make sure 
>> you are using the Oracle 9i version of cx_Oracle. As mentioned 
>> earlier, the only exception is Oracle 9.0.1 which doesn't have the 
>> required procedure. Make sense?
>>
>> Nik Barron wrote:
>>
>>>> c) With cx_Oracle-4.0.1-win32-9i-py23.exe uninstalled and 
>>>> cx_Oracle-4.0.1-win32-8i-py23.exe installed back, oracle9i (or 
>>>> 81)/bin/aci.dll renamed to the right name, everything runs fine.
>>>>
>>>> Finally, am I using oracle 9i or 81 ??? It depends on the DLL I 
>>>> left on the machine ? Or is it the cx_oracle version which rules ?
>>>>   
>>>
>>>
>>>
>>> It's complicated. It appears to depend on both the server and client
>>> versions installed. I had to recompile cx_Oracle for one of our
>>> configurations (8i client/server) although foolishly didn't write 
>>> down the
>>> step by step process (but it was pretty much in line with the docs I
>>> recall).
>>>
>>> This is more of an Oracle issue than cx_oracle I think; I've had 
>>> similar
>>> problems with a number of client-side tools that interact with Oracle
>>> directly, often having to swap ORACLE_HOME according to which 
>>> specific tool
>>> was being used!
>>>
>>> Nick Barron
>>>
>>>
>>> -------------------------------------------------------
>>> This SF.net email is sponsored by: IT Product Guide on 
>>> ITManagersJournal
>>> Use IT products in your business? Tell us what you think of them. 
>>> Give us
>>> Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find 
>>> out more
>>> http://productguide.itmanagersjournal.com/guidepromo.tmpl
>>> _______________________________________________
>>> cx-oracle-users mailing list
>>> cx-...@li...
>>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>>>  
>>>
>>
>>
>> -------------------------------------------------------
>> This SF.net email is sponsored by: IT Product Guide on ITManagersJournal
>> Use IT products in your business? Tell us what you think of them. 
>> Give us
>> Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find 
>> out more
>> http://productguide.itmanagersjournal.com/guidepromo.tmpl
>> _______________________________________________
>> cx-oracle-users mailing list
>> cx-...@li...
>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>>
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: IT Product Guide on ITManagersJournal
> Use IT products in your business? Tell us what you think of them. Give us
> Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out 
> more
> http://productguide.itmanagersjournal.com/guidepromo.tmpl
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

Re: [cx-oracle-users] OCI.DLL cannot be found ?

[Philip S. <phi...@cg...>]

Sorry but no :-(

cx_Oracle-4.0.1-win32-9i-py23 did'nt work with either the 9i or 81 
version of oci.dll, and cx_Oracle-4.0.1-win32-8i-py23 works with both 9i 
and 81 version of the DLL...
(I switch from one DLL to the other by renaming the one I don't want to 
Aci.dll).

So I will go on like this for the moment...

Thanks,

Philip.

Anthony Tuininga wrote:

> This is definitely an Oracle client issue -- the server software is 
> irrelevant, actually. In general, make sure that if you are running 
> Oracle 8i on the client you are using the Oracle 8i version of cx_Oracle 
> and if you are running Oracle 9i on the client make sure you are using 
> the Oracle 9i version of cx_Oracle. As mentioned earlier, the only 
> exception is Oracle 9.0.1 which doesn't have the required procedure. 
> Make sense?
> 
> Nik Barron wrote:
> 
>>> c) With cx_Oracle-4.0.1-win32-9i-py23.exe uninstalled and 
>>> cx_Oracle-4.0.1-win32-8i-py23.exe installed back, oracle9i (or 
>>> 81)/bin/aci.dll renamed to the right name, everything runs fine.
>>>
>>> Finally, am I using oracle 9i or 81 ??? It depends on the DLL I left 
>>> on the machine ? Or is it the cx_oracle version which rules ?
>>>   
>>
>>
>> It's complicated. It appears to depend on both the server and client
>> versions installed. I had to recompile cx_Oracle for one of our
>> configurations (8i client/server) although foolishly didn't write down 
>> the
>> step by step process (but it was pretty much in line with the docs I
>> recall).
>>
>> This is more of an Oracle issue than cx_oracle I think; I've had similar
>> problems with a number of client-side tools that interact with Oracle
>> directly, often having to swap ORACLE_HOME according to which specific 
>> tool
>> was being used!
>>
>> Nick Barron
>>
>>
>> -------------------------------------------------------
>> This SF.net email is sponsored by: IT Product Guide on ITManagersJournal
>> Use IT products in your business? Tell us what you think of them. Give us
>> Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out 
>> more
>> http://productguide.itmanagersjournal.com/guidepromo.tmpl
>> _______________________________________________
>> cx-oracle-users mailing list
>> cx-...@li...
>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>>  
>>
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by: IT Product Guide on ITManagersJournal
> Use IT products in your business? Tell us what you think of them. Give us
> Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more
> http://productguide.itmanagersjournal.com/guidepromo.tmpl
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
> 

Re: [cx-oracle-users] OCI.DLL cannot be found ?

[Anthony T. <an...@co...>]

This is definitely an Oracle client issue -- the server software is 
irrelevant, actually. In general, make sure that if you are running 
Oracle 8i on the client you are using the Oracle 8i version of cx_Oracle 
and if you are running Oracle 9i on the client make sure you are using 
the Oracle 9i version of cx_Oracle. As mentioned earlier, the only 
exception is Oracle 9.0.1 which doesn't have the required procedure. 
Make sense?

Nik Barron wrote:

>>c) With cx_Oracle-4.0.1-win32-9i-py23.exe uninstalled and 
>>cx_Oracle-4.0.1-win32-8i-py23.exe installed back, oracle9i (or 
>>81)/bin/aci.dll renamed to the right name, everything runs fine.
>>
>>Finally, am I using oracle 9i or 81 ??? It depends on the DLL 
>>I left on 
>>the machine ? Or is it the cx_oracle version which rules ?
>>    
>>
>
>It's complicated. It appears to depend on both the server and client
>versions installed. I had to recompile cx_Oracle for one of our
>configurations (8i client/server) although foolishly didn't write down the
>step by step process (but it was pretty much in line with the docs I
>recall).
>
>This is more of an Oracle issue than cx_oracle I think; I've had similar
>problems with a number of client-side tools that interact with Oracle
>directly, often having to swap ORACLE_HOME according to which specific tool
>was being used!
>
>Nick Barron
>
>
>-------------------------------------------------------
>This SF.net email is sponsored by: IT Product Guide on ITManagersJournal
>Use IT products in your business? Tell us what you think of them. Give us
>Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more
>http://productguide.itmanagersjournal.com/guidepromo.tmpl
>_______________________________________________
>cx-oracle-users mailing list
>cx-...@li...
>https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>  
>

Re: [cx-oracle-users] OCI.DLL cannot be found ?

[Anthony T. <an...@co...>]

Ah yes, the infamous "OCISessionGet" procedure entry point missing 
error. We have the same error occur on a regular basis when someone with 
an Oracle 8i client installation attempts to run an Oracle 9i version of 
cx_Oracle. Running an Oracle 8i version of cx_Oracle on either an 8i or 
9i installation (on Windows) does not have a problem. In general, 
however, you need to make sure that your client software matches the 
version of cx_Oracle that you are using. The server software version is 
completely irrelevant. The only funny exception is Oracle 9.0.1 (an 
early version of 9i) which does not have the OCISessionGet() method 
either. Hope that clears up any questions you might have. If not, feel 
free to ask more questions!

Philip SION wrote:

> *** Sorry I was wrong with the file name :-(
>
> It's not pywin32-202.win32-py2.3 that I installed back but 
> cx_Oracle-4.0.1-win32-8i-py23.exe (THERE IS NO RELATION WITH pywin32 
> AT ALL of course...)
>
> BTW, (I owed you to reproduce the problem ;-) :
>
> When using Python from the command line, you obtain 2 different dialog 
> boxes depending on the error :
>
> a) With oracle81/bin/oci.dll and oracle9i/bin/oci.dll on the disk and 
> in the path :
>
> When I use cx_Oracle-4.1.beta1-win32-9i-py23, or 
> cx_Oracle-4.0.1-win32-9i-py23.exe, it displays a window stating 
> (translated from french): "Procedure entry point OCISessionGet cannot 
> be found in dynamic link library OCI.DLL
>
> With IDLE, I have the following errormessage in the Python Shell : 
> ImportError: DLL load failed: the specified procedure cannot be found
>
> Errormessages match.
>
> b) With both oci.dll renamed to aci.dll (so they are not any longer on 
> the disk for the app)
>
> This time the window is : This application could start because OCI.dll 
> cannot be found. Re-installation of this application can solve this 
> problem.
>
> And Python Shell error is : ImportError: DLL load failed: the 
> specified MODULE cannot be found !!!
>
> So the PythonShell errormessage was OK (although a bit incomplete), I 
> just read it too fast :-(
>
> c) With cx_Oracle-4.0.1-win32-9i-py23.exe uninstalled and 
> cx_Oracle-4.0.1-win32-8i-py23.exe installed back, oracle9i (or 
> 81)/bin/aci.dll renamed to the right name, everything runs fine.
>
> Finally, am I using oracle 9i or 81 ??? It depends on the DLL I left 
> on the machine ? Or is it the cx_oracle version which rules ?
>
> Thanks a lot anyway.
>
> Philip.
>
> Anthony Tuininga wrote:
>
>> Glad to hear you got it working. Just so that others who might run 
>> into this problem have something to look at in the archives and so 
>> that I understand it a bit better, could you answer a few questions?
>>
>> 1) what was the clearer error message that was displayed when running 
>> Python from the command line?
>>
>> 2) What did you do after the installation of pywin32-202.win32-py2.3 
>> that caused it to "link OK" aginst Oracle 8i's oci.dll?
>>
>> Thanks.
>>
>> Philip SION wrote:
>>
>>> It works !!!
>>>
>>> Thanks for your help to you all.
>>>
>>> In fact, both cx_Oracle-4.0.1-win32-9i-py23 and 
>>> cx_Oracle-4.1.beta1-win32-9i-py23 where unable to found the entry 
>>> point in the oci.dlls I have on my machine (although I own both 81 
>>> and 9i versions). I had a clearer errormessage when running python 
>>> from the command line.
>>>
>>> So I installed the pywin32-202.win32-py2.3 and it linked OK against 
>>> the Oracle 81's OCI.DLL.
>>>
>>> I can go on testing now...
>>>
>>> Philip.
>>>
>>> Nik Barron wrote:
>>>
>>>>> I believe Visual Studio includes (included) an utility called
>>>>> depends.exe which did this.
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> There's a freeware equivalent at http://www.dependencywalker.com/ 
>>>> that's
>>>> pretty good.
>>>>
>>>> Nick Barron
>>>>
>>>>
>>>> -------------------------------------------------------
>>>> This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
>>>> Project Admins to receive an Apple iPod Mini FREE for your 
>>>> judgement on
>>>> who ports your project to Linux PPC the best. Sponsored by IBM.
>>>> Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php
>>>> _______________________________________________
>>>> cx-oracle-users mailing list
>>>> cx-...@li...
>>>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>>>>
>>>
>>>
>>>
>>> -------------------------------------------------------
>>> This SF.net email is sponsored by: IT Product Guide on 
>>> ITManagersJournal
>>> Use IT products in your business? Tell us what you think of them. 
>>> Give us
>>> Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find 
>>> out more
>>> http://productguide.itmanagersjournal.com/guidepromo.tmpl
>>> _______________________________________________
>>> cx-oracle-users mailing list
>>> cx-...@li...
>>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>>
>>
>>
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: IT Product Guide on ITManagersJournal
> Use IT products in your business? Tell us what you think of them. Give us
> Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out 
> more
> http://productguide.itmanagersjournal.com/guidepromo.tmpl
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

RE: [cx-oracle-users] OCI.DLL cannot be found ?

[Nik B. <Nik...@pe...>]

> c) With cx_Oracle-4.0.1-win32-9i-py23.exe uninstalled and 
> cx_Oracle-4.0.1-win32-8i-py23.exe installed back, oracle9i (or 
> 81)/bin/aci.dll renamed to the right name, everything runs fine.
> 
> Finally, am I using oracle 9i or 81 ??? It depends on the DLL 
> I left on 
> the machine ? Or is it the cx_oracle version which rules ?

It's complicated. It appears to depend on both the server and client
versions installed. I had to recompile cx_Oracle for one of our
configurations (8i client/server) although foolishly didn't write down the
step by step process (but it was pretty much in line with the docs I
recall).

This is more of an Oracle issue than cx_oracle I think; I've had similar
problems with a number of client-side tools that interact with Oracle
directly, often having to swap ORACLE_HOME according to which specific tool
was being used!

Nick Barron

Re: [cx-oracle-users] OCI.DLL cannot be found ?

[Philip S. <phi...@cg...>]

*** Sorry I was wrong with the file name :-(

It's not pywin32-202.win32-py2.3 that I installed back but 
cx_Oracle-4.0.1-win32-8i-py23.exe (THERE IS NO RELATION WITH pywin32 AT 
ALL of course...)

BTW, (I owed you to reproduce the problem ;-) :

When using Python from the command line, you obtain 2 different dialog 
boxes depending on the error :

a) With oracle81/bin/oci.dll and oracle9i/bin/oci.dll on the disk and in 
the path :

When I use cx_Oracle-4.1.beta1-win32-9i-py23, or 
cx_Oracle-4.0.1-win32-9i-py23.exe, it displays a window stating 
(translated from french): "Procedure entry point OCISessionGet cannot be 
found in dynamic link library OCI.DLL

With IDLE, I have the following errormessage in the Python Shell : 
ImportError: DLL load failed: the specified procedure cannot be found

Errormessages match.

b) With both oci.dll renamed to aci.dll (so they are not any longer on 
the disk for the app)

This time the window is : This application could start because OCI.dll 
cannot be found. Re-installation of this application can solve this problem.

And Python Shell error is : ImportError: DLL load failed: the specified 
MODULE cannot be found !!!

So the PythonShell errormessage was OK (although a bit incomplete), I 
just read it too fast :-(

c) With cx_Oracle-4.0.1-win32-9i-py23.exe uninstalled and 
cx_Oracle-4.0.1-win32-8i-py23.exe installed back, oracle9i (or 
81)/bin/aci.dll renamed to the right name, everything runs fine.

Finally, am I using oracle 9i or 81 ??? It depends on the DLL I left on 
the machine ? Or is it the cx_oracle version which rules ?

Thanks a lot anyway.

Philip.

Anthony Tuininga wrote:

> Glad to hear you got it working. Just so that others who might run into 
> this problem have something to look at in the archives and so that I 
> understand it a bit better, could you answer a few questions?
> 
> 1) what was the clearer error message that was displayed when running 
> Python from the command line?
> 
> 2) What did you do after the installation of pywin32-202.win32-py2.3 
> that caused it to "link OK" aginst Oracle 8i's oci.dll?
> 
> Thanks.
> 
> Philip SION wrote:
> 
>> It works !!!
>>
>> Thanks for your help to you all.
>>
>> In fact, both cx_Oracle-4.0.1-win32-9i-py23 and 
>> cx_Oracle-4.1.beta1-win32-9i-py23 where unable to found the entry 
>> point in the oci.dlls I have on my machine (although I own both 81 and 
>> 9i versions). I had a clearer errormessage when running python from 
>> the command line.
>>
>> So I installed the pywin32-202.win32-py2.3 and it linked OK against 
>> the Oracle 81's OCI.DLL.
>>
>> I can go on testing now...
>>
>> Philip.
>>
>> Nik Barron wrote:
>>
>>>> I believe Visual Studio includes (included) an utility called
>>>> depends.exe which did this.
>>>
>>>
>>>
>>>
>>> There's a freeware equivalent at http://www.dependencywalker.com/ that's
>>> pretty good.
>>>
>>> Nick Barron
>>>
>>>
>>> -------------------------------------------------------
>>> This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
>>> Project Admins to receive an Apple iPod Mini FREE for your judgement on
>>> who ports your project to Linux PPC the best. Sponsored by IBM.
>>> Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php
>>> _______________________________________________
>>> cx-oracle-users mailing list
>>> cx-...@li...
>>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>>>
>>
>>
>>
>> -------------------------------------------------------
>> This SF.net email is sponsored by: IT Product Guide on ITManagersJournal
>> Use IT products in your business? Tell us what you think of them. Give us
>> Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out 
>> more
>> http://productguide.itmanagersjournal.com/guidepromo.tmpl
>> _______________________________________________
>> cx-oracle-users mailing list
>> cx-...@li...
>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
> 
> 

Re: [cx-oracle-users] OCI.DLL cannot be found ?

[Anthony T. <an...@co...>]

Glad to hear you got it working. Just so that others who might run into 
this problem have something to look at in the archives and so that I 
understand it a bit better, could you answer a few questions?

1) what was the clearer error message that was displayed when running 
Python from the command line?

2) What did you do after the installation of pywin32-202.win32-py2.3 
that caused it to "link OK" aginst Oracle 8i's oci.dll?

Thanks.

Philip SION wrote:
> It works !!!
> 
> Thanks for your help to you all.
> 
> In fact, both cx_Oracle-4.0.1-win32-9i-py23 and 
> cx_Oracle-4.1.beta1-win32-9i-py23 where unable to found the entry point 
> in the oci.dlls I have on my machine (although I own both 81 and 9i 
> versions). I had a clearer errormessage when running python from the 
> command line.
> 
> So I installed the pywin32-202.win32-py2.3 and it linked OK against the 
> Oracle 81's OCI.DLL.
> 
> I can go on testing now...
> 
> Philip.
> 
> Nik Barron wrote:
> 
>>> I believe Visual Studio includes (included) an utility called
>>> depends.exe which did this.
>>
>>
>>
>> There's a freeware equivalent at http://www.dependencywalker.com/ that's
>> pretty good.
>>
>> Nick Barron
>>
>>
>> -------------------------------------------------------
>> This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
>> Project Admins to receive an Apple iPod Mini FREE for your judgement on
>> who ports your project to Linux PPC the best. Sponsored by IBM.
>> Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php
>> _______________________________________________
>> cx-oracle-users mailing list
>> cx-...@li...
>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>>
> 
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by: IT Product Guide on ITManagersJournal
> Use IT products in your business? Tell us what you think of them. Give us
> Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more
> http://productguide.itmanagersjournal.com/guidepromo.tmpl
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

-- 
Anthony Tuininga
an...@co...

Computronix
Distinctive Software. Real People.
Suite 200, 10216 - 124 Street NW
Edmonton, AB, Canada  T5N 4A3
Phone:	(780) 454-3700
Fax:	(780) 454-3838
http://www.computronix.com

Re: [cx-oracle-users] OCI.DLL cannot be found ?

[Philip S. <phi...@cg...>]

It works !!!

Thanks for your help to you all.

In fact, both cx_Oracle-4.0.1-win32-9i-py23 and 
cx_Oracle-4.1.beta1-win32-9i-py23 where unable to found the entry point 
in the oci.dlls I have on my machine (although I own both 81 and 9i 
versions). I had a clearer errormessage when running python from the 
command line.

So I installed the pywin32-202.win32-py2.3 and it linked OK against the 
Oracle 81's OCI.DLL.

I can go on testing now...

Philip.

Nik Barron wrote:
>>I believe Visual Studio includes (included) an utility called
>>depends.exe which did this.
> 
> 
> There's a freeware equivalent at http://www.dependencywalker.com/ that's
> pretty good.
> 
> Nick Barron
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
> Project Admins to receive an Apple iPod Mini FREE for your judgement on
> who ports your project to Linux PPC the best. Sponsored by IBM.
> Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
> 

RE: [cx-oracle-users] OCI.DLL cannot be found ?

[Nik B. <Nik...@pe...>]

> I believe Visual Studio includes (included) an utility called
> depends.exe which did this.

There's a freeware equivalent at http://www.dependencywalker.com/ that's
pretty good.

Nick Barron

RE: [cx-oracle-users] OCI.DLL cannot be found ?

[Nik B. <Nik...@pe...>]

Hi,

> I got the "standard" errormessage under WinXP :
>=20
>  >>> import cx_Oracle
> Traceback (most recent call last):
>    File "<pyshell#6>", line 1, in ?
>      import cx_Oracle
> ImportError: DLL load failed: La proc=E9dure sp=E9cifi=E9e est =
introuvable.=20
> (the specified procedure cannot be found).

Is there only one OCI.DLL in the system path? I've seen this error on
installs with multiple Oracle installs, where the ORACLE_HOME is set
"incorrectly" (e.g. set to 8.1.7 with a 9i Oracle_cx install).=20

If there are, try manually inserting a directory into the front of the =
path
and then trying each one turn.

Hope this helps...

Nick Barron

Re: [cx-oracle-users] OCI.DLL cannot be found ?

[Marcos P. <ma...@bu...>]

I believe Visual Studio includes (included) an utility called
depends.exe which did this.

El vie, 24-09-2004 a las 18:09, Anthony Tuininga escribi=F3:
> What version of Oracle are you using? If you are using 9.0.1 then you=20
> should be using the 8i version (which will work just fine with an Oracle=20
> 9i client on Windows). 9.0.1 does not have the features that I took=20
> advantage of in the 9i version -- those all got added in 9.2.
>=20
> BTW, I believe that SQL*Plus uses oci.dll just as much as cx_Oracle=20
> does. As for searching for DLLs, that is done using the standard Windows=20
> method: search the current directory, the directory in which the=20
> executable is found and the path, etc. Unfortunately, I don't believe=20
> there is anything equivalent to the Unix ldd command that displays what=20
> shared libraries will be loaded by a particular program.
>=20
> Hope this helps.
>=20
> Philip SION wrote:
> > Hello !
> >=20
> > I got the "standard" errormessage under WinXP :
> >=20
> >  >>> import cx_Oracle
> > Traceback (most recent call last):
> >   File "<pyshell#6>", line 1, in ?
> >     import cx_Oracle
> > ImportError: DLL load failed: La proc=E9dure sp=E9cifi=E9e est introuva=
ble.=20
> > (the specified procedure cannot be found).
> >=20
> > As I get the same message even if I wipe out all oci.dll from c:\, I=20
> > guess the errormessage does'nt mean "the is a problem with one entry=20
> > point in the dll" but rather "I cannot find the (oci.)dll".
> >=20
> > I use latest cx_oracle 4.1 beta1 for 9.0i (installed with the installer=
=20
> > for python 2.3)
> > Oracle 9.0i client is installed. oci.dll is in c:\oracle\ora9i\bin.=20
> > SQLPlus is working fine.
> >=20
> > Here's my path :
> >=20
> > PATH=3Dc:\oracle\ora9i\bin;C:\Program=20
> > Files\Oracle\jre\1.1.8\bin;c:\oracle\ora81\bin;C:\Program=20
> > Files\Oracle\jre\1.1.7\bin;C:\WINNT\System32;C:\WINNT;C:\WINNT\System32=
\Wbem;c:\Prgfile\Orawin\bin;C:\PROGRA~1\CA\SHARED~1\SCANEN~1;C:\PROGRA~1\CA=
\ETRUST~1;C:\Program=20
> > Files\Visio2002\Visio10;c:\gs\gs8.14\bin\;C:\PROGRA~1\ULTRAEDT;Z:.;
> >=20
> > And I even set :
> >=20
> > ORACLE_HOME=3Dc:\oracle\ora9i\
> >=20
> > How does cx_oracle.pyd look for oci.dll ? How to solve this problem ?
> >=20
> > Thanks a lot for any hint !
> >=20
> > Philip.
> >=20
> >=20
> >=20
> >=20
> > -------------------------------------------------------
> > This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
> > Project Admins to receive an Apple iPod Mini FREE for your judgement on
> > who ports your project to Linux PPC the best. Sponsored by IBM.
> > Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php
> > _______________________________________________
> > cx-oracle-users mailing list
> > cx-...@li...
> > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

Re: [cx-oracle-users] OCI.DLL cannot be found ?

[Anthony T. <an...@co...>]

What version of Oracle are you using? If you are using 9.0.1 then you 
should be using the 8i version (which will work just fine with an Oracle 
9i client on Windows). 9.0.1 does not have the features that I took 
advantage of in the 9i version -- those all got added in 9.2.

BTW, I believe that SQL*Plus uses oci.dll just as much as cx_Oracle 
does. As for searching for DLLs, that is done using the standard Windows 
method: search the current directory, the directory in which the 
executable is found and the path, etc. Unfortunately, I don't believe 
there is anything equivalent to the Unix ldd command that displays what 
shared libraries will be loaded by a particular program.

Hope this helps.

Philip SION wrote:
> Hello !
> 
> I got the "standard" errormessage under WinXP :
> 
>  >>> import cx_Oracle
> Traceback (most recent call last):
>   File "<pyshell#6>", line 1, in ?
>     import cx_Oracle
> ImportError: DLL load failed: La procédure spécifiée est introuvable. 
> (the specified procedure cannot be found).
> 
> As I get the same message even if I wipe out all oci.dll from c:\, I 
> guess the errormessage does'nt mean "the is a problem with one entry 
> point in the dll" but rather "I cannot find the (oci.)dll".
> 
> I use latest cx_oracle 4.1 beta1 for 9.0i (installed with the installer 
> for python 2.3)
> Oracle 9.0i client is installed. oci.dll is in c:\oracle\ora9i\bin. 
> SQLPlus is working fine.
> 
> Here's my path :
> 
> PATH=c:\oracle\ora9i\bin;C:\Program 
> Files\Oracle\jre\1.1.8\bin;c:\oracle\ora81\bin;C:\Program 
> Files\Oracle\jre\1.1.7\bin;C:\WINNT\System32;C:\WINNT;C:\WINNT\System32\Wbem;c:\Prgfile\Orawin\bin;C:\PROGRA~1\CA\SHARED~1\SCANEN~1;C:\PROGRA~1\CA\ETRUST~1;C:\Program 
> Files\Visio2002\Visio10;c:\gs\gs8.14\bin\;C:\PROGRA~1\ULTRAEDT;Z:.;
> 
> And I even set :
> 
> ORACLE_HOME=c:\oracle\ora9i\
> 
> How does cx_oracle.pyd look for oci.dll ? How to solve this problem ?
> 
> Thanks a lot for any hint !
> 
> Philip.
> 
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
> Project Admins to receive an Apple iPod Mini FREE for your judgement on
> who ports your project to Linux PPC the best. Sponsored by IBM.
> Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

-- 
Anthony Tuininga
an...@co...

Computronix
Distinctive Software. Real People.
Suite 200, 10216 - 124 Street NW
Edmonton, AB, Canada  T5N 4A3
Phone:	(780) 454-3700
Fax:	(780) 454-3838
http://www.computronix.com

Re: [cx-oracle-users] OCI.DLL cannot be found ?

[Marcos P. <ma...@bu...>]

=BFDoes sqlplus work under the same conditions (same user, same session,
same DOS prompt)?

El vie, 24-09-2004 a las 17:40, Philip SION escribi=F3:
> Hello !
>=20
> I got the "standard" errormessage under WinXP :
>=20
>  >>> import cx_Oracle
> Traceback (most recent call last):
>    File "<pyshell#6>", line 1, in ?
>      import cx_Oracle
> ImportError: DLL load failed: La proc=E9dure sp=E9cifi=E9e est introuvabl=
e.=20
> (the specified procedure cannot be found).
>=20
> As I get the same message even if I wipe out all oci.dll from c:\, I=20
> guess the errormessage does'nt mean "the is a problem with one entry=20
> point in the dll" but rather "I cannot find the (oci.)dll".
>=20
> I use latest cx_oracle 4.1 beta1 for 9.0i (installed with the installer=20
> for python 2.3)
> Oracle 9.0i client is installed. oci.dll is in c:\oracle\ora9i\bin.=20
> SQLPlus is working fine.
>=20
> Here's my path :
>=20
> PATH=3Dc:\oracle\ora9i\bin;C:\Program=20
> Files\Oracle\jre\1.1.8\bin;c:\oracle\ora81\bin;C:\Program=20
> Files\Oracle\jre\1.1.7\bin;C:\WINNT\System32;C:\WINNT;C:\WINNT\System32\W=
bem;c:\Prgfile\Orawin\bin;C:\PROGRA~1\CA\SHARED~1\SCANEN~1;C:\PROGRA~1\CA\E=
TRUST~1;C:\Program=20
> Files\Visio2002\Visio10;c:\gs\gs8.14\bin\;C:\PROGRA~1\ULTRAEDT;Z:.;
>=20
> And I even set :
>=20
> ORACLE_HOME=3Dc:\oracle\ora9i\
>=20
> How does cx_oracle.pyd look for oci.dll ? How to solve this problem ?
>=20
> Thanks a lot for any hint !
>=20
> Philip.
>=20
>=20
>=20
>=20
> -------------------------------------------------------
> This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
> Project Admins to receive an Apple iPod Mini FREE for your judgement on
> who ports your project to Linux PPC the best. Sponsored by IBM.
> Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

[cx-oracle-users] OCI.DLL cannot be found ?

[Philip S. <phi...@cg...>]

Hello !

I got the "standard" errormessage under WinXP :

 >>> import cx=5FOracle
Traceback (most recent call last):
   File "<pyshell#6>", line 1, in ?
     import cx=5FOracle
ImportError: DLL load failed: La proc=E9dure sp=E9cifi=E9e est introuvable.=
=20
(the specified procedure cannot be found).

As I get the same message even if I wipe out all oci.dll from c:\, I=20
guess the errormessage does'nt mean "the is a problem with one entry=20
point in the dll" but rather "I cannot find the (oci.)dll".

I use latest cx=5Foracle 4.1 beta1 for 9.0i (installed with the installer=20
for python 2.3)
Oracle 9.0i client is installed. oci.dll is in c:\oracle\ora9i\bin.=20
SQLPlus is working fine.

Here's my path :

PATH=3Dc:\oracle\ora9i\bin;C:\Program=20
Files\Oracle\jre\1.1.8\bin;c:\oracle\ora81\bin;C:\Program=20
Files\Oracle\jre\1.1.7\bin;C:\WINNT\System32;C:\WINNT;C:\WINNT\System32\Wbe=
m;c:\Prgfile\Orawin\bin;C:\PROGRA~1\CA\SHARED~1\SCANEN~1;C:\PROGRA~1\CA\ETR=
UST~1;C:\Program=20
Files\Visio2002\Visio10;c:\gs\gs8.14\bin\;C:\PROGRA~1\ULTRAEDT;Z:.;

And I even set :

ORACLE=5FHOME=3Dc:\oracle\ora9i\

How does cx=5Foracle.pyd look for oci.dll ? How to solve this problem ?

Thanks a lot for any hint !

Philip.

Re: [cx-oracle-users] Segmentation fault with custom cursor

[<wa...@li...>]

Anthony Tuininga wrote:

> Ok, I should have looked at this a little more closely a little sooner, 
> such as before I released 4.1 beta1 :-) The problem with your code is 
> that you need to pass the connection through to the constructor of the 
> cursor.

OK, with the change:
class Connection2(Connection):
    def cursor(self):
       return Cursor2(self)
it works.

> Failing to do so does in fact yield a segfault which I have 
> fixed and that fix will be included in 4.1 final when it is released. If 
> you have any further questions, fire away. :-)

Everything's working fine now.

Servus,
    Walter

[cx-oracle-users] RE: cx_Oracle 4.1 beta1

[Moore, P. <Pau...@at...>]

From: Anthony Tuininga
> What's new?
[...]

A while back I sent you a patch to allow specifying SERVER=3DDEDICATED =
in makedsn(). It doesn't appear to have made it into 4.1 beta 1. Is =
there any chance it could be added? I attach the patch again, it's =
against 4.0.1 but I can update it if you prefer.

My original message was as follows:

"""
Would it be possible to add a keyword parameter to makedsn,
dedicated=3DTrue/False, which adds the (SERVER=3DDEDICATED) parameter
to the generated connect string? In certain types of firewall
environments (ie, ours :-() multithreaded connections won't get
through the firewall, and the simplest answer is just to force
SERVER=3DDEDICATED.

It's easy enough to either generate my own connect string,
or modify the generated one, but being able to say
makedsn(host,port,sid,dedicated=3DTrue) would be a nice convenience.
"""

Thanks,
Paul.



_________________________________________________________________________=
_
This e-mail and the documents attached are confidential and intended=20
solely for the addressee; it may also be privileged. If you receive this =

e-mail in error, please notify the sender immediately and destroy it.
As its integrity cannot be secured on the Internet, the Atos Origin =
group=20
liability cannot be triggered for the message content. Although the=20
sender endeavours to maintain a computer virus-free network, the sender=20
does not warrant that this transmission is virus-free and will not be=20
liable for any damages resulting from any virus transmitted.
_________________________________________________________________________=
_

Re: [cx-oracle-users] Segmentation fault with custom cursor

[Anthony T. <an...@co...>]

Ok, I should have looked at this a little more closely a little sooner, 
such as before I released 4.1 beta1 :-) The problem with your code is 
that you need to pass the connection through to the constructor of the 
cursor. Failing to do so does in fact yield a segfault which I have 
fixed and that fix will be included in 4.1 final when it is released. If 
you have any further questions, fire away. :-)

Walter Dörwald wrote:
> I'm having problems with implementing custom cursors.
> A minimal failing example is this:
> 
> from cx_Oracle import *
> 
> class Cursor2(Cursor):
>    pass
> 
> class Connection2(Connection):
>    def cursor(self):
>       return Cursor2()
> 
> db = Connection2("...")
> c = db.cursor()
> 
> Executing this gives me a Segmentation fault. I'm on Linux using
> cx_Oracle 4.0.1 with Anthony's patch for the NVARCHAR/UTF16 problem.
> 
> Bye,
>    Walter Dörwald
> 
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by BEA Weblogic Workshop
> FREE Java Enterprise J2EE developer tools!
> Get your free copy of BEA WebLogic Workshop 8.1 today.
> http://ads.osdn.com/?ad_id=4721&alloc_id=10040&op=click
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

-- 
Anthony Tuininga
an...@co...

Computronix
Distinctive Software. Real People.
Suite 200, 10216 - 124 Street NW
Edmonton, AB, Canada  T5N 4A3
Phone:	(780) 454-3700
Fax:	(780) 454-3838
http://www.computronix.com

RE: [cx-oracle-users] How to read 16-digit numbers?

[Guido v. R. <gu...@el...>]

We were using version 3.1.  Now we're using 4.0.1 and all is good.
Thanks! :-)

--Guido van Rossum (home page: http://www.python.org/~guido)

> -----Original Message-----
> From: Anthony Tuininga [mailto:an...@co...]
> Sent: Wednesday, September 01, 2004 9:35 AM
> To: D.R. Boxhoorn
> Cc: Guido van Rossum; cx_Oracle Mailing List
> Subject: Re: [cx-oracle-users] How to read 16-digit numbers?
>=20
> Version 4.0 and up handle both binding and fetching of long integers
> properly, I believe -- there are test cases that ensure this fact.
Could
> you tell us which version of cx_Oracle you are using? Thanks.
>=20
> D.R. Boxhoorn wrote:
> > Hoi Guido,
> >
> > All I can say is that the following works fine for me
> >
> >    % python
> >    Python 2.3.3 (#1, May 24 2004, 12:04:05)
> >    [GCC 3.2.3 20030502 (Red Hat Linux 3.2.3-24)] on linux2
> >    Type "help", "copyright", "credits" or "license" for more
information.
> >    >>> import cx_Oracle as odbc
> >    >>>
> >    >>> print odbc.version
> >    4.0.1
> >    >>>
> >    >>> database =3D
odbc.connect('ops$danny','ez','awtst.omegatest.nova.aw')
> >    >>> cursor =3D database.cursor()
> >    >>> cursor.execute('select 1234567800000001 from dual where
> 1234567800000001=3D:a',a=3D1234567800000001L)
> >    [<NumberVar object at 0xb72f01d0>]
> >    >>> print cursor.fetchall()
> >    [(1234567800000001L,)]
> >    >>> cursor.close()
> >
> > Both binding and fetching seems to be ok, so it looks like a more
complex
> > example is needed to expose your colleagues problem.
> >
> > Cheers,
> >
> >                                                    Danny
> >
> > Kapteyn Institute / OmegaCEN               e-mail:
da...@as...
> > Postbus 800                                  tel.: +31 (0)50 3634056
> > 9700 AV GRONINGEN                            fax.: +31 (0)50 3636100
> > THE NETHERLANDS
http://www.astro-wise.org/
> >
> >
> > On Wed, Sep 01, 2004 at 07:10:22AM -0700, Guido van Rossum wrote:
> >
> >>A certain table in our Oracle database contains 16-digit integers.
> >>These are a bit of a pain to get right at the best of times, but
"set
> >>numformat 9999999999999999" makes it work in SQL*Plus.  Now my
colleague
> >>is complaining that when using cx_Oracle, the values come back with
the
> >>lower digit(s?) truncated, as if they have somehow been converted to
a
> >>floating point type and back that doesn't have enough bits.  This
seems
> >>strange to me, since an IEEE float *does* have enough bits for the
> >>values, and Python has no trouble with these at all.  What are we
> >>missing?  (A sample value is 1234567800000001.)
> >>
> >>--Guido van Rossum (home page: http://www.python.org/~guido)
> >>
> >>
> >>-------------------------------------------------------
> >>This SF.Net email is sponsored by BEA Weblogic Workshop
> >>FREE Java Enterprise J2EE developer tools!
> >>Get your free copy of BEA WebLogic Workshop 8.1 today.
> >>http://ads.osdn.com/?ad_idP47&alloc_id=10808&op?k
> >>_______________________________________________
> >>cx-oracle-users mailing list
> >>cx-...@li...
> >>https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
> >
> >
> >
> > -------------------------------------------------------
> > This SF.Net email is sponsored by BEA Weblogic Workshop
> > FREE Java Enterprise J2EE developer tools!
> > Get your free copy of BEA WebLogic Workshop 8.1 today.
> > http://ads.osdn.com/?ad_idP47&alloc_id=10808&op=3Dclick
> > _______________________________________________
> > cx-oracle-users mailing list
> > cx-...@li...
> > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>=20
> --
> Anthony Tuininga
> an...@co...
>=20
> Computronix
> Distinctive Software. Real People.
> Suite 200, 10216 - 124 Street NW
> Edmonton, AB, Canada  T5N 4A3
> Phone:	(780) 454-3700
> Fax:	(780) 454-3838
> http://www.computronix.com