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

Re: [cx-oracle-users] Lack of cx_oracle.pyd

[Anthony T. <ant...@gm...>]

Hi,

There *was* a problem with the packages that I uploaded for version
5.1.2. I corrected them the next day so if you download the MSI
package again you shouldn't have any problems. If you do, please let
me know which package you downloaded that still has the problem. My
apologies for any inconvenience.

Anthony

On Fri, Jul 13, 2012 at 10:31 AM, Joe Hughes <jwh...@me...> wrote:
> All,
>
> I've been fighting this for a couple of days.  I used the msi install on the
> CX Oracle page and the installer doesn't install something since when I do
> an import cx_oracle I get the below.
>
> $ python
> ActivePython 3.2.2.3 (ActiveState Software Inc.) based on
> Python 3.2.2 (default, Sep  8 2011, 10:56:38) [MSC v.1500 32 bit (Intel)] on
> win
> 32
> Type "help", "copyright", "credits" or "license" for more information.
>>>> import cx_oracle
> Traceback (most recent call last):
>   File "<stdin>", line 1, in <module>
> ImportError: No module named cx_oracle
>
>  I downloaded Lessmsi and don't see the file in there.  Is it missing?  Here
> is what I posted on Stackoverflow
>
> I downloaded Windows X86 Installer (Oracle 10g, Python 3.2) from
> http://cx-oracle.sourceforge.net/ onto a server running Windows Server 2003
> Enterprise Edition and ActivePython 3.2.2.3 (ActiveState Software Inc.). I
> run the installer and the cx_oracle-doc directory and
> cx_Oracle-5.1.2-py3.2.egg-info are installed. I don't see cx_oracle.pyd in
> the site-packages directory. A search of the server doesn't find it. Is it
> part of the installer or do I need to build it?
>
> If I need to build it then it is being a bear in Cygwin.  Below is the
> output
>
> $ python setup.py build --compiler=mingw32 install
> running build
> running build_ext
> Access is denied.
> building 'cx_Oracle' extension
> E:\cygwin\bin\gcc.exe -mno-cygwin -mdll -O -Wall
> -IE:\oracle\product\11.2.0\clie
> nt_1\oci\include -IE:\oracle\product\11.2.0\client_1\rdbms\demo
> -IE:\Python32\in
> clude -IE:\Python32\PC -c cx_Oracle.c -o
> build\temp.win32-3.2-11g\Release\cx_ora
> cle.o -DBUILD_VERSION=5.1
>
> Any ideas on how to make this work would be appreciated.
>
> TIA,
> Joe
>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>

[cx-oracle-users] Lack of cx_oracle.pyd

[Joe H. <jwh...@me...>]

All,

	I've been fighting this for a couple of days.  I used the msi install on the CX Oracle page and the installer doesn't install something since when I do an import cx_oracle I get the below.

$ python
ActivePython 3.2.2.3 (ActiveState Software Inc.) based on
Python 3.2.2 (default, Sep  8 2011, 10:56:38) [MSC v.1500 32 bit (Intel)] on win
32
Type "help", "copyright", "credits" or "license" for more information.
>>> import cx_oracle
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
ImportError: No module named cx_oracle

 I downloaded Lessmsi and don't see the file in there.  Is it missing?  Here is what I posted on Stackoverflow

I downloaded Windows X86 Installer (Oracle 10g, Python 3.2) from http://cx-oracle.sourceforge.net/ onto a server running Windows Server 2003 Enterprise Edition and ActivePython 3.2.2.3 (ActiveState Software Inc.). I run the installer and the cx_oracle-doc directory and cx_Oracle-5.1.2-py3.2.egg-info are installed. I don't see cx_oracle.pyd in the site-packages directory. A search of the server doesn't find it. Is it part of the installer or do I need to build it?

If I need to build it then it is being a bear in Cygwin.  Below is the output

$ python setup.py build --compiler=mingw32 install
running build
running build_ext
Access is denied.
building 'cx_Oracle' extension
E:\cygwin\bin\gcc.exe -mno-cygwin -mdll -O -Wall -IE:\oracle\product\11.2.0\clie
nt_1\oci\include -IE:\oracle\product\11.2.0\client_1\rdbms\demo -IE:\Python32\in
clude -IE:\Python32\PC -c cx_Oracle.c -o build\temp.win32-3.2-11g\Release\cx_ora
cle.o -DBUILD_VERSION=5.1

Any ideas on how to make this work would be appreciated.

TIA,
Joe

Re: [cx-oracle-users] pick one Oracle client and access databases of any current version

[Anthony T. <ant...@gm...>]

On Wed, Jul 11, 2012 at 2:35 AM, Robert Lucente <rlu...@pi...> wrote:
>>pick one client
>>and access databases of any current version
> I would be careful w/ the above statement. There is a certification matrix
> of which Oracle clients work w/ which Oracle servers. The phrase "current
> version" is not specific enough.

Yes, I am aware of the certification matrix and the fact that there
are occasions (fortunately few and far between) where problems occur
when stepping outside the bounds of the certification matrix. In
general Oracle supports interaction between one version and its
predecessor (so 10 and 11, for example) but the fact is that for most
work you can pick one client and access any database version without
any difficulties.

Anthony

[cx-oracle-users] pick one Oracle client and access databases of any current version

[Robert L. <rlu...@pi...>]

>pick one client
>and access databases of any current version
I would be careful w/ the above statement. There is a certification matrix
of which Oracle clients work w/ which Oracle servers. The phrase "current
version" is not specific enough.

-----Original Message-----
From: cx-...@li...
[mailto:cx-...@li...]
Sent: Tuesday, July 10, 2012 11:52 PM
To: cx-...@li...
Subject: cx-oracle-users Digest, Vol 72, Issue 3


Send cx-oracle-users mailing list submissions to
	cx-...@li...

To subscribe or unsubscribe via the World Wide Web, visit
	https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
or, via email, send a message with subject or body 'help' to
	cx-...@li...

You can reach the person managing the list at
	cx-...@li...

When replying, please edit your Subject line so it is more specific
than "Re: Contents of cx-oracle-users digest..."


Today's Topics:

   1. cx_Oracle 5.1.2 (Anthony Tuininga)
   2. Re: Next Release? (Anthony Tuininga)
   3. Re: Next Release? (ba...@pl...)
   4. Windows packaging problem? (David Roe)
   5. Re: Windows packaging problem? (Anthony Tuininga)
   6. Re: cx_Oracle 5.1.2 (James C. McPherson)
   7. Re: cx_Oracle 5.1.2 (Anthony Tuininga)
   8. Re: cx_Oracle 5.1.2 (James C. McPherson)


----------------------------------------------------------------------

Message: 1
Date: Fri, 6 Jul 2012 21:30:47 -0600
From: Anthony Tuininga <ant...@gm...>
Subject: [cx-oracle-users] cx_Oracle 5.1.2
To: cx-...@li..., pyt...@py...,
	DB...@py...
Message-ID:
	<CAE...@ma...>
Content-Type: text/plain; charset=ISO-8859-1

What is cx_Oracle?

cx_Oracle is a Python extension module that allows access to Oracle and
conforms to the Python database API 2.0 specifications with a few
exceptions.


Where do I get it?

http://cx-oracle.sourceforge.net


What's new?


1) Added support for LONG_UNICODE which is a type used to handle long
unicode strings. These are not explicitly supported in Oracle but can
be used to bind to NCLOB, for example, without getting the error
"unimplemented or unreasonable conversion requested".

2) Set the row number in a cursor when executing PL/SQL blocks as
requested by Robert Ritchie.

3) Added support for setting the module, action and client_info
attributes during connection so that logon triggers will see the
supplied values, as requested by Rodney Barnett.

In addition, binaries are now being built for Python 3.3.



------------------------------

Message: 2
Date: Fri, 6 Jul 2012 21:51:34 -0600
From: Anthony Tuininga <ant...@gm...>
Subject: Re: [cx-oracle-users] Next Release?
To: cx-...@li...
Message-ID:
	<CAE...@ma...>
Content-Type: text/plain; charset=ISO-8859-1

On Mon, Jul 2, 2012 at 6:34 AM,  <ba...@pl...> wrote:
>> Hi Rodney,
>>
>> I have run into some difficulties with my virtual machines due to some
>> upgrades and the fact that I haven't used them for some time! So
>> things have been delayed longer than expected.... :-( Should have them
>> resolved shortly, though. Depending on which Python version and OS you
>> require, though, I can focus on resolving the difficulties with that
>> one first instead of the others.
>>
>> Anthony
>
> Looks like this version would be most useful: "CentOS 5 x86_64 RPM (Oracle
> 11g, Python 2.7)".

Well, I managed to resolve all of the problems I was having with my
virtual machines....so the release has been made as you may have
noticed already.

Anthony



------------------------------

Message: 3
Date: Sat, 7 Jul 2012 09:24:43 -0400 (EDT)
From: ba...@pl...
Subject: Re: [cx-oracle-users] Next Release?
To: cx-...@li...
Message-ID:
	<472...@ma...>
Content-Type: text/plain;charset=iso-8859-1

On Fri, July 6, 2012 11:51 pm, Anthony Tuininga wrote:
> On Mon, Jul 2, 2012 at 6:34 AM,  <ba...@pl...> wrote:
>>> Hi Rodney,
>>>
>>> I have run into some difficulties with my virtual machines due to some
>>> upgrades and the fact that I haven't used them for some time! So
>>> things have been delayed longer than expected.... :-( Should have them
>>> resolved shortly, though. Depending on which Python version and OS you
>>> require, though, I can focus on resolving the difficulties with that
>>> one first instead of the others.
>>>
>>> Anthony
>>
>> Looks like this version would be most useful: "CentOS 5 x86_64 RPM
>> (Oracle
>> 11g, Python 2.7)".
>
> Well, I managed to resolve all of the problems I was having with my
> virtual machines....so the release has been made as you may have
> noticed already.
>
> Anthony

Thanks much, Anthony.  This will be quite useful.

Rodney




------------------------------

Message: 4
Date: Tue, 10 Jul 2012 09:44:01 +0100
From: David Roe <di...@gm...>
Subject: [cx-oracle-users] Windows packaging problem?
To: cx-...@li...
Message-ID:
	<CAGHq334ULZY11XVYy05O_GsLADxwVp73SNjsdhcr=nce...@ma...>
Content-Type: text/plain; charset="iso-8859-1"

I just tried to install the latest 5.1.2 build for Windows and it doesn't
seem to work. Looking in the site-packages folder, the cx_Oracle.pyd file
seems to be missing. Installing 5.1.1 worked fine.

I tried Python 2.7 and 3.2 versions for both 32bit and 64bit. Is there a
problem with the current build of the Windows installers?
-------------- next part --------------
An HTML attachment was scrubbed...

------------------------------

Message: 5
Date: Tue, 10 Jul 2012 22:24:32 -0600
From: Anthony Tuininga <ant...@gm...>
Subject: Re: [cx-oracle-users] Windows packaging problem?
To: cx-...@li...
Message-ID:
	<CAE...@ma...>
Content-Type: text/plain; charset=ISO-8859-1

Hi everyone,

Yes, the Windows packages were done incorrectly. Some code in
distutils overrides my build directory so I have to turn off that code
every time I install a new version of Python -- and I forgot again.
:-( New packages have been uploaded and you should be good to go.
Apologies for the inconvenience.

Anthony

On Tue, Jul 10, 2012 at 2:44 AM, David Roe <di...@gm...> wrote:
> I just tried to install the latest 5.1.2 build for Windows and it doesn't
> seem to work. Looking in the site-packages folder, the cx_Oracle.pyd file
> seems to be missing. Installing 5.1.1 worked fine.
>
> I tried Python 2.7 and 3.2 versions for both 32bit and 64bit. Is there a
> problem with the current build of the Windows installers?
>
> --------------------------------------------------------------------------
----
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>



------------------------------

Message: 6
Date: Wed, 11 Jul 2012 14:43:10 +1000
From: "James C. McPherson" <Jam...@or...>
Subject: Re: [cx-oracle-users] cx_Oracle 5.1.2
To: cx-...@li...
Cc: DB...@py..., pyt...@py...,	Anthony Tuininga
	<ant...@gm...>
Message-ID: <4FF...@or...>
Content-Type: text/plain; charset=UTF-8; format=flowed

On  7/07/12 01:30 PM, Anthony Tuininga wrote:
> What is cx_Oracle?
>
> cx_Oracle is a Python extension module that allows access to Oracle and
> conforms to the Python database API 2.0 specifications with a few
> exceptions.

Hi Anthony,
Could I clarify with you please, is it possible to build cx_Oracle
so that I can support several different versions of the rdbms from
the one cx_Oracle installation?

ie, do I need a separate build for each 10g/11i/... version that I
want to support, or can one build support them all (assuming a certain
minimum rdbms version)?


thanks in advance,
James C. McPherson
--
Oracle
http://www.jmcpdotcom.com/blog



------------------------------

Message: 7
Date: Tue, 10 Jul 2012 22:50:29 -0600
From: Anthony Tuininga <ant...@gm...>
Subject: Re: [cx-oracle-users] cx_Oracle 5.1.2
To: Jam...@or...
Cc: cx-...@li..., DB...@py...
Message-ID:
	<CAE1XR-5UbcLghnFN_N=cVw0vrAFbLVLyRgSuO9NUQHJFGev=EA...@ma...>
Content-Type: text/plain; charset=ISO-8859-1

On Tue, Jul 10, 2012 at 10:43 PM, James C. McPherson
<Jam...@or...> wrote:
> On  7/07/12 01:30 PM, Anthony Tuininga wrote:
>>
>> What is cx_Oracle?
>>
>> cx_Oracle is a Python extension module that allows access to Oracle and
>> conforms to the Python database API 2.0 specifications with a few
>> exceptions.
>
>
> Hi Anthony,
> Could I clarify with you please, is it possible to build cx_Oracle
> so that I can support several different versions of the rdbms from
> the one cx_Oracle installation?
>
> ie, do I need a separate build for each 10g/11i/... version that I
> want to support, or can one build support them all (assuming a certain
> minimum rdbms version)?

The client you use is what matters. There are some situations where
the client won't work correctly with the server but they are few and
far between. You should be able to pick one client and access
databases of any current version (10i and 11g whether 32-bit or
64-bit) and use them with one cx_Oracle install. Hope that helps.

Anthony



------------------------------

Message: 8
Date: Wed, 11 Jul 2012 14:52:14 +1000
From: "James C. McPherson" <Jam...@or...>
Subject: Re: [cx-oracle-users] cx_Oracle 5.1.2
To: Anthony Tuininga <ant...@gm...>
Cc: cx-...@li..., DB...@py...
Message-ID: <4FF...@or...>
Content-Type: text/plain; charset=UTF-8; format=flowed

On 11/07/12 02:50 PM, Anthony Tuininga wrote:
> On Tue, Jul 10, 2012 at 10:43 PM, James C. McPherson
> <Jam...@or...>  wrote:
>> On  7/07/12 01:30 PM, Anthony Tuininga wrote:
>>>
>>> What is cx_Oracle?
>>>
>>> cx_Oracle is a Python extension module that allows access to Oracle and
>>> conforms to the Python database API 2.0 specifications with a few
>>> exceptions.
>>
>>
>> Hi Anthony,
>> Could I clarify with you please, is it possible to build cx_Oracle
>> so that I can support several different versions of the rdbms from
>> the one cx_Oracle installation?
>>
>> ie, do I need a separate build for each 10g/11i/... version that I
>> want to support, or can one build support them all (assuming a certain
>> minimum rdbms version)?
>
> The client you use is what matters. There are some situations where
> the client won't work correctly with the server but they are few and
> far between. You should be able to pick one client and access
> databases of any current version (10i and 11g whether 32-bit or
> 64-bit) and use them with one cx_Oracle install. Hope that helps.

That helps quite a lot, thankyou.


James C. McPherson
--
Oracle
http://www.jmcpdotcom.com/blog



------------------------------

----------------------------------------------------------------------------
--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/

------------------------------

_______________________________________________
cx-oracle-users mailing list
cx-...@li...
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users


End of cx-oracle-users Digest, Vol 72, Issue 3
**********************************************

Re: [cx-oracle-users] cx_Oracle 5.1.2

[James C. M. <Jam...@or...>]

On 11/07/12 02:50 PM, Anthony Tuininga wrote:
> On Tue, Jul 10, 2012 at 10:43 PM, James C. McPherson
> <Jam...@or...>  wrote:
>> On  7/07/12 01:30 PM, Anthony Tuininga wrote:
>>>
>>> What is cx_Oracle?
>>>
>>> cx_Oracle is a Python extension module that allows access to Oracle and
>>> conforms to the Python database API 2.0 specifications with a few
>>> exceptions.
>>
>>
>> Hi Anthony,
>> Could I clarify with you please, is it possible to build cx_Oracle
>> so that I can support several different versions of the rdbms from
>> the one cx_Oracle installation?
>>
>> ie, do I need a separate build for each 10g/11i/... version that I
>> want to support, or can one build support them all (assuming a certain
>> minimum rdbms version)?
>
> The client you use is what matters. There are some situations where
> the client won't work correctly with the server but they are few and
> far between. You should be able to pick one client and access
> databases of any current version (10i and 11g whether 32-bit or
> 64-bit) and use them with one cx_Oracle install. Hope that helps.

That helps quite a lot, thankyou.


James C. McPherson
--
Oracle
http://www.jmcpdotcom.com/blog

Re: [cx-oracle-users] cx_Oracle 5.1.2

[Anthony T. <ant...@gm...>]

On Tue, Jul 10, 2012 at 10:43 PM, James C. McPherson
<Jam...@or...> wrote:
> On  7/07/12 01:30 PM, Anthony Tuininga wrote:
>>
>> What is cx_Oracle?
>>
>> cx_Oracle is a Python extension module that allows access to Oracle and
>> conforms to the Python database API 2.0 specifications with a few
>> exceptions.
>
>
> Hi Anthony,
> Could I clarify with you please, is it possible to build cx_Oracle
> so that I can support several different versions of the rdbms from
> the one cx_Oracle installation?
>
> ie, do I need a separate build for each 10g/11i/... version that I
> want to support, or can one build support them all (assuming a certain
> minimum rdbms version)?

The client you use is what matters. There are some situations where
the client won't work correctly with the server but they are few and
far between. You should be able to pick one client and access
databases of any current version (10i and 11g whether 32-bit or
64-bit) and use them with one cx_Oracle install. Hope that helps.

Anthony

Re: [cx-oracle-users] cx_Oracle 5.1.2

[James C. M. <Jam...@or...>]

On  7/07/12 01:30 PM, Anthony Tuininga wrote:
> What is cx_Oracle?
>
> cx_Oracle is a Python extension module that allows access to Oracle and
> conforms to the Python database API 2.0 specifications with a few
> exceptions.

Hi Anthony,
Could I clarify with you please, is it possible to build cx_Oracle
so that I can support several different versions of the rdbms from
the one cx_Oracle installation?

ie, do I need a separate build for each 10g/11i/... version that I
want to support, or can one build support them all (assuming a certain
minimum rdbms version)?


thanks in advance,
James C. McPherson
--
Oracle
http://www.jmcpdotcom.com/blog

Re: [cx-oracle-users] Windows packaging problem?

[Anthony T. <ant...@gm...>]

Hi everyone,

Yes, the Windows packages were done incorrectly. Some code in
distutils overrides my build directory so I have to turn off that code
every time I install a new version of Python -- and I forgot again.
:-( New packages have been uploaded and you should be good to go.
Apologies for the inconvenience.

Anthony

On Tue, Jul 10, 2012 at 2:44 AM, David Roe <di...@gm...> wrote:
> I just tried to install the latest 5.1.2 build for Windows and it doesn't
> seem to work. Looking in the site-packages folder, the cx_Oracle.pyd file
> seems to be missing. Installing 5.1.1 worked fine.
>
> I tried Python 2.7 and 3.2 versions for both 32bit and 64bit. Is there a
> problem with the current build of the Windows installers?
>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>

[cx-oracle-users] Windows packaging problem?

[David R. <di...@gm...>]

I just tried to install the latest 5.1.2 build for Windows and it doesn't
seem to work. Looking in the site-packages folder, the cx_Oracle.pyd file
seems to be missing. Installing 5.1.1 worked fine.

I tried Python 2.7 and 3.2 versions for both 32bit and 64bit. Is there a
problem with the current build of the Windows installers?

Re: [cx-oracle-users] Next Release?

[<ba...@pl...>]

On Fri, July 6, 2012 11:51 pm, Anthony Tuininga wrote:
> On Mon, Jul 2, 2012 at 6:34 AM,  <ba...@pl...> wrote:
>>> Hi Rodney,
>>>
>>> I have run into some difficulties with my virtual machines due to some
>>> upgrades and the fact that I haven't used them for some time! So
>>> things have been delayed longer than expected.... :-( Should have them
>>> resolved shortly, though. Depending on which Python version and OS you
>>> require, though, I can focus on resolving the difficulties with that
>>> one first instead of the others.
>>>
>>> Anthony
>>
>> Looks like this version would be most useful: "CentOS 5 x86_64 RPM
>> (Oracle
>> 11g, Python 2.7)".
>
> Well, I managed to resolve all of the problems I was having with my
> virtual machines....so the release has been made as you may have
> noticed already.
>
> Anthony

Thanks much, Anthony.  This will be quite useful.

Rodney

Re: [cx-oracle-users] Next Release?

[Anthony T. <ant...@gm...>]

On Mon, Jul 2, 2012 at 6:34 AM,  <ba...@pl...> wrote:
>> Hi Rodney,
>>
>> I have run into some difficulties with my virtual machines due to some
>> upgrades and the fact that I haven't used them for some time! So
>> things have been delayed longer than expected.... :-( Should have them
>> resolved shortly, though. Depending on which Python version and OS you
>> require, though, I can focus on resolving the difficulties with that
>> one first instead of the others.
>>
>> Anthony
>
> Looks like this version would be most useful: "CentOS 5 x86_64 RPM (Oracle
> 11g, Python 2.7)".

Well, I managed to resolve all of the problems I was having with my
virtual machines....so the release has been made as you may have
noticed already.

Anthony

[cx-oracle-users] cx_Oracle 5.1.2

[Anthony T. <ant...@gm...>]

What is cx_Oracle?

cx_Oracle is a Python extension module that allows access to Oracle and
conforms to the Python database API 2.0 specifications with a few
exceptions.


Where do I get it?

http://cx-oracle.sourceforge.net


What's new?


1) Added support for LONG_UNICODE which is a type used to handle long
unicode strings. These are not explicitly supported in Oracle but can
be used to bind to NCLOB, for example, without getting the error
"unimplemented or unreasonable conversion requested".

2) Set the row number in a cursor when executing PL/SQL blocks as
requested by Robert Ritchie.

3) Added support for setting the module, action and client_info
attributes during connection so that logon triggers will see the
supplied values, as requested by Rodney Barnett.

In addition, binaries are now being built for Python 3.3.

Re: [cx-oracle-users] 'ImportError: DLL load failed' only happens with Apache WSGI

[Anthony T. <ant...@gm...>]

Hi,

This *might* be related to the fact that Python strips the manifest
information out of the DLL when building. I just ran into that myself
and I don't see any particular way around it -- other than what I did
which was (a) go into distutils.msvc9compiler and put a return at the
beginning of the _remove_visual_c_ref() method or (b) add the manifest
back into the DLL after the fact. I am hesitant to add the manifest
back in after so much effort was taken to rip it out...but perhaps you
can try this method and see if it works for you:

Take the attached manifest file and then run the following command:

mt -manifest <location_of_manifest_attached_here>
-outputresource:<location_of_cx_Oracle.pyd>

If you don't have the Windows SDK on your machine then I can e-mail
you an updated pyd for you to try if you'd like. Send me a private
e-mail.

Anthony

On Wed, Jun 20, 2012 at 8:49 AM, Michael Freylinger
<mic...@gm...> wrote:
> Hi everybody,
>
> I can import cx_Oracle from Python console.
> I can import cx_Oracle from a CGI script run by Apache (and I can
> connect to my database and run SQL queries).
> But I CANNOT import cx_Oracle from a WSGI script run by Apache.
>
> Apache logs the error 'ImportError: DLL load failed: The specified
> module could not be found.'
> 'import cx_Oracle' is the first statement of my CGI and WSGI script.
> I printed the os.environ in both CGI and WSGI scripts and the only
> Oracle related stuff is in variable PATH which contains
> 'C:\oraclexe\app\oracle\product\11.2.0\server\bin', which is present
> in both cases.
> So what could be different in WSGI that makes the import fail?
>
> Software:
> Operating system = 'Windows-XP-5.1.2600-SP3'
> Python version = '2.7.3 (default, Apr 10 2012, 23:31:26) [MSC v.1500
> 32 bit (Intel)]'
> SERVER_SOFTWARE = Apache/2.2.22 (Win32) mod_wsgi/3.3 Python/2.7.3
> cx_Oracle module version = '5.1.1'
> Oracle client version = (11, 2, 0, 2, 0)
>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

Re: [cx-oracle-users] 'ImportError: DLL load failed' only happens with Apache WSGI

[Anthony T. <ant...@gm...>]

Just a thought: it might be the method used for building the binaries.
Earlier I used mingw32 to compile but later on I used MSVC instead. It
solved one problem but it may have introduced another one. :-) I am
about to make a new release -- in fact I tagged it last night -- but
if you can figure out what the problem is I might be able to roll that
in yet. Specifically, you need to find out *which* DLL it is
complaining about. If it just the way I am building, though, (which is
likely) then I can always fix it after the release anyway.

Anthony

On Tue, Jul 3, 2012 at 3:07 AM, Michael Freylinger
<mic...@gm...> wrote:
> It works with cx_Oracle 5.0.4 but not with 5.1.x!
> What is the difference between those versions that could make the import fail?
>
> Ok: cx_Oracle-5.0.4-11g.win32-py2.7.msi
> Not Ok: cx_Oracle-5.1.1-11g.win32-py2.7.msi and
> cx_Oracle-5.1-11g.win32-py2.7.msi
>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

Re: [cx-oracle-users] 'ImportError: DLL load failed' only happens with Apache WSGI

[Michael F. <mic...@gm...>]

It works with cx_Oracle 5.0.4 but not with 5.1.x!
What is the difference between those versions that could make the import fail?

Ok: cx_Oracle-5.0.4-11g.win32-py2.7.msi
Not Ok: cx_Oracle-5.1.1-11g.win32-py2.7.msi and
cx_Oracle-5.1-11g.win32-py2.7.msi

Re: [cx-oracle-users] Next Release?

[<ba...@pl...>]

> Hi Rodney,
>
> I have run into some difficulties with my virtual machines due to some
> upgrades and the fact that I haven't used them for some time! So
> things have been delayed longer than expected.... :-( Should have them
> resolved shortly, though. Depending on which Python version and OS you
> require, though, I can focus on resolving the difficulties with that
> one first instead of the others.
>
> Anthony

Looks like this version would be most useful: "CentOS 5 x86_64 RPM (Oracle
11g, Python 2.7)".

Thanks again.

Rodney

[cx-oracle-users] can bind a LONG value only for insert into a LONG

[Robert L. <rlu...@pi...>]

>issue when inserting a unicode string into a varchar2(4000 byte) field

When you create a VARCHAR2 you can specify "BYTE" or "CHAR". So, trying to
put unicode into a "BYTE" varchar2 I think is wrong because unicode
definitely takes more than one byte.

For the official doco, check out

http://docs.oracle.com/cd/B19306_01/server.102/b14200/sql_elements001.htm#i4
5694

Oracle Built-in Datatypes

Table 2-1 Built-in Datatype Summary

VARCHAR2(size [BYTE | CHAR])

Variable-length character string having maximum length size bytes or
characters. Maximum size is 4000 bytes or characters, and minimum is 1 byte
or 1 character. You must specify size for VARCHAR2.

BYTE indicates that the column will have byte length semantics; CHAR
indicates that the column will have character semantics.

The other thing is to step back and ask, does the DB support unicode? A good
place to start is

http://docs.oracle.com/cd/B19306_01/server.102/b14225/ch6unicode.htm

Please try to avoid "hacking" so that a non-unicode Oracle db is used to
support unicode. It is "simple" to upgrade the character set of the
database.

-----Original Message-----
From: cx-...@li...
[mailto:cx-...@li...]
Sent: Saturday, June 30, 2012 10:47 PM
To: cx-...@li...
Subject: cx-oracle-users Digest, Vol 72, Issue 1


Send cx-oracle-users mailing list submissions to
	cx-...@li...

To subscribe or unsubscribe via the World Wide Web, visit
	https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
or, via email, send a message with subject or body 'help' to
	cx-...@li...

You can reach the person managing the list at
	cx-...@li...

When replying, please edit your Subject line so it is more specific
than "Re: Contents of cx-oracle-users digest..."


Today's Topics:

   1. ORA-01461: can bind a LONG value only for insert	into a LONG
      column (Shubhanan Bakre)
   2. Re: ORA-01461: can bind a LONG value only for	insert	into a
      LONG column (Rodney Barnett)
   3. Next Release? (ba...@pl...)
   4. Re: Next Release? (Anthony Tuininga)
   5. Re: Next Release? (Rodney Barnett)
   6. 'ImportError: DLL load failed' only happens with	Apache WSGI
      (Michael Freylinger)
   7. Re: Next Release? (Anthony Tuininga)


----------------------------------------------------------------------

Message: 1
Date: Mon, 4 Jun 2012 20:27:58 -0500
From: Shubhanan Bakre <sb...@et...>
Subject: [cx-oracle-users] ORA-01461: can bind a LONG value only for
	insert	into a LONG column
To: "cx-...@li..."
	<cx-...@li...>
Message-ID:
	<EF1...@MB...>
Content-Type: text/plain; charset="us-ascii"

Hi,

I have this strange issue when inserting a unicode string into a
varchar2(4000 byte) field.
cx_Oracle tries to bind it to a LONG value, however all the characters in
the string are English.

Table ddl:

CREATE TABLE TEST(
"NOTES" VARCHAR2(4000 BYTES)
);

INSERT INTO TEST (NOTES) VALUES (:NOTES);

The python value dict for the above insert is as follows:
{'NOTES': u'

'}

This throws the following error:
ORA-01461: can bind a LONG value only for insert into a LONG column

Any help will be appreciated.
Thanks!
Shubhanan


------------------------------

Message: 2
Date: Wed, 6 Jun 2012 07:42:45 -0500
From: "Rodney Barnett" <ba...@pl...>
Subject: Re: [cx-oracle-users] ORA-01461: can bind a LONG value only
	for	insert	into a LONG column
To: <cx-...@li...>
Message-ID: <006e01cd43e1$df8c9f50$9ea5ddf0$@com>
Content-Type: text/plain;	charset="us-ascii"

Maybe this is the same problem I ran into about a year ago.  I posted some
patches to the cx_Oracle tests to illustrate:
http://sourceforge.net/mailarchive/forum.php?thread_name=001201cc1bd9%248295
5660%2487c00320%24%40com&forum_name=cx-oracle-users

I don't know how to fix the problem, but I think I avoided it by converting
my unicode values to str.

Rodney

-----Original Message-----
From: Shubhanan Bakre [mailto:sb...@et...]
Sent: Monday, June 04, 2012 8:28 PM
To: cx-...@li...
Subject: [cx-oracle-users] ORA-01461: can bind a LONG value only for insert
into a LONG column

Hi,

I have this strange issue when inserting a unicode string into a
varchar2(4000 byte) field.
cx_Oracle tries to bind it to a LONG value, however all the characters in
the string are English.

Table ddl:

CREATE TABLE TEST(
"NOTES" VARCHAR2(4000 BYTES)
);

INSERT INTO TEST (NOTES) VALUES (:NOTES);

The python value dict for the above insert is as follows:
{'NOTES': u'
'}

This throws the following error:
ORA-01461: can bind a LONG value only for insert into a LONG column

Any help will be appreciated.
Thanks!
Shubhanan
----------------------------------------------------------------------------
--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
cx-oracle-users mailing list
cx-...@li...
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users




------------------------------

Message: 3
Date: Wed, 13 Jun 2012 14:08:35 -0400 (EDT)
From: ba...@pl...
Subject: [cx-oracle-users] Next Release?
To: cx-...@li...
Message-ID:
	<378...@ma...>

Content-Type: text/plain;charset=iso-8859-1

Hi,

Is there a release on the horizon?  A client could benefit from recent
changes and it would be easier to work with a released version.

Thanks.

Rodney




------------------------------

Message: 4
Date: Wed, 13 Jun 2012 23:20:34 -0600
From: Anthony Tuininga <ant...@gm...>
Subject: Re: [cx-oracle-users] Next Release?
To: cx-...@li...
Message-ID:
	<CAE...@ma...>
Content-Type: text/plain; charset=ISO-8859-1

Hi Rodney,

Yes, I really should make a new release as it is has been some time
since the last one and there are some changes that could be released.
I'll see about getting one out in the next couple of weeks. I'd say
sooner than that but the next week looks particularly busy. :-( Hope
that works for you.

Anthony

On Wed, Jun 13, 2012 at 12:08 PM,  <ba...@pl...> wrote:
> Hi,
>
> Is there a release on the horizon? ?A client could benefit from recent
> changes and it would be easier to work with a released version.
>
> Thanks.
>
> Rodney
>
>
> --------------------------------------------------------------------------
----
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users



------------------------------

Message: 5
Date: Thu, 14 Jun 2012 07:47:18 -0500
From: "Rodney Barnett" <ba...@pl...>
Subject: Re: [cx-oracle-users] Next Release?
To: <cx-...@li...>
Message-ID: <003101cd4a2b$d59b0d10$80d12730$@com>
Content-Type: text/plain;	charset="iso-8859-1"

That should work.  Thanks.

Rodney

-----Original Message-----
From: Anthony Tuininga [mailto:ant...@gm...]
Sent: Thursday, June 14, 2012 12:21 AM
To: cx-...@li...
Subject: Re: [cx-oracle-users] Next Release?

Hi Rodney,

Yes, I really should make a new release as it is has been some time
since the last one and there are some changes that could be released.
I'll see about getting one out in the next couple of weeks. I'd say
sooner than that but the next week looks particularly busy. :-( Hope
that works for you.

Anthony

On Wed, Jun 13, 2012 at 12:08 PM,  <ba...@pl...> wrote:
> Hi,
>
> Is there a release on the horizon? ?A client could benefit from recent
> changes and it would be easier to work with a released version.
>
> Thanks.
>
> Rodney
>
>
>
----------------------------------------------------------------------------
--
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

----------------------------------------------------------------------------
--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
cx-oracle-users mailing list
cx-...@li...
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users




------------------------------

Message: 6
Date: Wed, 20 Jun 2012 16:49:16 +0200
From: Michael Freylinger <mic...@gm...>
Subject: [cx-oracle-users] 'ImportError: DLL load failed' only happens
	with	Apache WSGI
To: cx-...@li...
Message-ID:
	<CAO4poPhoEv70Omghn7WaDfcYE9pGL_uWO7SOJebGW=PSO...@ma...>
Content-Type: text/plain; charset=ISO-8859-1

Hi everybody,

I can import cx_Oracle from Python console.
I can import cx_Oracle from a CGI script run by Apache (and I can
connect to my database and run SQL queries).
But I CANNOT import cx_Oracle from a WSGI script run by Apache.

Apache logs the error 'ImportError: DLL load failed: The specified
module could not be found.'
'import cx_Oracle' is the first statement of my CGI and WSGI script.
I printed the os.environ in both CGI and WSGI scripts and the only
Oracle related stuff is in variable PATH which contains
'C:\oraclexe\app\oracle\product\11.2.0\server\bin', which is present
in both cases.
So what could be different in WSGI that makes the import fail?

Software:
Operating system = 'Windows-XP-5.1.2600-SP3'
Python version = '2.7.3 (default, Apr 10 2012, 23:31:26) [MSC v.1500
32 bit (Intel)]'
SERVER_SOFTWARE = Apache/2.2.22 (Win32) mod_wsgi/3.3 Python/2.7.3
cx_Oracle module version = '5.1.1'
Oracle client version = (11, 2, 0, 2, 0)



------------------------------

Message: 7
Date: Sat, 30 Jun 2012 21:47:11 -0600
From: Anthony Tuininga <ant...@gm...>
Subject: Re: [cx-oracle-users] Next Release?
To: cx-...@li...
Message-ID:
	<CAE1XR-7ZEFLTzVNAB+HFo2hgibeWNexduM3pCtwQ_=+xk...@ma...>
Content-Type: text/plain; charset=ISO-8859-1

Hi Rodney,

I have run into some difficulties with my virtual machines due to some
upgrades and the fact that I haven't used them for some time! So
things have been delayed longer than expected.... :-( Should have them
resolved shortly, though. Depending on which Python version and OS you
require, though, I can focus on resolving the difficulties with that
one first instead of the others.

Anthony

On Thu, Jun 14, 2012 at 6:47 AM, Rodney Barnett
<ba...@pl...> wrote:
> That should work. ?Thanks.
>
> Rodney
>
> -----Original Message-----
> From: Anthony Tuininga [mailto:ant...@gm...]
> Sent: Thursday, June 14, 2012 12:21 AM
> To: cx-...@li...
> Subject: Re: [cx-oracle-users] Next Release?
>
> Hi Rodney,
>
> Yes, I really should make a new release as it is has been some time
> since the last one and there are some changes that could be released.
> I'll see about getting one out in the next couple of weeks. I'd say
> sooner than that but the next week looks particularly busy. :-( Hope
> that works for you.
>
> Anthony
>
> On Wed, Jun 13, 2012 at 12:08 PM, ?<ba...@pl...>
wrote:
>> Hi,
>>
>> Is there a release on the horizon? ?A client could benefit from recent
>> changes and it would be easier to work with a released version.
>>
>> Thanks.
>>
>> Rodney
>>
>>
>>
> --------------------------------------------------------------------------
--
> --
>> Live Security Virtual Conference
>> Exclusive live event will cover all the ways today's security and
>> threat landscape has changed and how IT managers can respond. Discussions
>> will include endpoint security, mobile security and the latest in malware
>> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
>> _______________________________________________
>> cx-oracle-users mailing list
>> cx-...@li...
>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
> --------------------------------------------------------------------------
--
> --
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>
> --------------------------------------------------------------------------
----
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users



------------------------------

----------------------------------------------------------------------------
--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/

------------------------------

_______________________________________________
cx-oracle-users mailing list
cx-...@li...
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users


End of cx-oracle-users Digest, Vol 72, Issue 1
**********************************************

Re: [cx-oracle-users] Next Release?

[Anthony T. <ant...@gm...>]

Hi Rodney,

I have run into some difficulties with my virtual machines due to some
upgrades and the fact that I haven't used them for some time! So
things have been delayed longer than expected.... :-( Should have them
resolved shortly, though. Depending on which Python version and OS you
require, though, I can focus on resolving the difficulties with that
one first instead of the others.

Anthony

On Thu, Jun 14, 2012 at 6:47 AM, Rodney Barnett
<ba...@pl...> wrote:
> That should work.  Thanks.
>
> Rodney
>
> -----Original Message-----
> From: Anthony Tuininga [mailto:ant...@gm...]
> Sent: Thursday, June 14, 2012 12:21 AM
> To: cx-...@li...
> Subject: Re: [cx-oracle-users] Next Release?
>
> Hi Rodney,
>
> Yes, I really should make a new release as it is has been some time
> since the last one and there are some changes that could be released.
> I'll see about getting one out in the next couple of weeks. I'd say
> sooner than that but the next week looks particularly busy. :-( Hope
> that works for you.
>
> Anthony
>
> On Wed, Jun 13, 2012 at 12:08 PM,  <ba...@pl...> wrote:
>> Hi,
>>
>> Is there a release on the horizon?  A client could benefit from recent
>> changes and it would be easier to work with a released version.
>>
>> Thanks.
>>
>> Rodney
>>
>>
>>
> ----------------------------------------------------------------------------
> --
>> Live Security Virtual Conference
>> Exclusive live event will cover all the ways today's security and
>> threat landscape has changed and how IT managers can respond. Discussions
>> will include endpoint security, mobile security and the latest in malware
>> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
>> _______________________________________________
>> cx-oracle-users mailing list
>> cx-...@li...
>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
> ----------------------------------------------------------------------------
> --
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

[cx-oracle-users] 'ImportError: DLL load failed' only happens with Apache WSGI

[Michael F. <mic...@gm...>]

Hi everybody,

I can import cx_Oracle from Python console.
I can import cx_Oracle from a CGI script run by Apache (and I can
connect to my database and run SQL queries).
But I CANNOT import cx_Oracle from a WSGI script run by Apache.

Apache logs the error 'ImportError: DLL load failed: The specified
module could not be found.'
'import cx_Oracle' is the first statement of my CGI and WSGI script.
I printed the os.environ in both CGI and WSGI scripts and the only
Oracle related stuff is in variable PATH which contains
'C:\oraclexe\app\oracle\product\11.2.0\server\bin', which is present
in both cases.
So what could be different in WSGI that makes the import fail?

Software:
Operating system = 'Windows-XP-5.1.2600-SP3'
Python version = '2.7.3 (default, Apr 10 2012, 23:31:26) [MSC v.1500
32 bit (Intel)]'
SERVER_SOFTWARE = Apache/2.2.22 (Win32) mod_wsgi/3.3 Python/2.7.3
cx_Oracle module version = '5.1.1'
Oracle client version = (11, 2, 0, 2, 0)

Re: [cx-oracle-users] Next Release?

[Rodney B. <ba...@pl...>]

That should work.  Thanks.

Rodney

-----Original Message-----
From: Anthony Tuininga [mailto:ant...@gm...] 
Sent: Thursday, June 14, 2012 12:21 AM
To: cx-...@li...
Subject: Re: [cx-oracle-users] Next Release?

Hi Rodney,

Yes, I really should make a new release as it is has been some time
since the last one and there are some changes that could be released.
I'll see about getting one out in the next couple of weeks. I'd say
sooner than that but the next week looks particularly busy. :-( Hope
that works for you.

Anthony

On Wed, Jun 13, 2012 at 12:08 PM,  <ba...@pl...> wrote:
> Hi,
>
> Is there a release on the horizon?  A client could benefit from recent
> changes and it would be easier to work with a released version.
>
> Thanks.
>
> Rodney
>
>
>
----------------------------------------------------------------------------
--
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

----------------------------------------------------------------------------
--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
cx-oracle-users mailing list
cx-...@li...
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

Re: [cx-oracle-users] Next Release?

[Anthony T. <ant...@gm...>]

Hi Rodney,

Yes, I really should make a new release as it is has been some time
since the last one and there are some changes that could be released.
I'll see about getting one out in the next couple of weeks. I'd say
sooner than that but the next week looks particularly busy. :-( Hope
that works for you.

Anthony

On Wed, Jun 13, 2012 at 12:08 PM,  <ba...@pl...> wrote:
> Hi,
>
> Is there a release on the horizon?  A client could benefit from recent
> changes and it would be easier to work with a released version.
>
> Thanks.
>
> Rodney
>
>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

[cx-oracle-users] Next Release?

[<ba...@pl...>]

Hi,

Is there a release on the horizon?  A client could benefit from recent
changes and it would be easier to work with a released version.

Thanks.

Rodney

Re: [cx-oracle-users] ORA-01461: can bind a LONG value only for insert into a LONG column

[Rodney B. <ba...@pl...>]

Maybe this is the same problem I ran into about a year ago.  I posted some
patches to the cx_Oracle tests to illustrate:
http://sourceforge.net/mailarchive/forum.php?thread_name=001201cc1bd9%248295
5660%2487c00320%24%40com&forum_name=cx-oracle-users

I don't know how to fix the problem, but I think I avoided it by converting
my unicode values to str.

Rodney

-----Original Message-----
From: Shubhanan Bakre [mailto:sb...@et...] 
Sent: Monday, June 04, 2012 8:28 PM
To: cx-...@li...
Subject: [cx-oracle-users] ORA-01461: can bind a LONG value only for insert
into a LONG column

Hi,

I have this strange issue when inserting a unicode string into a
varchar2(4000 byte) field.
cx_Oracle tries to bind it to a LONG value, however all the characters in
the string are English.

Table ddl:

CREATE TABLE TEST(
"NOTES" VARCHAR2(4000 BYTES)
);

INSERT INTO TEST (NOTES) VALUES (:NOTES);

The python value dict for the above insert is as follows:
{'NOTES': u'
'}

This throws the following error:
ORA-01461: can bind a LONG value only for insert into a LONG column

Any help will be appreciated.
Thanks!
Shubhanan
----------------------------------------------------------------------------
--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
cx-oracle-users mailing list
cx-...@li...
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

[cx-oracle-users] ORA-01461: can bind a LONG value only for insert into a LONG column

[Shubhanan B. <sb...@et...>]

Hi,

I have this strange issue when inserting a unicode string into a varchar2(4000 byte) field.
cx_Oracle tries to bind it to a LONG value, however all the characters in the string are English.

Table ddl:

CREATE TABLE TEST(
"NOTES" VARCHAR2(4000 BYTES)
);

INSERT INTO TEST (NOTES) VALUES (:NOTES);

The python value dict for the above insert is as follows:
{'NOTES': u'                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   '}

This throws the following error:
ORA-01461: can bind a LONG value only for insert into a LONG column

Any help will be appreciated.
Thanks!
Shubhanan

Re: [cx-oracle-users] Strange problem with query execution...

[Thierry F. <thi...@on...>]

Le Thu, 31 May 2012 10:52:04 -0700,
  Mark Harrison <mh...@pi...> a écrit:

> On 5/31/12 12:27 AM, Thierry Florac wrote:
> >
> > Hi Christian,
> >
> > No, I didn't found any solution until now.
> > I asked SQLAlchemy mailing list and afterwards cx_Oracle ML, which
> > redirected me to several Oracle links.
> > I made several checks (only using cx_Oracle) and the conclusion is
> > that :
> >   - if I execute the query generated by SQLAlchemy, using query
> >     parameters, the index is NOT used
> >   - but if I execute the same query using hard-coded parameters, the
> >     index is used and the execution time is correct :-/
> 
> 
> short version:
> 
> The solution for us was to simply regather statistics using
> DBMS_STATS.GATHER_TABLE_STATS.
> 
> long version:
> 
> I had a similar problem... I'm no expert, but here's the basic idea:
> 
> - execution plans get reused
> - it's possible to have a "bad" execution plan which gets reused
> 
> For example, suppose you have a column FOO with a yes/no value and a
> million rows, all of which have FOO = 1.  It's likely that if you
> have WHERE FOO = 1, the planner will know that a full table scan will
> be more efficient than an index scan.
> 
> But, suppose the data changes, so that only 100 rows have FOO = 1.
> Then obviously an index scan will be more efficient.
> 
> But if the query has parameters, (FOO = :1), then [handwaving, coz I
> wasn't quite following the explanation], the execution planner doesn't
> get reinvoked since it's not obvious to oracle that the row
> percentages has changed.
> 
> Regathering statistics invalidated the plans based on old statistics
> and made our query faster.


I'll forward your message to our DBA as soon as she come back from
holidays, to try to use this package.
I'll reply to the ML to give our feedback.

Best regards,
Thierry
-- 
  Chef de projets internet/intranet
  Office National des Forêts
  Direction des Systèmes d'Information
  2, Avenue de Saint Mandé
  75570 PARIS Cedex 12

  Tél. : 01 40 19 59 64
  Fax. : 01 40 19 59 85
  Mél. : thi...@on...
  WWW  : http://www.onf.fr