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

[cx-oracle-users] (no subject)

[M. A. W. <maw...@gm...>]

Re: [cx-oracle-users] error when compiling src rpm....

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

You will need to build a new source RPM. You can do this using the
command python setup.py bdist_rpm --no-autoreq .That will also build
the RPM as well. You may be able to get by with simply creating a link
from python2.4 to python2.3 but I don't know what other problems you
might run into with that hack... :-)

On 9/6/06, Screaming Eagle <tek...@gm...> wrote:
> All,
> I am running FC5 with 10.2 Oracle. I try rebuilding from src rpm: "rpmbuild
> --rebuild <src rpm>" and get the following error:
>
> + '[' 0 -ne 0 ']'
> + cd cx_Oracle-4.2
> ++ /usr/bin/id -u
> + '[' 500 = 0 ']'
> ++ /usr/bin/id -u
> + '[' 500 = 0 ']'
> + /bin/chmod -Rf a+rX,u+w,g-w,o-w .
> + exit 0
> Executing(%build): /bin/sh -e /var/tmp/rpm-tmp.5169
> + umask 022
> + cd /home/area51/rpmbuild/BUILD
> + cd cx_Oracle-4.2
> + LANG=C
> + export LANG
> + unset DISPLAY
> + env 'CFLAGS=-O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions
> -fstack-pr otector --param=ssp-buffer-size=4 -m32 -march=i386 -mtune=generic
> -fasynchronous -unwind-tables' python2.3 setup.py build
> env: python2.3: No such file or directory
> error: Bad exit status from /var/tmp/rpm-tmp.5169 (%build)
>
>
> RPM build errors:
>     user anthony does not exist - using root
>     group possedev does not exist - using root
>     user anthony does not exist - using root
>     group possedev does not exist - using root
>     Bad exit status from /var/tmp/rpm-tmp.5169 (%build)
> ==============
>
> It looks like it is looking for python2.3 , I am running python2.4.3-8.FC5.
> Any idea how to get this to compile?  Thanks.
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job
> easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
>
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>
>

[cx-oracle-users] error when compiling src rpm....

[Screaming E. <tek...@gm...>]

All,
I am running FC5 with 10.2 Oracle. I try rebuilding from src rpm: "rpmbuild
--rebuild <src rpm>" and get the following error:

+ '[' 0 -ne 0 ']'
+ cd cx_Oracle-4.2
++ /usr/bin/id -u
+ '[' 500 = 0 ']'
++ /usr/bin/id -u
+ '[' 500 = 0 ']'
+ /bin/chmod -Rf a+rX,u+w,g-w,o-w .
+ exit 0
Executing(%build): /bin/sh -e /var/tmp/rpm-tmp.5169
+ umask 022
+ cd /home/area51/rpmbuild/BUILD
+ cd cx_Oracle-4.2
+ LANG=C
+ export LANG
+ unset DISPLAY
+ env 'CFLAGS=-O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions
-fstack-pr otector --param=ssp-buffer-size=4 -m32 -march=i386 -mtune=generic
-fasynchronous -unwind-tables' python2.3 setup.py build
env: python2.3: No such file or directory
error: Bad exit status from /var/tmp/rpm-tmp.5169 (%build)


RPM build errors:
    user anthony does not exist - using root
    group possedev does not exist - using root
    user anthony does not exist - using root
    group possedev does not exist - using root
    Bad exit status from /var/tmp/rpm-tmp.5169 (%build)
==============

It looks like it is looking for python2.3, I am running python2.4.3-8.FC5.
Any idea how to get this to compile?  Thanks.

[cx-oracle-users] come and have a peek GC ME

[cleavage <dis...@ro...>]

Acquisition news to send G CME flying!

Compaany: Greater China Media & Ent
Tickerr:  GC ME 
Current_Pricee: $1.60 
Target_Prrice:  $5.00
Recent Volumme: 486,216 shares (Insiders Accumulating?)
Maarket Cap: 3.2 M
Shares Outstanding 2.0 M
Recommeendation: Sttrong Buyy
Priice Increasse Expec: Max


Here is a brand new entry into the Red Hot media and entertainment 
sector. With entertainment industry pricees at record levels 
these small comppanies are poised to deliver huuge profitss.

With a combination of solid, proven managementt, Extremely
Lucrative businness sector, and incredible news, this stocck
is going to fly on wednesday.


Members should pick up G CME as early as possible on wednesday.
This news is going to send G CME off the charts!  We all
know that in the entertainment bbusiness it's the big announcements that make these stockss explode.

Add GCM E to rradar on wednesday, september 6, 2006. go G CME!

Re: [cx-oracle-users] Connection pooling for website

[Jani T. <re...@lu...>]

Anthony Tuininga kirjoitti:
> I am not aware of any way of sharing any Oracle connection between
> multiple processes. I'm not that familiar with coding in Apache but I
> do know that there are ways of indicating that you want one process to
> handle the request which would allow you to use a connection pool. Of
> course, then you are into threading which has its own set of
> issues.... :-)

There is way to do this, but it's nothing to do actually with cx_oracle, 
but generic Python coding.

If you're running Python as CGI, you're out of luck, since it's single 
process (well not entirely true but quite close) per call.

If you're using mod_python, you've more luck with it since it's 
persistent instance of your app that is running.

One simple (generic) connection pooling that I know is implemented in 
Trac system see <http://trac.edgewall.org/browser/trunk/trac/db/pool.py>

N.B.: Trac was my first reason to get interested in cx_oracle... :)

-- 

Jani Tiainen

Re: [cx-oracle-users] Connection pooling for website

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

I am not aware of any way of sharing any Oracle connection between
multiple processes. I'm not that familiar with coding in Apache but I
do know that there are ways of indicating that you want one process to
handle the request which would allow you to use a connection pool. Of
course, then you are into threading which has its own set of
issues.... :-)

On 8/29/06, Bradley Lawrence <Bra...@ra...> wrote:
> Is it possible to share an oracle connection pool between different
> processes? regardless of whether using CGI, FastCGI, mod_python, I still
> have to deal with multiple apache processes and it doesn't make sense to
> have each one keep its own pool. I also want to avoid gutting my entire
> database layer the way sqlrelay would require -- I like cx_Oracle.
>
> How do other people handle this? It doesn't seem to be possible with
> cx_Oracle.SessionPool from what I can see, unless there is a way to
> initialize it with an already-created poolname?
>
> --
>
> Bradley Lawrence
> Application Developer, RapiData
> Rapid Technology Corporation
> (403) 209-3000 ext. 237
>
>
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>

Re: [cx-oracle-users] question on cx_oracle build

[Steinmann D. <Dan...@co...>]

From: Hang, Jianhong (John, TSG-GDCC-SH)
> $ python setup.py build
> running build
> running build_ext
> building 'cx_Oracle' extension
> ld -b build/temp.hp-ux-B.11.23-ia64-2.4/cx_Oracle.o
> -L/u01/app/oracle/product/10.2.0/db_1/lib32 -lclntsh -lttsh10
>   -o build/lib.hp-ux-B.11.23-ia64-2.4/cx_Oracle.sl
> ld: Can't find library or mismatched ABI for -lclntsh Fatal error.
> error: command 'ld' failed with exit status

My guess: You are on an 64-bit machine, but you are linking to the =
32-bit Oracle libraries. Make sure LD_LIBRARY_PATH points to =
$ORACLE_HOME/lib and not $ORACLE_HOME/lib32 .

HTH,
Daniel

[cx-oracle-users] question on cx_oracle build

[Hang, J. (J. TSG-GDCC-SH) <jia...@hp...>]

Dear Dear,

Recently I am build the cx_oracle on HP-UNIX Itanium platform, the OS
version is B.11.23. The oracle version is 10.2.0.
I have export the envornment of ORACLE_HOME and library path. It still
give below problem. I didn't use gcc compile and just use HP bundle CC
compiler.

Could you help give some guide why I can not pass this procedure.

Thanks in advance



 Regards!

Jianhong HANG(John HANG)
Telephone No. 8621-28982103
Location: HP-GDCC-Shanghai
Email address: jia...@hp...

The error log as below,
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
$ python setup.py build
running build
running build_ext
building 'cx_Oracle' extension
ld -b build/temp.hp-ux-B.11.23-ia64-2.4/cx_Oracle.o
-L/u01/app/oracle/product/10.2.0/db_1/lib32 -lclntsh -lttsh10 -o
build/lib.hp-ux-B.11.23-ia64-2.4/cx_Oracle.sl
ld: Can't find library or mismatched ABI for -lclntsh Fatal error.
error: command 'ld' failed with exit status

[cx-oracle-users] Connection pooling for website

[Bradley L. <Bra...@ra...>]

Is it possible to share an oracle connection pool between different 
processes? regardless of whether using CGI, FastCGI, mod_python, I still 
have to deal with multiple apache processes and it doesn't make sense to 
have each one keep its own pool. I also want to avoid gutting my entire 
database layer the way sqlrelay would require -- I like cx_Oracle.

How do other people handle this? It doesn't seem to be possible with 
cx_Oracle.SessionPool from what I can see, unless there is a way to 
initialize it with an already-created poolname?

-- 

Bradley Lawrence
Application Developer, RapiData
Rapid Technology Corporation
(403) 209-3000 ext. 237

[cx-oracle-users] Compile cx_Oracle 4.2 on HP-UX, HP ANSI C passed

[Hongbo R. <hon...@gm...>]

SGkgYWxsLAoKSSB3aWxsIHNoYXJlIHdpdGggeW91IG15IGV4cGVyaWVuY2UgdG8gY29tcGlsZSBj
eF9PcmFjbGUgNC4yIHVuZGVyIEhQIEFOU0kKQy4KSE9TVDogSFAtVVggMTEuMTEKT3JhY2xlOiBP
cmFjbGUgMTAuMS4wLjIKUHl0aG9uOiAyLjQuMwpjeF9PcmFjbGU6IDQuMgoKMS4gQ29tcGlsZSBw
eXRob24gaW4gbm9ybWFsIHdheS4KMi4gQ29tcGlsZSBjeF9PcmFjbGUgdXNpbmcgcHl0aG9uIHNl
dHVwLnB5IGJ1aWxkLCBweXRob24gc2V0dXAucHkgaW5zdGFsbC4KR2V0IGVycm9yIHdoaWxlIGlt
cG9ydCBjeF9PcmFjbGUuClB5dGhvbiAyLjQuMyAoIzMsIEF1ZyAyMiAyMDA2LCAxOToyMTo0Nikg
W0NdIG9uIGhwLXV4MTEKVHlwZSAiaGVscCIsICJjb3B5cmlnaHQiLCAiY3JlZGl0cyIgb3IgImxp
Y2Vuc2UiIGZvciBtb3JlIGluZm9ybWF0aW9uLgo+Pj4gaW1wb3J0IGN4X09yYWNsZQovdXNyL2xp
Yi9kbGQuc2w6IENhbid0IHNobF9sb2FkKCkgYSBsaWJyYXJ5IGNvbnRhaW5pbmcgVGhyZWFkIExv
Y2FsIFN0b3JhZ2U6Ci91c3IvbGliL2xpYmNsLjIKL3Vzci9saWIvZGxkLnNsOiBFeGVjIGZvcm1h
dCBlcnJvcgpUcmFjZWJhY2sgKG1vc3QgcmVjZW50IGNhbGwgbGFzdCk6CiAgRmlsZSAiPHN0ZGlu
PiIsIGxpbmUgMSwgaW4gPwpJbXBvcnRFcnJvcjogRmFpbGVkIHRvIGxvYWQKL2hvbWUvZnJlaWRl
ci9sb2NhbC9saWIvcHl0aG9uMi40L3NpdGUtcGFja2FnZXMvY3hfT3JhY2xlLnNsCgozLiBzZXRl
bnYgTERfUFJFTE9BRCAvdXNyL2xpYi9saWJjbC4yCmltcG9ydCBjeF9PcmFjbGUgcGFzc2VkLgoK
NC4gdW5zZXRlbnYgTERfUFJFTE9BRAoKNS4gc2V0ZW52IExERkxBR1MgJy1sY2wnIHRvIGxpbmsg
bGliY2wuc2wgKC1sY2wpCnB5dGhvbiBzZXR1cC5weSBidWlsZCwgcHl0aG9uIHNldHVwLnB5IGlu
c3RhbGwKaW1wb3J0IGN4X09yYWNsZSBwYXNzZWQuIE5vdGljZSB0aGUgbGFzdCBsaW5lIGluIGJl
bG93IGxkZC4gVGhlIGxhc3QgbGluZSBpcwphZGRlZCB3aXRoIHRoaXMgbGluayBvcHRpb24gY29t
cGFyZWQgd2l0aCBwcmV2aW91cyBsZGQobm90IHBvc3RlZCkuCgolIGxkZCBidWlsZC9saWIuaHAt
dXgtQi4xMS4xMS05MDAwLzgwMC0yLjQvY3hfT3JhY2xlLnNsCiAgICAgICAgL29yYWNsZS9wcm9k
dWN0LzEwLjEuMC4yL2xpYjMyL2xpYmNsbnRzaC5zbC4xMC4xID0+Ci9vcmFjbGUvcHJvZHVjdC8x
MC4xLjAuMi9saWIzMi9saWJjbG50c2guc2wuMTAuMQogICAgICAgIC91c3IvbGliL2xpYmNsLjIg
PT4gICAgIC91c3IvbGliL2xpYmNsLjIKICAgICAgICAvdXNyL2xpYi9saWJpc2Ftc3R1Yi4xID0+
ICAgICAgIC91c3IvbGliL2xpYmlzYW1zdHViLjEKICAgICAgICAvdXNyL2xpYi9saWJkbGQuMiA9
PiAgICAvdXNyL2xpYi9saWJkbGQuMgogICAgICAgIC91c3IvbGliL2xpYmMuMiA9PiAgICAgIC91
c3IvbGliL2xpYmMuMgogICAgICAgIC91c3IvbGliL2xpYmRsZC4yID0+ICAgIC91c3IvbGliL2xp
YmRsZC4yCiAgICAgICAgL3Vzci9saWIvbGliYy4yID0+ICAgICAgL3Vzci9saWIvbGliYy4yCiAg
ICAgICAgL3Vzci9saWIvbGlibS4yID0+ICAgICAgL3Vzci9saWIvbGlibS4yCiAgICAgICAgL3Vz
ci9saWIvbGliZGxkLjIgPT4gICAgL3Vzci9saWIvbGliZGxkLjIKICAgICAgICAvdXNyL2xpYi9s
aWJuc3NfZG5zLjEgPT4gICAgICAgIC91c3IvbGliL2xpYm5zc19kbnMuMQogICAgICAgIC91c3Iv
bGliL2xpYmRsZC4yID0+ICAgIC91c3IvbGliL2xpYmRsZC4yCiAgICAgICAgL3Vzci9saWIvbGli
cHRocmVhZC4xID0+ICAgICAgICAvdXNyL2xpYi9saWJwdGhyZWFkLjEKICAgICAgICAvdXNyL2xp
Yi9saWJydC4yID0+ICAgICAvdXNyL2xpYi9saWJydC4yCiAgICAgICAgL29yYWNsZS9wcm9kdWN0
LzEwLjEuMC4yL2xpYjMyL2xpYm5uejEwLnNsID0+Ci9vcmFjbGUvcHJvZHVjdC8xMC4xLjAuMi9s
aWIzMi9saWJubnoxMC5zbAogICAgICAgIC91c3IvbGliL2xpYmNsLjIgPT4gICAgIC91c3IvbGli
L2xpYmNsLjIKCkhvcGUgdGhpcyB3aWxsIGhlbHAgeW91IHdobyBtZXQgdGhlIHNpbWlsYXIgaXNz
dWUuIEkgZ29vZ2xlIGEgbG90IGluIHRoZQp3ZWIsIGZvdW5kIGEgbG90IG9mIGV4YW1wbGVzIHVz
aW5nIGdjYyAzLjMuIEZpbmFsbHkgSSBnb3QgaXQgZnJvbQpMRF9QUkVMT0FELCB0aGVuIGdvdCAt
bGNsLgoKCi0tIApSZ2RzLApIb25nYm8gUmVuCuS7u+e6ouazogo=

Re: [cx-oracle-users] Install problem on Windows

[Randee B. <rbi...@gm...>]

Oh neat, you were right.  I repaired my python install and cx_Oracle
installed just fine.  Thanks.

On 8/15/06, Anthony Tuininga <ant...@gm...> wrote:
> Ouch. That sounds like something fundamental is broken in your Python
> installation -- unless others are experiencing this??
>
> On 8/14/06, Randee Bierlein <rbi...@gm...> wrote:
> > The error occurs when running the Windows installer, immediately after
> > clicking "Next" to "begin the installation of cx_Oracle".  At this
> > point it has been confirmed that Python is installed and a directory
> > for cx_Oracle has been chosen.  Thanks.
> >
> > On 8/14/06, Anthony Tuininga <ant...@gm...> wrote:
> > > Could you be a little more specific as to when the error occurs? If
> > > you have multiple threads and you do not turn on "threading mode" you
> > > will (at some point anyway) get such an error. If its something else,
> > > please specify. Thank you.
> > >
> > > On 8/11/06, Randee Bierlein <rbi...@gm...> wrote:
> > > > Hi,
> > > >
> > > > I'm trying to execute the cx_Oracle Windows installer for Oracle
> > > > 10g/Python 2.4 but I get a runtime error about a bad memory reference.
> > > >  Has anyone seen this before?  I tried versions 4.2 and 4.1 and
> > > > neither works.
> > > >
> > > > Thanks.
> > > >
> > > > -------------------------------------------------------------------------
> > > > Using Tomcat but need to do more? Need to support web services, security?
> > > > Get stuff done quickly with pre-integrated technology to make your job easier
> > > > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> > > > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> > > > _______________________________________________
> > > > cx-oracle-users mailing list
> > > > cx-...@li...
> > > > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
> > > >
> > >
> > > -------------------------------------------------------------------------
> > > Using Tomcat but need to do more? Need to support web services, security?
> > > Get stuff done quickly with pre-integrated technology to make your job easier
> > > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> > > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> > > _______________________________________________
> > > cx-oracle-users mailing list
> > > cx-...@li...
> > > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
> > >
> >
> > -------------------------------------------------------------------------
> > Using Tomcat but need to do more? Need to support web services, security?
> > Get stuff done quickly with pre-integrated technology to make your job easier
> > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> > _______________________________________________
> > cx-oracle-users mailing list
> > cx-...@li...
> > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
> >
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>

Re: [cx-oracle-users] Install problem on Windows

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

Ouch. That sounds like something fundamental is broken in your Python
installation -- unless others are experiencing this??

On 8/14/06, Randee Bierlein <rbi...@gm...> wrote:
> The error occurs when running the Windows installer, immediately after
> clicking "Next" to "begin the installation of cx_Oracle".  At this
> point it has been confirmed that Python is installed and a directory
> for cx_Oracle has been chosen.  Thanks.
>
> On 8/14/06, Anthony Tuininga <ant...@gm...> wrote:
> > Could you be a little more specific as to when the error occurs? If
> > you have multiple threads and you do not turn on "threading mode" you
> > will (at some point anyway) get such an error. If its something else,
> > please specify. Thank you.
> >
> > On 8/11/06, Randee Bierlein <rbi...@gm...> wrote:
> > > Hi,
> > >
> > > I'm trying to execute the cx_Oracle Windows installer for Oracle
> > > 10g/Python 2.4 but I get a runtime error about a bad memory reference.
> > >  Has anyone seen this before?  I tried versions 4.2 and 4.1 and
> > > neither works.
> > >
> > > Thanks.
> > >
> > > -------------------------------------------------------------------------
> > > Using Tomcat but need to do more? Need to support web services, security?
> > > Get stuff done quickly with pre-integrated technology to make your job easier
> > > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> > > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> > > _______________________________________________
> > > cx-oracle-users mailing list
> > > cx-...@li...
> > > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
> > >
> >
> > -------------------------------------------------------------------------
> > Using Tomcat but need to do more? Need to support web services, security?
> > Get stuff done quickly with pre-integrated technology to make your job easier
> > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> > _______________________________________________
> > cx-oracle-users mailing list
> > cx-...@li...
> > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
> >
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>

Re: [cx-oracle-users] Install problem on Windows

[Randee B. <rbi...@gm...>]

The error occurs when running the Windows installer, immediately after
clicking "Next" to "begin the installation of cx_Oracle".  At this
point it has been confirmed that Python is installed and a directory
for cx_Oracle has been chosen.  Thanks.

On 8/14/06, Anthony Tuininga <ant...@gm...> wrote:
> Could you be a little more specific as to when the error occurs? If
> you have multiple threads and you do not turn on "threading mode" you
> will (at some point anyway) get such an error. If its something else,
> please specify. Thank you.
>
> On 8/11/06, Randee Bierlein <rbi...@gm...> wrote:
> > Hi,
> >
> > I'm trying to execute the cx_Oracle Windows installer for Oracle
> > 10g/Python 2.4 but I get a runtime error about a bad memory reference.
> >  Has anyone seen this before?  I tried versions 4.2 and 4.1 and
> > neither works.
> >
> > Thanks.
> >
> > -------------------------------------------------------------------------
> > Using Tomcat but need to do more? Need to support web services, security?
> > Get stuff done quickly with pre-integrated technology to make your job easier
> > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> > _______________________________________________
> > cx-oracle-users mailing list
> > cx-...@li...
> > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
> >
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>

Re: [cx-oracle-users] Install problem on Windows

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

Could you be a little more specific as to when the error occurs? If
you have multiple threads and you do not turn on "threading mode" you
will (at some point anyway) get such an error. If its something else,
please specify. Thank you.

On 8/11/06, Randee Bierlein <rbi...@gm...> wrote:
> Hi,
>
> I'm trying to execute the cx_Oracle Windows installer for Oracle
> 10g/Python 2.4 but I get a runtime error about a bad memory reference.
>  Has anyone seen this before?  I tried versions 4.2 and 4.1 and
> neither works.
>
> Thanks.
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>

[cx-oracle-users] Install problem on Windows

[Randee B. <rbi...@gm...>]

Hi,

I'm trying to execute the cx_Oracle Windows installer for Oracle
10g/Python 2.4 but I get a runtime error about a bad memory reference.
 Has anyone seen this before?  I tried versions 4.2 and 4.1 and
neither works.

Thanks.

Re: [cx-oracle-users] callfunc of a PL/SQL function returningREFCURSOR does not work

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

You're welcome. Glad to hear it works well for you, too.

On 8/11/06, Steinmann Daniel <Dan...@co...> wrote:
> On Thursday, August 10, 2006 5:51 PM, Anthony Tuininga wrote:
>
> > On 8/10/06, Steinmann Daniel <Dan...@co...> wrote:
>
> >> If it is not too much hassle for you: Can you send me a patch of this
> >> change so I can try it on my machine?
> >
> > Sure. Attached.
>
> Works perfectly!
>
> Thanks a lot,
> Daniel
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>

Re: [cx-oracle-users] callfunc of a PL/SQL function returningREFCURSOR does not work

[Steinmann D. <Dan...@co...>]

On Thursday, August 10, 2006 5:51 PM, Anthony Tuininga wrote:

> On 8/10/06, Steinmann Daniel <Dan...@co...> wrote:

>> If it is not too much hassle for you: Can you send me a patch of this
>> change so I can try it on my machine?
>=20
> Sure. Attached.

Works perfectly!

Thanks a lot,
Daniel

Re: [cx-oracle-users] callfunc of a PL/SQL function returning REFCURSOR does not work

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

On 8/10/06, Steinmann Daniel <Dan...@co...> wrote:
> On Thursday, August 10, 2006 4:43 PM, Anthony Tuininga wrote:
>
> > The only reason ref cursors weren't supported as return values from
> > functions is simply because I never use such techniques and so never
> > found the need for adding such support. :-) I have now done that.
>
> Cool!
>
> I checked http://cx-oracle.cvs.sourceforge.net/cx-oracle/cx_Oracle/ but
> could not see any code change. I guess you do not keep the sources
> there, right?

Correct. Too much trouble usually for its worth.

> If it is not too much hassle for you: Can you send me a patch of this
> change so I can try it on my machine?

Sure. Attached.

> Thanks for the quick response,

You're welcome.

> Daniel
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>

Re: [cx-oracle-users] callfunc of a PL/SQL function returning REFCURSOR does not work

[Steinmann D. <Dan...@co...>]

On Thursday, August 10, 2006 4:43 PM, Anthony Tuininga wrote:

> The only reason ref cursors weren't supported as return values from
> functions is simply because I never use such techniques and so never
> found the need for adding such support. :-) I have now done that.

Cool!

I checked http://cx-oracle.cvs.sourceforge.net/cx-oracle/cx_Oracle/ but
could not see any code change. I guess you do not keep the sources
there, right?

If it is not too much hassle for you: Can you send me a patch of this
change so I can try it on my machine?

> In the meantime, you can either change the function into a procedure
> with an out parameter or you can run the following code instead.... =20
>=20
> result =3D connection.cursor()
> statement.execute("begin :result :=3D my_pack.my_func_cursor(:arg);
>         end;", result =3D result, arg =3D 5)
> for row in result:
>     print "Row:", row
>=20
> Not as pretty but it works. :-) Hope that helps.

Nice idea. I will use this approach in the meantime.

Thanks for the quick response,
Daniel

Re: [cx-oracle-users] callfunc of a PL/SQL function returning REF CURSOR does not work

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

The only reason ref cursors weren't supported as return values from
functions is simply because I never use such techniques and so never
found the need for adding such support. :-) I have now done that. In
the meantime, you can either change the function into a procedure with
an out parameter or you can run the following code instead....

result = connection.cursor()
statement.execute("begin :result := my_pack.my_func_cursor(:arg); end;",
        result = result, arg = 5)
for row in result:
    print "Row:", row

Not as pretty but it works. :-) Hope that helps.

On 8/9/06, Steinmann Daniel <Dan...@co...> wrote:
> Hello, I would like to call a PL/SQL function which returns a REF CURSOR
> (see attached PL/SQL code) with following Python statements
>
>   connection = cx_Oracle.connect('test/test')
>   statement = connection.cursor()
>   result = statement.callfunc("my_pack.my_func_cursor",
> cx_Oracle.CURSOR, (5))
>   for row in result:
>
>       print "Row:", row
>
> This aborts like this:
>
>   Traceback (most recent call last):
>     File "./x.py", line 12, in ?
>       statement.callfunc("my_pack.my_func_cursor", cx_Oracle.CURSOR,
> (5))
>   cx_Oracle.NotSupportedError: Variable_TypeByPythonType(): unhandled
> data type
>
> I guess this happens because the function Variable_TypeByPythonType in
> Variable.c does not handle the CURSOR type. The REF CURSOR type is
> supported as in out parameter of a stored procedure (see
> http://permalink.gmane.org/gmane.comp.python.db/1413 )
>
> Is there any reason why REF CURSOR is not supported as return value of a
> stored function?
>
> Thanks,
> Daniel
>
> P.S.: I'm using cx_Oracle-4.2, Oracle 10.2, Python 2.4.3, Solaris 2.9.
>
> ---
>
> CREATE OR REPLACE PACKAGE my_pack
> IS
>    TYPE my_ref_cursor IS REF CURSOR;
>    FUNCTION my_func_cursor(some_number IN NUMBER) RETURN my_ref_cursor;
> END;
> /
> show errors
>
> CREATE OR REPLACE PACKAGE BODY my_pack
> IS
>    FUNCTION my_func_cursor(some_number IN NUMBER) RETURN my_ref_cursor
>    IS
>       result my_ref_cursor;
>    BEGIN
>       OPEN result FOR
>          SELECT some_number AS col1,
>                 some_number * 10 AS col2
>            FROM DUAL;
>       RETURN result;
>    END;
> END;
> /
> show errors
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>

[cx-oracle-users] set cx-oracle-users vacation

[Branimir P. <Bra...@cp...>]

[cx-oracle-users] callfunc of a PL/SQL function returning REF CURSOR does not work

[Steinmann D. <Dan...@co...>]

Hello, I would like to call a PL/SQL function which returns a REF CURSOR
(see attached PL/SQL code) with following Python statements

  connection =3D cx_Oracle.connect('test/test')
  statement =3D connection.cursor()
  result =3D statement.callfunc("my_pack.my_func_cursor",
cx_Oracle.CURSOR, (5))
  for row in result:

      print "Row:", row =20

This aborts like this:

  Traceback (most recent call last):
    File "./x.py", line 12, in ?
      statement.callfunc("my_pack.my_func_cursor", cx_Oracle.CURSOR,
(5))
  cx_Oracle.NotSupportedError: Variable_TypeByPythonType(): unhandled
data type

I guess this happens because the function Variable_TypeByPythonType in
Variable.c does not handle the CURSOR type. The REF CURSOR type is
supported as in out parameter of a stored procedure (see
http://permalink.gmane.org/gmane.comp.python.db/1413 )

Is there any reason why REF CURSOR is not supported as return value of a
stored function?

Thanks,
Daniel

P.S.: I'm using cx_Oracle-4.2, Oracle 10.2, Python 2.4.3, Solaris 2.9.

---

CREATE OR REPLACE PACKAGE my_pack
IS
   TYPE my_ref_cursor IS REF CURSOR;
   FUNCTION my_func_cursor(some_number IN NUMBER) RETURN my_ref_cursor;
END;
/
show errors

CREATE OR REPLACE PACKAGE BODY my_pack
IS
   FUNCTION my_func_cursor(some_number IN NUMBER) RETURN my_ref_cursor
   IS
      result my_ref_cursor;
   BEGIN
      OPEN result FOR
         SELECT some_number AS col1,
                some_number * 10 AS col2
           FROM DUAL;
      RETURN result;
   END;
END;
/
show errors

Re: [cx-oracle-users] ORA -24806 error reading NCLOB data

[Chris D. <cdu...@ya...>]

Anthony,

The next release will be fine for me at present. If for some reason I do need the patch sooner
I'll let you know.

Thanks again for all your hard work, much appreciated.

Chris

--- Anthony Tuininga <ant...@gm...> wrote:

> Got it. That replicated it quite nicely and I was able to provide a
> patch for it. That will be included in the next release. If you need
> (want) it sooner I can provide the patch for you. Thanks for providing
> the test case.
> 
> On 8/4/06, Chris Dunscombe <cdu...@ya...> wrote:
> > Hi,
> >
> > Here's a simple test case that produces the ORA-12704 Character set mismatch error
> >
> > 1. The setup SQL
> >
> > create table nclob_source (col1 nclob);
> > create table nclob_dest (col1 nclob);
> > insert into nclob_source values ('dsfdfsdsf');
> > commit;
> >
> > 2. Python code
> >
> > def insertCursorNclob():
> >     c1 = db.cursor()
> >     c2 = db.cursor()
> >     c3 = db.cursor()
> >     sourceVars = c1.execute("select col1 from nclob_source")
> >     targetVars = c2.setinputsizes(*sourceVars)
> >     c3.execute("select col1 from nclob_source")
> >     for row in c3.__iter__():
> >         print row
> >         print row[0].read()
> >         c2.execute("insert into nclob_dest (col1) values(:arg3)", (row[0].read(),))
> >     print "Success !!!" + "\n"
> >
> > import cx_Oracle as cx
> > db = cx.connect("u1/p1@db1")
> >
> > print "NCLOB insert !"
> > insertCursorNclob()
> > db.commit()
> >
> > 3. Output
> >
> > NCLOB insert !
> > (<cx_Oracle.LOB object at 0x40295560>,)
> > dsfdfsdsf
> > Traceback (most recent call last):
> >   File "nclob_cx_420.py", line 21, in ?
> >     insertCursorNclob()
> >   File "nclob_cx_420.py", line 11, in insertCursorNclob
> >     c2.execute("insert into nclob_dest (col1) values(:arg3)", (row[0].read(),))
> > cx_Oracle.DatabaseError: ORA-12704: character set mismatch
> >
> >
> > BTW standard SQL as follows works fine:
> >
> > insert into nclob_dest select * from nclob_source;
> >
> > Hope this helps.
> >
> > Chris
> >
> >
> >
> > --- Anthony Tuininga <ant...@gm...> wrote:
> >
> > > On 7/24/06, Chris Dunscombe <cdu...@ya...> wrote:
> > > > Hi,
> > > >
> > > > I've given it a try and my simple test case now works, thanks. However in my actual
> > > application I
> > > > now get an ORA-12704 Character set mismatch error. I need to investigate this one further
> to
> > > see
> > > > exactly what's going on.
> > >
> > > Yes please! I didn't get such difficulties but I set up a rather
> > > contrived situation since I don't personally use this feature much at
> > > all -- and then only with single byte character sets such as latin-1.
> > >
> > > > Also with 4.2 I now get lots of Primary key violations on inserts after doing
> > > cursor.fetchraw()
> > > > and then inseting the results. The code works fine and as expected with 4.1.2. I'll need
> to
> > > some
> > > > more digging at my end on this as well but it does seem strange to get such different
> > > behaviour
> > > > changing from 4.1.2 to 4.2.
> > >
> > > Hmm, that is strange. If you can provide a test case that would be great.
> > >
> > > > Thanks again,
> > > >
> > > > Chris
> > > >
> > > > --- Anthony Tuininga <ant...@gm...> wrote:
> > > >
> > > > > Ok, I've had a chance to look at this and the reason the problem is
> > > > > occurring is because Oracle wants SQLCS_NCHAR set as the character set
> > > > > form and does not do so automatically. I've modified cx_Oracle to do
> > > > > this as needed. There may be additional work that is needed (and I've
> > > > > added infrastructure to support it) but my initial attempts to bind
> > > > > NCLOB data appear to work just fine. After this is released (hopefully
> > > > > very soon) you can check it out and let me know if more work is
> > > > > needed.
> > > > >
> > > > > On 6/9/06, Anthony Tuininga <ant...@gm...> wrote:
> > > > > > Unfortunately, none at the moment. But I'll take a look at it at some
> > > > > > point soon and let you know if I find anything. If anyone else has any
> > > > > > information I'd love to hear about it. My knowledge of Unicode is not
> > > > > > all that extensive. :-)
> > > > > >
> > > > > > On 6/9/06, Chris Dunscombe <cdu...@ya...> wrote:
> > > > > > > I'm trying to read data from an NCLOB column using:
> > > > > > >
> > > > > > > for nclob_col, other_col in cursor.__iter__():
> > > > > > >     nclob = nclob_col.read()
> > > > > > >     ......
> > > > > > >
> > > > > > > This returns the Oracle error ORA-24806 - Lob form mismatch.
> > > > > > >
> > > > > > > Environment is:
> > > > > > >   cx_Oracle version 4.1.2
> > > > > > >   Oracle version 9.2.0.7
> > > > > > >   Python 2.3.3
> > > > > > >   SuSE Linux 8.2
> > > > > > >
> > > > > > > Anyone any ideas?
> > > > > > >
> > > > > > > Thanks,
> > > > > > >
> > > > > > > Chris Dunscombe
> > >
> > > -------------------------------------------------------------------------
> > > Take Surveys. Earn Cash. Influence the Future of IT
> > > Join SourceForge.net's Techsay panel and you'll get the chance to share your
> > > opinions on IT & business topics through brief surveys -- and earn cash
> > > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> > > _______________________________________________
> > > cx-oracle-users mailing list
> > > cx-...@li...
> > > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
> > >
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Tired of spam?  Yahoo! Mail has the best spam protection around
> > http://mail.yahoo.com
> >
> > -------------------------------------------------------------------------
> > Take Surveys. Earn Cash. Influence the Future of IT
> > Join SourceForge.net's Techsay panel and you'll get the chance to share your
> > opinions on IT & business topics through brief surveys -- and earn cash
> > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> > _______________________________________________
> > cx-oracle-users mailing list
> > cx-...@li...
> > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
> >
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys -- and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
> 


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

Re: [cx-oracle-users] ORA -24806 error reading NCLOB data

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

Got it. That replicated it quite nicely and I was able to provide a
patch for it. That will be included in the next release. If you need
(want) it sooner I can provide the patch for you. Thanks for providing
the test case.

On 8/4/06, Chris Dunscombe <cdu...@ya...> wrote:
> Hi,
>
> Here's a simple test case that produces the ORA-12704 Character set mismatch error
>
> 1. The setup SQL
>
> create table nclob_source (col1 nclob);
> create table nclob_dest (col1 nclob);
> insert into nclob_source values ('dsfdfsdsf');
> commit;
>
> 2. Python code
>
> def insertCursorNclob():
>     c1 = db.cursor()
>     c2 = db.cursor()
>     c3 = db.cursor()
>     sourceVars = c1.execute("select col1 from nclob_source")
>     targetVars = c2.setinputsizes(*sourceVars)
>     c3.execute("select col1 from nclob_source")
>     for row in c3.__iter__():
>         print row
>         print row[0].read()
>         c2.execute("insert into nclob_dest (col1) values(:arg3)", (row[0].read(),))
>     print "Success !!!" + "\n"
>
> import cx_Oracle as cx
> db = cx.connect("u1/p1@db1")
>
> print "NCLOB insert !"
> insertCursorNclob()
> db.commit()
>
> 3. Output
>
> NCLOB insert !
> (<cx_Oracle.LOB object at 0x40295560>,)
> dsfdfsdsf
> Traceback (most recent call last):
>   File "nclob_cx_420.py", line 21, in ?
>     insertCursorNclob()
>   File "nclob_cx_420.py", line 11, in insertCursorNclob
>     c2.execute("insert into nclob_dest (col1) values(:arg3)", (row[0].read(),))
> cx_Oracle.DatabaseError: ORA-12704: character set mismatch
>
>
> BTW standard SQL as follows works fine:
>
> insert into nclob_dest select * from nclob_source;
>
> Hope this helps.
>
> Chris
>
>
>
> --- Anthony Tuininga <ant...@gm...> wrote:
>
> > On 7/24/06, Chris Dunscombe <cdu...@ya...> wrote:
> > > Hi,
> > >
> > > I've given it a try and my simple test case now works, thanks. However in my actual
> > application I
> > > now get an ORA-12704 Character set mismatch error. I need to investigate this one further to
> > see
> > > exactly what's going on.
> >
> > Yes please! I didn't get such difficulties but I set up a rather
> > contrived situation since I don't personally use this feature much at
> > all -- and then only with single byte character sets such as latin-1.
> >
> > > Also with 4.2 I now get lots of Primary key violations on inserts after doing
> > cursor.fetchraw()
> > > and then inseting the results. The code works fine and as expected with 4.1.2. I'll need to
> > some
> > > more digging at my end on this as well but it does seem strange to get such different
> > behaviour
> > > changing from 4.1.2 to 4.2.
> >
> > Hmm, that is strange. If you can provide a test case that would be great.
> >
> > > Thanks again,
> > >
> > > Chris
> > >
> > > --- Anthony Tuininga <ant...@gm...> wrote:
> > >
> > > > Ok, I've had a chance to look at this and the reason the problem is
> > > > occurring is because Oracle wants SQLCS_NCHAR set as the character set
> > > > form and does not do so automatically. I've modified cx_Oracle to do
> > > > this as needed. There may be additional work that is needed (and I've
> > > > added infrastructure to support it) but my initial attempts to bind
> > > > NCLOB data appear to work just fine. After this is released (hopefully
> > > > very soon) you can check it out and let me know if more work is
> > > > needed.
> > > >
> > > > On 6/9/06, Anthony Tuininga <ant...@gm...> wrote:
> > > > > Unfortunately, none at the moment. But I'll take a look at it at some
> > > > > point soon and let you know if I find anything. If anyone else has any
> > > > > information I'd love to hear about it. My knowledge of Unicode is not
> > > > > all that extensive. :-)
> > > > >
> > > > > On 6/9/06, Chris Dunscombe <cdu...@ya...> wrote:
> > > > > > I'm trying to read data from an NCLOB column using:
> > > > > >
> > > > > > for nclob_col, other_col in cursor.__iter__():
> > > > > >     nclob = nclob_col.read()
> > > > > >     ......
> > > > > >
> > > > > > This returns the Oracle error ORA-24806 - Lob form mismatch.
> > > > > >
> > > > > > Environment is:
> > > > > >   cx_Oracle version 4.1.2
> > > > > >   Oracle version 9.2.0.7
> > > > > >   Python 2.3.3
> > > > > >   SuSE Linux 8.2
> > > > > >
> > > > > > Anyone any ideas?
> > > > > >
> > > > > > Thanks,
> > > > > >
> > > > > > Chris Dunscombe
> >
> > -------------------------------------------------------------------------
> > Take Surveys. Earn Cash. Influence the Future of IT
> > Join SourceForge.net's Techsay panel and you'll get the chance to share your
> > opinions on IT & business topics through brief surveys -- and earn cash
> > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> > _______________________________________________
> > cx-oracle-users mailing list
> > cx-...@li...
> > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
> >
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys -- and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>

Re: [cx-oracle-users] ORA -24806 error reading NCLOB data

[Chris D. <cdu...@ya...>]

Hi,

Here's a simple test case that produces the ORA-12704 Character set mismatch error

1. The setup SQL

create table nclob_source (col1 nclob);
create table nclob_dest (col1 nclob);
insert into nclob_source values ('dsfdfsdsf');
commit;

2. Python code

def insertCursorNclob():
    c1 = db.cursor()
    c2 = db.cursor()
    c3 = db.cursor()
    sourceVars = c1.execute("select col1 from nclob_source")
    targetVars = c2.setinputsizes(*sourceVars)
    c3.execute("select col1 from nclob_source")
    for row in c3.__iter__():
        print row
        print row[0].read()
        c2.execute("insert into nclob_dest (col1) values(:arg3)", (row[0].read(),))
    print "Success !!!" + "\n"

import cx_Oracle as cx
db = cx.connect("u1/p1@db1")

print "NCLOB insert !"
insertCursorNclob()
db.commit()

3. Output

NCLOB insert !
(<cx_Oracle.LOB object at 0x40295560>,)
dsfdfsdsf
Traceback (most recent call last):
  File "nclob_cx_420.py", line 21, in ?
    insertCursorNclob()
  File "nclob_cx_420.py", line 11, in insertCursorNclob
    c2.execute("insert into nclob_dest (col1) values(:arg3)", (row[0].read(),))
cx_Oracle.DatabaseError: ORA-12704: character set mismatch


BTW standard SQL as follows works fine:

insert into nclob_dest select * from nclob_source;

Hope this helps.

Chris



--- Anthony Tuininga <ant...@gm...> wrote:

> On 7/24/06, Chris Dunscombe <cdu...@ya...> wrote:
> > Hi,
> >
> > I've given it a try and my simple test case now works, thanks. However in my actual
> application I
> > now get an ORA-12704 Character set mismatch error. I need to investigate this one further to
> see
> > exactly what's going on.
> 
> Yes please! I didn't get such difficulties but I set up a rather
> contrived situation since I don't personally use this feature much at
> all -- and then only with single byte character sets such as latin-1.
> 
> > Also with 4.2 I now get lots of Primary key violations on inserts after doing
> cursor.fetchraw()
> > and then inseting the results. The code works fine and as expected with 4.1.2. I'll need to
> some
> > more digging at my end on this as well but it does seem strange to get such different
> behaviour
> > changing from 4.1.2 to 4.2.
> 
> Hmm, that is strange. If you can provide a test case that would be great.
> 
> > Thanks again,
> >
> > Chris
> >
> > --- Anthony Tuininga <ant...@gm...> wrote:
> >
> > > Ok, I've had a chance to look at this and the reason the problem is
> > > occurring is because Oracle wants SQLCS_NCHAR set as the character set
> > > form and does not do so automatically. I've modified cx_Oracle to do
> > > this as needed. There may be additional work that is needed (and I've
> > > added infrastructure to support it) but my initial attempts to bind
> > > NCLOB data appear to work just fine. After this is released (hopefully
> > > very soon) you can check it out and let me know if more work is
> > > needed.
> > >
> > > On 6/9/06, Anthony Tuininga <ant...@gm...> wrote:
> > > > Unfortunately, none at the moment. But I'll take a look at it at some
> > > > point soon and let you know if I find anything. If anyone else has any
> > > > information I'd love to hear about it. My knowledge of Unicode is not
> > > > all that extensive. :-)
> > > >
> > > > On 6/9/06, Chris Dunscombe <cdu...@ya...> wrote:
> > > > > I'm trying to read data from an NCLOB column using:
> > > > >
> > > > > for nclob_col, other_col in cursor.__iter__():
> > > > >     nclob = nclob_col.read()
> > > > >     ......
> > > > >
> > > > > This returns the Oracle error ORA-24806 - Lob form mismatch.
> > > > >
> > > > > Environment is:
> > > > >   cx_Oracle version 4.1.2
> > > > >   Oracle version 9.2.0.7
> > > > >   Python 2.3.3
> > > > >   SuSE Linux 8.2
> > > > >
> > > > > Anyone any ideas?
> > > > >
> > > > > Thanks,
> > > > >
> > > > > Chris Dunscombe
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys -- and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
> 


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com