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

Re: [cx-oracle-users] ping()

[Paul M. <p.f...@gm...>]

2011/1/17  <prz...@po...>:
> I have changed the code to:
>
> try:
>    con = cx_Oracle.connect('publikator/gre1czech0@HP_42_OL')
>    con.ping()
> except cx_Oracle.DatabaseError:
>    #print "*** Connection dropped ***"
>    STATUS = "DOWN"
> else:
>    STATUS= "UP"
>
> Should I avoid "cx_Oracle.DatabaseError" in the "except" clause ?

I'd personally be inclined to do something like

try:
   con = cx_Oracle.connect('xxx/yyy@zzz')
   STATUS= "UP"
   con.close()
except cx_Oracle.DatabaseError as ex:
   # check ex.args[0].code to make sure it's an error that means the
DB is down, rather than
   # something else like incorrect password...
   if ex.args[0].code in (...):
      STATUS = "DOWN"
   else:
      # Unexpected error - report it somehow (I'll just reraise here)
      raise
except Exception:
      # Unexpected error - report it somehow (I'll just reraise here -
if you are just going
      # to reraise you can omit this whole clause)
      raise

I tend to be paranoid about not letting unexpected conditions go
unreported or caught inappropriately, which is what I suspect is
happening to you here.

By the way, what results did you get from the tests I suggested below?

>> Or your database is actually up... (what Oracle logs are you looking
>> at to see that the database is down?)
>
> alert log

Of course even if the alert log shows the database as up, the listener
might be down...

>> You might want to check that the database is showing as down if you
>> connect to it via SQL*Plus. If it is, try the connect() call in the
>> interactive interpreter and see what it returns. That may help you to
>> diagnose the problem better.

Paul.

Re: [cx-oracle-users] ping()

[<prz...@po...>]

On Mon, Jan 17, 2011 at 01:36:55PM +0000, Paul Moore wrote:
> 2011/1/17  <prz...@po...>:
> > Hello,
> >
> > I have been using ping() function to test reachability of some database:
> >
> > ...
> > import cx_Oracle
> > import sys
> > from time import gmtime, strftime
> >
> > con = cx_Oracle.connect('user/pass@database')
> > try:
> >    con.ping()
> > except cx_Oracle.DatabaseError:
> >    #print "*** Connection dropped ***"
> >    STATUS = "DOWN"
> > else:
> >    STATUS= "UP"
> >
> > con.close()
> > print strftime("%Y-%m-%d %H:%M:%S", gmtime()), STATUS
> > ...
> >
> > But it doesn't work - I have checked Oracle logs and it says "UP" even
> > when database is down. What is wrong ?
> 
> I would imagine that the connect function (which is not in a try
> block) is failing. I'm not sure why your code is not therefore getting
> an unhandled exception, but assuming it doesn't, then con is probably
> not a valid connection object and con.ping is then failing with
> something like an attribute error.

I have changed the code to:

try:
    con = cx_Oracle.connect('publikator/gre1czech0@HP_42_OL')
    con.ping()
except cx_Oracle.DatabaseError:
    #print "*** Connection dropped ***"
    STATUS = "DOWN"
else:
    STATUS= "UP"

Should I avoid "cx_Oracle.DatabaseError" in the "except" clause ?

> Or your database is actually up... (what Oracle logs are you looking
> at to see that the database is down?)

alert log

> You might want to check that the database is showing as down if you
> connect to it via SQL*Plus. If it is, try the connect() call in the
> interactive interpreter and see what it returns. That may help you to
> diagnose the problem better.
> 
> Paul.

Regards
Przemyslaw Bak (przemol)
--
http://przemol.blogspot.com/





























----------------------------------------------------------------
Nie płać księgowej! Odbierz prezent.
SprawdĹş >> http://linkint.pl/f28f6

Re: [cx-oracle-users] ping()

[Paul M. <p.f...@gm...>]

2011/1/17  <prz...@po...>:
> Hello,
>
> I have been using ping() function to test reachability of some database:
>
> ...
> import cx_Oracle
> import sys
> from time import gmtime, strftime
>
> con = cx_Oracle.connect('user/pass@database')
> try:
>    con.ping()
> except cx_Oracle.DatabaseError:
>    #print "*** Connection dropped ***"
>    STATUS = "DOWN"
> else:
>    STATUS= "UP"
>
> con.close()
> print strftime("%Y-%m-%d %H:%M:%S", gmtime()), STATUS
> ...
>
> But it doesn't work - I have checked Oracle logs and it says "UP" even
> when database is down. What is wrong ?

I would imagine that the connect function (which is not in a try
block) is failing. I'm not sure why your code is not therefore getting
an unhandled exception, but assuming it doesn't, then con is probably
not a valid connection object and con.ping is then failing with
something like an attribute error.

Or your database is actually up... (what Oracle logs are you looking
at to see that the database is down?)

You might want to check that the database is showing as down if you
connect to it via SQL*Plus. If it is, try the connect() call in the
interactive interpreter and see what it returns. That may help you to
diagnose the problem better.

Paul.

[cx-oracle-users] ping()

[<prz...@po...>]

Hello,

I have been using ping() function to test reachability of some database:

...
import cx_Oracle
import sys
from time import gmtime, strftime

con = cx_Oracle.connect('user/pass@database')
try:
    con.ping()
except cx_Oracle.DatabaseError:
    #print "*** Connection dropped ***"
    STATUS = "DOWN"
else:
    STATUS= "UP"

con.close()
print strftime("%Y-%m-%d %H:%M:%S", gmtime()), STATUS
...

But it doesn't work - I have checked Oracle logs and it says "UP" even
when database is down. What is wrong ?

Regards
Przemek


----------------------------------------------------------------
Znajdź mieszkanie dla siebie - tak tanio jeszcze nie było!
SprawdĹş >> http://linkint.pl/f28e0 

[cx-oracle-users] cx_Oracle5.0.4 'NotSupportedErrors ' with numpy1.4.1

[<Tob...@ce...>]

Dear all, 

I am having a problem using numpy int's directly in cx_Oracle sql select 
statements 
The following code from an application no longer works with this 
configuration: 

python2.7 / cx_Oracle5.0.4  / numpy 1.4.1

import cx_Oracle 
import numpy 

db = cx_Oracle.connect('username/xxx@mydatabase') 
cursor = db.cursor() 

v = numpy.int32(8) #create a numpy32 bit   
sql = """select distinct myexperiment_id from  experiment where 
myexperiment_id > :firstmsexpid  """ #get me all experiments with ids 
above x (bound variable firstmsexpid  ) 

cursor.execute(sql,dict(firstmsexpid=v)) 
Traceback (most recent call last): 
  File "<stdin>", line 1, in <module> 
cx_Oracle.NotSupportedError: Variable_TypeByValue(): unhandled data type 
numpy.int32 

cursor.execute(sql,dict(firstmsexpid=int(v))) #converts to python int, and 
will work 

and of course not using the bind variable works fine too.

(Nothing works if using a numpy.int64) 

The application server has been recently upgraded to the above. Previously 
it ran without problem using the following configuration: 
python2.5.4 / cx_Oracle5.0.1  / numpy 1.3.0 

Does anyone know if this is a cx_Oracle problem / underlying database or a 
numpy error? 

Thanks in advance for any help on this - I have spent much of the last 2 
days scouring the web for clues: the only NotSupportedErrors I found had 
to do with Unicode problems, which I do not think this is. 

Toby 

--------------------------------------------
Toby Mathieson
Bioinformatics Developer
Tel: +49 (0) 6221 13757-411
Fax: +49 (0) 6221 13757-210
www.cellzome.com
tob...@ce...
-----------------------------------
Chairman of Board (Vorstandsvorsitzender): Mr. Timothy P.W. Edwards; 
Chairman of Supervisory Board (Aufsichtsratsvorsitzender): Dr. Charles 
Cohen
Registered office: Heidelberg; Commercial register: Mannheim HRB 337016; 
Ust-IdNr:: DE 205 835 333
The information contained in this electronic message and any attachments 
to this message are intended for the exclusive use of the addressee(s) and 
may contain confidential or privileged information. If you are not the 
intended recipient, please notify the sender immediately at the phone 
number stated above and destroy all copies of this message and any 
attachments. 

[cx-oracle-users] cx_Oracle on cygwin with instant client 11.1

[Doug H. <djh...@te...>]

I finally got around to installing cx_oracle under cygwin on a 64-bit
Win 7 Pro machine. I'd like to share some pointers and a patch to setup.py.

cygwin is (still) 32-bit only, so install a win32 instant client for
e.g. 11.1, and be sure to supplement the basic package with at least the
SDK package. (Multiple instant clients for different versions and widths
can reside on the same machine, as the instant client install does not
touch the registry.)

Make sure you have an ORACLE_HOME environment variable in the cygwin
environment which points to the instant client install directory. This
variable must be something like
/cygdrive/e/Oracle/x86/instantclient_11_1, not an windows path, like
E:\Oracle\x86\instantclient_11_1.

Modify the cx_Oracle setup.py file according to this diff:

$ diff setup.py ../../setup.py.djh
151,152c151,154
<             "network/public", "oci/include"]
<     libDirs = ["bin", "lib"]
---
>             "network/public", "oci/include", "sdk/include"]
>     libDirs = [os.path.join(oracleHome, "bin"),
os.path.join(oracleHome, "lib"), oracleHome,
>             os.path.join(oracleHome, "oci", "lib", "msvc"),
>             os.path.join(oracleHome, "sdk", "lib", "msvc")]
155,156c157,158
<     for i in range(len(libDirs)):
<         libDirs[i] = os.path.join(oracleHome, libDirs[i])
---
>     #for i in range(len(libDirs)):
>     #    libDirs[i] = os.path.join(oracleHome, libDirs[i])

We are adding the locations for the oci.h and oci.lib files. My changes
propagate changes in the Win32 section into the cygwin section.

After a successful build and install, I found all but one test ran
successfully. The "test binding in/out a unicode array (with arrayvar)"
test failed.
When I re-built with the WITH_UNICODE environment variable set, then all
the tests succeed.

To make running cx_Oracle easier under cygwin, I copied the dbhome and
oraenv scripts from a linux install to cygwin. These use /etc/oratab to
set the ORACLE_HOME variable and add the right directories to the PATH.

Re: [cx-oracle-users] documentation

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

Hi Robert,

Thanks for the clarification. Your initial e-mail didn't make it
clear... :-) I have no problems accepting contributions along these
lines. You're the first person to request it, though, which is why I
haven't even thought about it until now. I have a number of other
enhancements that I think will be of greater interest so I will be
working on those. If you wish to contribute this, go right ahead!

Anthony

On Wed, Dec 29, 2010 at 8:20 AM, Robert <web...@gm...> wrote:
> hi Anthony,
>
> oh yes, I have used the online docs. I was just wondering out loud why
> there's no docstring at all.
> Is this something people can help out and contribute ?
>
> robert
>
>
>
>
> On Wed, Dec 29, 2010 at 12:54 AM, Anthony Tuininga
> <ant...@gm...> wrote:
>>
>> Hi Robert,
>>
>> The documentation is not loaded into doc strings so help(cx_Oracle)
>> doesn't give you what you are looking for. You can find the
>> documentation here, though:
>>
>> http://cx-oracle.sourceforge.net/html/index.html
>>
>> Anthony
>>
>
> ------------------------------------------------------------------------------
> Learn how Oracle Real Application Clusters (RAC) One Node allows customers
> to consolidate database storage, standardize their database environment,
> and,
> should the need arise, upgrade to a full multi-node Oracle RAC database
> without downtime or disruption
> http://p.sf.net/sfu/oracle-sfdevnl
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>

Re: [cx-oracle-users] documentation

[Robert <web...@gm...>]

hi Anthony,

oh yes, I have used the online docs. I was just wondering out loud why
there's no docstring at all.
Is this something people can help out and contribute ?

robert




On Wed, Dec 29, 2010 at 12:54 AM, Anthony Tuininga <
ant...@gm...> wrote:

> Hi Robert,
>
> The documentation is not loaded into doc strings so help(cx_Oracle)
> doesn't give you what you are looking for. You can find the
> documentation here, though:
>
> http://cx-oracle.sourceforge.net/html/index.html
>
> Anthony
>
>

Re: [cx-oracle-users] documentation

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

Hi Robert,

The documentation is not loaded into doc strings so help(cx_Oracle)
doesn't give you what you are looking for. You can find the
documentation here, though:

http://cx-oracle.sourceforge.net/html/index.html

Anthony

On Tue, Dec 28, 2010 at 4:37 PM, Robert <web...@gm...> wrote:
> So why does cx_Oracle have such skimpy documentation ?  ;)
>
> see http://paste.pocoo.org/show/311083/
>
> ------------------------------------------------------------------------------
> Learn how Oracle Real Application Clusters (RAC) One Node allows customers
> to consolidate database storage, standardize their database environment,
> and,
> should the need arise, upgrade to a full multi-node Oracle RAC database
> without downtime or disruption
> http://p.sf.net/sfu/oracle-sfdevnl
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>

[cx-oracle-users] documentation

[Robert <web...@gm...>]

So why does cx_Oracle have such skimpy documentation ?  ;)

see http://paste.pocoo.org/show/311083/

Re: [cx-oracle-users] cx_oracle module AIX6.1 Oracle

[inkblotter <ink...@gm...>]

Here's a christmas present for you.

See the build line that setup.py provides.   setup.py invokes the C 
compiler, not the C++ compiler.   So copy and invoke that build line but 
replace cc_r with xlC_r by hand and presto! you will have built cx_Oracle.o

Then you can run 'python setup.py install' and it will install 
cx_Oracle.so  in python.  Try it.  I just did this on AIX 6.1.


On 12/23/2010 01:25 AM, Zane Ally wrote:
> *cc_r -pthread -fno-strict-aliasing -g -O2 -DNDEBUG -g -fwrapv -O3 
> -Wall -Wstrict-prototypes 
> -I/app/oracle/product/11.2.0/dbhome_1/rdbms/demo 
> -I/app/oracle/product/11.2.0/dbhome_1/rdbms/public 
> -I/usr/local/include/python2.7 -c cx_Oracle.c -o 
> build/temp.aix-6.1-2.7-10g/cx_Oracle.o -DBUILD_VERSION=5.0.4*

Re: [cx-oracle-users] cx_oracle module AIX6.1 Oracle

[Zane A. <zan...@ya...>]

Hi

I've now compiled with xlC with no luck either, with the same error(see below).
Please advise if I'm missing something.

which python
/usr/local/bin/python
[zabcllcdba01:root:/home/root:] file /usr/local/bin/python
/usr/local/bin/python: executable (RISC System/6000) or object module not 
stripped 


/usr/local/bin/python needs:
         /usr/lib/libc.a(shr.o)
         /usr/lib/libpthreads.a(shr_xpg5.o)
         /usr/lib/libpthreads.a(shr_comm.o)
         /usr/lib/libdl.a(shr.o)
         /unix
         /usr/lib/libcrypt.a(shr.o)

Details:

- Python 2.7 compiled from src.
- cx_oracle5.0.4
- AIX6.1 TL5 
- Oracle 11.2 for AIX(64bit)
- IBM Power7 Server 


Error:

/usr/local//bin/python setup.py build
running build
running build_ext
building 'cx_Oracle' extension
cc_r -pthread -fno-strict-aliasing -g -O2 -DNDEBUG -g -fwrapv -O3 -Wall 
-Wstrict-prototypes -I/app/oracle/product/11.2.0/dbhome_1/rdbms/demo 
-I/app/oracle/product/11.2.0/dbhome_1/rdbms/public 
-I/usr/local/include/python2.7 -c cx_Oracle.c -o 
build/temp.aix-6.1-2.7-10g/cx_Oracle.o -DBUILD_VERSION=5.0.4
In file included from 
/app/oracle/product/11.2.0/dbhome_1/rdbms/public/oci.h:3024,
                 from cx_Oracle.c:10:
/app/oracle/product/11.2.0/dbhome_1/rdbms/public/ociap.h:10788: warning: 
function declaration isn't a prototype
/app/oracle/product/11.2.0/dbhome_1/rdbms/public/ociap.h:10794: warning: 
function declaration isn't a prototype
/usr/local/lib/python2.7/config/ld_so_aix cc_r -pthread 
-bI:/usr/local/lib/python2.7/config/python.exp 
build/temp.aix-6.1-2.7-10g/cx_Oracle.o -L/app/oracle/product/11.2.0/dbhome_1/lib 
-L/app/oracle/product/11.2.0/dbhome_1 -lclntsh -o 
build/lib.aix-6.1-2.7-10g/cx_Oracle.so
ld: 0711-317 ERROR: Undefined symbol: .OCIErrorGet
ld: 0711-317 ERROR: Undefined symbol: .OCIAttrSet
ld: 0711-317 ERROR: Undefined symbol: .OCIHandleFree
...

Please assist, been battling with this for almost a week now already.

Thanks
Zane


________________________________
From: Tamás Gulácsi <gt...@gt...>
To: cx-...@li...
Sent: Tue, December 14, 2010 12:53:31 PM
Subject: Re: [cx-oracle-users] cx_oracle module AIX6.1 Oracle

 Hi Zane,

> What about the suggested
> file $(which python); ldd $(which python)
> commands?
>

??? result ???

>
> This is the command setup.py wants to use to compile cx_Oracle - clearly it
> uses cc_r, which is an AIX xlc variant.
>
> cc_r: unrecognized option '-qlanglvl=extc89'
> > /opt/freeware/lib/python2.6/config/ld_so_aix cc_r -qlanglvl=extc89
> > -bI:/opt/freeware/lib/python2.6/config/python.exp
> > build/temp.aix-6.1-2.6-10g/cx_Oracle.o
> > -L/app/oracle/product/11.2.0/dbhome_1/lib
> > -L/app/oracle/product/11.2.0/dbhome_1 -lclntsh -o
> > build/lib.aix-6.1-2.6-10g/cx_Oracle.so
> > cc_r: unrecognized option '-qlanglvl=extc89'
> >
>
> Seems your version of cc_r is not the same as your Python was built with.
>

So it is even clearer now: Python was build with cc_r, but you want to
use gcc - this will not work for sure.

Tamás Gulácsi

------------------------------------------------------------------------------
Lotusphere 2011
Register now for Lotusphere 2011 and learn how
to connect the dots, take your collaborative environment
to the next level, and enter the era of Social Business.
http://p.sf.net/sfu/lotusphere-d2d
_______________________________________________
cx-oracle-users mailing list
cx-...@li...
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users



      

Re: [cx-oracle-users] cx_Logging setup.py on AIX

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

Hi Tamás,

I have checked in this change to cx_Logging. In the future, please
contact me directly if you are unable to determine the cx_Logging
mailing list, rather than post here. Thanks!

BTW, the cx_Logging mailing list can be found here:

https://lists.sourceforge.net/lists/listinfo/cx-logging-users

I've also included a reference to it in the main page which will be
uploaded when I make a new release of cx_Logging shortly.

Anthony

On Mon, Dec 20, 2010 at 9:56 AM, Tamás Gulácsi
<gt...@gt...> wrote:
> Hi Anthony,
>
> Sorry to post it here, but I just cannot find a mailing list/address
> for cx_Logging.
> On AIX 5.3, install fails - below is a setup.py workaround/fix.
>
> Tamás Gulácsi
>
> diff --git a/.external/cx_Logging-2.0/setup.py
> b/.external/cx_Logging-2.0/setup.py
> index 53c1160..1c58d2a 100644
> --- a/.external/cx_Logging-2.0/setup.py
> +++ b/.external/cx_Logging-2.0/setup.py
> @@ -63,7 +63,10 @@ class build_ext(distutils.command.build_ext.build_ext):
>             ext.libraries = ["ole32"]
>         else:
>             fileName = self.get_ext_filename(ext.name)
> -            extraLinkArgs.append("-Wl,-soname,%s" % fileName)
> +            if sys.platform.startswith("aix"):
> +                extraLinkArgs.append("-Wl,-so%s" % fileName)
> +            else:
> +                extraLinkArgs.append("-Wl,-soname,%s" % fileName)
>         distutils.command.build_ext.build_ext.build_extension(self, ext)
>
>     def finalize_options(self):
>
> ------------------------------------------------------------------------------
> Lotusphere 2011
> Register now for Lotusphere 2011 and learn how
> to connect the dots, take your collaborative environment
> to the next level, and enter the era of Social Business.
> http://p.sf.net/sfu/lotusphere-d2d
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>

[cx-oracle-users] cx_Logging setup.py on AIX

[Tamás G. <gt...@gt...>]

Hi Anthony,

Sorry to post it here, but I just cannot find a mailing list/address
for cx_Logging.
On AIX 5.3, install fails - below is a setup.py workaround/fix.

Tamás Gulácsi

diff --git a/.external/cx_Logging-2.0/setup.py
b/.external/cx_Logging-2.0/setup.py
index 53c1160..1c58d2a 100644
--- a/.external/cx_Logging-2.0/setup.py
+++ b/.external/cx_Logging-2.0/setup.py
@@ -63,7 +63,10 @@ class build_ext(distutils.command.build_ext.build_ext):
             ext.libraries = ["ole32"]
         else:
             fileName = self.get_ext_filename(ext.name)
-            extraLinkArgs.append("-Wl,-soname,%s" % fileName)
+            if sys.platform.startswith("aix"):
+                extraLinkArgs.append("-Wl,-so%s" % fileName)
+            else:
+                extraLinkArgs.append("-Wl,-soname,%s" % fileName)
         distutils.command.build_ext.build_ext.build_extension(self, ext)

     def finalize_options(self):

Re: [cx-oracle-users] cx_oracle module AIX6.1 Oracle

[Zane A. <zan...@ya...>]

Hi Tamas

I was away.

[zabcllcdba01:root:/home/root:] which python
/usr/local/bin/python
[zabcllcdba01:root:/home/root:] file /usr/local/bin/python
/usr/local/bin/python: executable (RISC System/6000) or object module not 
stripped

[zabcllcdba01:root:/home/root:] ldd /usr/local/bin/python
/usr/local/bin/python needs:
         /usr/lib/libc.a(shr.o)
         /usr/lib/libpthreads.a(shr_xpg5.o)
         /usr/lib/libpthreads.a(shr_comm.o)
         /usr/lib/libdl.a(shr.o)
         /unix
         /usr/lib/libcrypt.a(shr.o)
[zabcllcdba01:root:/home/root:]

Thanks
Zane



________________________________
From: Tamás Gulácsi <gt...@gt...>
To: cx-...@li...
Sent: Tue, December 14, 2010 12:53:31 PM
Subject: Re: [cx-oracle-users] cx_oracle module AIX6.1 Oracle

 Hi Zane,

> What about the suggested
> file $(which python); ldd $(which python)
> commands?
>

??? result ???

>
> This is the command setup.py wants to use to compile cx_Oracle - clearly it
> uses cc_r, which is an AIX xlc variant.
>
> cc_r: unrecognized option '-qlanglvl=extc89'
> > /opt/freeware/lib/python2.6/config/ld_so_aix cc_r -qlanglvl=extc89
> > -bI:/opt/freeware/lib/python2.6/config/python.exp
> > build/temp.aix-6.1-2.6-10g/cx_Oracle.o
> > -L/app/oracle/product/11.2.0/dbhome_1/lib
> > -L/app/oracle/product/11.2.0/dbhome_1 -lclntsh -o
> > build/lib.aix-6.1-2.6-10g/cx_Oracle.so
> > cc_r: unrecognized option '-qlanglvl=extc89'
> >
>
> Seems your version of cc_r is not the same as your Python was built with.
>

So it is even clearer now: Python was build with cc_r, but you want to
use gcc - this will not work for sure.

Tamás Gulácsi

------------------------------------------------------------------------------
Lotusphere 2011
Register now for Lotusphere 2011 and learn how
to connect the dots, take your collaborative environment
to the next level, and enter the era of Social Business.
http://p.sf.net/sfu/lotusphere-d2d
_______________________________________________
cx-oracle-users mailing list
cx-...@li...
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users



      

Re: [cx-oracle-users] cx_Oracle and array in and out

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

Hi,

The answer to both of your questions is due to the fact that varray is
a "SQL" object whereas the arrays that are mentioned are only
available in PL/SQL. The ability to create SQL objects (like varray)
is still in the works. I was working on it a few months ago but then
things got way too busy at work and I haven't worked on it since.
Perhaps sometime over the break I'll get a chance to work on it as I
would very much like to get it done!

The other problem is also due to fact that varrays are "SQL" objects
and different code is in place. That code only converts to Python
floats since it occurs internally (getting an object attribute) and
not directly from a cursor. Still, things should be consistent. I
appreciate you pointing this out and I'll pay attention to that when I
get a chance to look at this a bit more closely.

Anthony

On Thu, Dec 16, 2010 at 3:13 PM, Chapman, Scott <Sco...@pi...> wrote:
> I have two questions regarding this situation:
>
>
>
> import cx_Oracle
>
>
>
> from decimal import Decimal
>
>
>
> ml = [Decimal("1.4"), Decimal("2.0"), Decimal("0.5")]
>
>
>
> def NumbersAsDecimal(cursor, name, defaultType, size, precision, scale):
>
>     if defaultType == cx_Oracle.NUMBER:
>
>         return cursor.var(str, 100, cursor.arraysize, outconverter =
> Decimal)
>
>
>
> ora_dbh = cx_Oracle.Connection("user","pass","")
>
> ora_dbh.outputtypehandler = NumbersAsDecimal
>
> ora_c = ora_dbh.cursor()
>
>
>
> try:
>
>     ora_c.execute("DROP TABLE VECTORS")
>
> except:
>
>     pass
>
> try:
>
>     ora_c.execute("DROP TYPE VECTOR")
>
> except:
>
>     pass
>
> ora_c.execute("CREATE TYPE VECTOR AS VARRAY(360) OF NUMBER")
>
> ora_c.execute("CREATE TABLE VECTORS ( NAME VARCHAR2(10), VEC VECTOR)")
>
> ora_c.execute("insert into VECTORS values ('v1' ,  VECTOR(:value1))", value1
> = ml)
>
> ora_c.execute("select * from VECTORS")
>
> foo = ora_c.fetchall()
>
> ora_dbh.close()
>
> print foo
>
> print type(foo[0][1][0])
>
>
>
> When I run it I get:
>
>
>
> $ python test_cx.py
>
> Traceback (most recent call last):
>
>   File "test_cx.py", line 25, in ?
>
>     ora_c.execute("insert into VECTORS values ('v1' ,  VECTOR(:value1))",
> value1 = ml)
>
> cx_Oracle.DatabaseError: ORA-01484: arrays can only be bound to PL/SQL
> statements
>
>
>
> How to bind this correctly?
>
>
>
> Also, when I do this with
>
>    ora_c.execute("insert into VECTORS values ('v1' ,  VECTOR(1.4, 2.0,
> 0.5))")
>
> The values are inserted Ok and the fetchall  returns a list of floats.
>
>
>
> How do I make it return a list of Decimals?
>
>
>
> Thanks,
>
> Scott
>
>
>
>
>
>
>
> This message contains confidential information and is intended only for the
> individual named. If you are not the named addressee, you should not
> disseminate, distribute, alter or copy this e-mail. Please notify the sender
> immediately by e-mail if you have received this e-mail by mistake and delete
> this e-mail from your system. E-mail transmissions cannot be guaranteed to
> be secure or without error as information could be intercepted, corrupted,
> lost, destroyed, arrive late or incomplete, or contain viruses. The sender,
> therefore, does not accept liability for any errors or omissions in the
> contents of this message which arise during or as a result of e-mail
> transmission. If verification is required, please request a hard-copy
> version. This message is provided for information purposes and should not be
> construed as a solicitation or offer to buy or sell any securities or
> related financial instruments in any jurisdiction.
> ------------------------------------------------------------------------------
> Lotusphere 2011
> Register now for Lotusphere 2011 and learn how
> to connect the dots, take your collaborative environment
> to the next level, and enter the era of Social Business.
> http://p.sf.net/sfu/lotusphere-d2d
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>

[cx-oracle-users] cx_Oracle and array in and out

[Chapman, S. <Sco...@pi...>]

I have two questions regarding this situation:

 

import cx_Oracle

 

from decimal import Decimal

 

ml = [Decimal("1.4"), Decimal("2.0"), Decimal("0.5")]

 

def NumbersAsDecimal(cursor, name, defaultType, size, precision, scale):


    if defaultType == cx_Oracle.NUMBER: 

        return cursor.var(str, 100, cursor.arraysize, outconverter =
Decimal) 

 

ora_dbh = cx_Oracle.Connection("user","pass","")

ora_dbh.outputtypehandler = NumbersAsDecimal 

ora_c = ora_dbh.cursor()

 

try: 

    ora_c.execute("DROP TABLE VECTORS")

except:

    pass

try:

    ora_c.execute("DROP TYPE VECTOR")

except:

    pass

ora_c.execute("CREATE TYPE VECTOR AS VARRAY(360) OF NUMBER")

ora_c.execute("CREATE TABLE VECTORS ( NAME VARCHAR2(10), VEC VECTOR)")

ora_c.execute("insert into VECTORS values ('v1' ,  VECTOR(:value1))",
value1 = ml)

ora_c.execute("select * from VECTORS")

foo = ora_c.fetchall()

ora_dbh.close()

print foo

print type(foo[0][1][0])

 

When I run it I get:

 

$ python test_cx.py

Traceback (most recent call last):

  File "test_cx.py", line 25, in ?

    ora_c.execute("insert into VECTORS values ('v1' ,
VECTOR(:value1))", value1 = ml)

cx_Oracle.DatabaseError: ORA-01484: arrays can only be bound to PL/SQL
statements

 

How to bind this correctly?

 

Also, when I do this with 

   ora_c.execute("insert into VECTORS values ('v1' ,  VECTOR(1.4, 2.0,
0.5))")

The values are inserted Ok and the fetchall  returns a list of floats.

 

How do I make it return a list of Decimals?

 

Thanks,

Scott

 

 

 


This message contains confidential information and is intended only for the individual named. If you are not the named addressee, you should not disseminate, distribute, alter or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmissions cannot be guaranteed to be secure or without error as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender, therefore, does not accept liability for any errors or omissions in the contents of this message which arise during or as a result of e-mail transmission. If verification is required, please request a hard-copy version. This message is provided for information purposes and should not be construed as a solicitation or offer to buy or sell any securities or related financial instruments in any jurisdiction.

Re: [cx-oracle-users] cx_oracle module AIX6.1 Oracle

[Zane A. <zan...@ya...>]

Hi 

I have now compiled Python2.7 on AIX with gcc and then tried to compile 
cx_oracle5.0.4.
I now get more or less the same error, see below 

[zabcllcdba01:root:/software/Python/cx_Oracle-5.0.4:] python setup.py build
running build
running build_ext
building 'cx_Oracle' extension
gcc -pthread -fno-strict-aliasing -g -O2 -DNDEBUG -g -fwrapv -O3 -Wall 
-Wstrict-prototypes -I/app/oracle/product/11.2.0/dbhome_1/rdbms/demo 
-I/app/oracle/product/11.2.0/dbhome_1/rdbms/public 
-I/usr/local/include/python2.7 -c cx_Oracle.c -o 
build/temp.aix-6.1-2.7-10g/cx_Oracle.o -DBUILD_VERSION=5.0.4
In file included from 
/app/oracle/product/11.2.0/dbhome_1/rdbms/public/oci.h:3024,
                 from cx_Oracle.c:10:
/app/oracle/product/11.2.0/dbhome_1/rdbms/public/ociap.h:10788: warning: 
function declaration isn't a prototype
/app/oracle/product/11.2.0/dbhome_1/rdbms/public/ociap.h:10794: warning: 
function declaration isn't a prototype
/usr/local/lib/python2.7/config/ld_so_aix gcc -pthread 
-bI:/usr/local/lib/python2.7/config/python.exp 
build/temp.aix-6.1-2.7-10g/cx_Oracle.o -L/app/oracle/product/11.2.0/dbhome_1/lib 
-L/app/oracle/product/11.2.0/dbhome_1 -lclntsh -o 
build/lib.aix-6.1-2.7-10g/cx_Oracle.so
ld: 0711-317 ERROR: Undefined symbol: .OCIErrorGet
ld: 0711-317 ERROR: Undefined symbol: .OCIAttrSet
ld: 0711-317 ERROR: Undefined symbol: .OCIHandleFree
ld: 0711-317 ERROR: Undefined symbol: .OCIStmtRelease
ld: 0711-317 ERROR: Undefined symbol: .OCIIntervalGetDaySecond
ld: 0711-317 ERROR: Undefined symbol: .OCIIntervalSetDaySecond
ld: 0711-317 ERROR: Undefined symbol: .OCIDescriptorFree
ld: 0711-317 ERROR: Undefined symbol: .OCIDescriptorAlloc
ld: 0711-317 ERROR: Undefined symbol: .OCINumberToReal
ld: 0711-317 ERROR: Undefined symbol: .OCINumberToInt
ld: 0711-317 ERROR: Undefined symbol: .OCINumberToText
ld: 0711-317 ERROR: Undefined symbol: .OCINumberFromText
ld: 0711-317 ERROR: Undefined symbol: .OCINumberFromReal
ld: 0711-317 ERROR: Undefined symbol: .OCINumberFromInt
ld: 0711-317 ERROR: Undefined symbol: .OCIAttrGet
ld: 0711-317 ERROR: Undefined symbol: .OCIBindByName
ld: 0711-317 ERROR: Undefined symbol: .OCIBindByPos
ld: 0711-317 ERROR: Undefined symbol: .OCIDateTimeGetDate
ld: 0711-317 ERROR: Undefined symbol: .OCIDateTimeGetTime
ld: 0711-317 ERROR: Undefined symbol: .OCIDefineObject
ld: 0711-317 ERROR: Undefined symbol: .OCIObjectFree
ld: 0711-317 ERROR: Undefined symbol: .OCILobWrite
ld: 0711-317 ERROR: Undefined symbol: .OCILobIsTemporary
ld: 0711-317 ERROR: Undefined symbol: .OCILobCreateTemporary
ld: 0711-317 ERROR: Undefined symbol: .OCILobTrim
ld: 0711-317 ERROR: Undefined symbol: .OCILobFreeTemporary
ld: 0711-317 ERROR: Undefined symbol: .OCIDateTimeConstruct
ld: 0711-317 ERROR: Undefined symbol: .OCIDateTimeCheck
ld: 0711-317 ERROR: Undefined symbol: .OCILobRead
ld: 0711-317 ERROR: Undefined symbol: .OCILobFileOpen
ld: 0711-317 ERROR: Undefined symbol: .OCILobFileClose
ld: 0711-317 ERROR: Undefined symbol: .OCILobGetLength
ld: 0711-317 ERROR: Undefined symbol: .OCIStmtGetBindInfo
ld: 0711-317 ERROR: Undefined symbol: .OCIStmtFetch
ld: 0711-317 ERROR: Undefined symbol: .OCINlsCharSetIdToName
ld: 0711-317 ERROR: Undefined symbol: .OCINlsNameMap
ld: 0711-317 ERROR: Undefined symbol: .OCIPasswordChange
ld: 0711-317 ERROR: Undefined symbol: .OCIHandleAlloc
ld: 0711-317 ERROR: Undefined symbol: .OCISubscriptionRegister
ld: 0711-317 ERROR: Undefined symbol: .OCIEnvNlsCreate
ld: 0711-317 ERROR: Undefined symbol: .OCINlsNumericInfoGet
ld: 0711-317 ERROR: Undefined symbol: .OCICollSize
ld: 0711-317 ERROR: Undefined symbol: .OCICollGetElem
ld: 0711-317 ERROR: Undefined symbol: .OCIClientVersion
ld: 0711-317 ERROR: Undefined symbol: .OCISubscriptionUnRegister
ld: 0711-317 ERROR: Undefined symbol: .OCIObjectUnpin
ld: 0711-317 ERROR: Undefined symbol: .OCISessionPoolDestroy
ld: 0711-317 ERROR: Undefined symbol: .OCITransRollback
ld: 0711-317 ERROR: Undefined symbol: .OCISessionEnd
ld: 0711-317 ERROR: Undefined symbol: .OCIServerDetach
ld: 0711-317 ERROR: Undefined symbol: .OCISessionRelease
ld: 0711-317 ERROR: Undefined symbol: .OCISessionPoolCreate
ld: 0711-317 ERROR: Undefined symbol: .OCILobFileExists
ld: 0711-317 ERROR: Undefined symbol: .OCILobFileSetName
ld: 0711-317 ERROR: Undefined symbol: .OCILobFileGetName
ld: 0711-317 ERROR: Undefined symbol: .OCILobIsOpen
ld: 0711-317 ERROR: Undefined symbol: .OCILobGetChunkSize
ld: 0711-317 ERROR: Undefined symbol: .OCILobClose
ld: 0711-317 ERROR: Undefined symbol: .OCILobOpen
ld: 0711-317 ERROR: Undefined symbol: .OCIDBStartup
ld: 0711-317 ERROR: Undefined symbol: .OCIDBShutdown
ld: 0711-317 ERROR: Undefined symbol: .OCIPing
ld: 0711-317 ERROR: Undefined symbol: .OCIUserCallbackGet
ld: 0711-317 ERROR: Undefined symbol: .OCIUserCallbackRegister
ld: 0711-317 ERROR: Undefined symbol: .OCIBreak
ld: 0711-317 ERROR: Undefined symbol: .OCITransPrepare
ld: 0711-317 ERROR: Undefined symbol: .OCITransStart
ld: 0711-317 ERROR: Undefined symbol: .OCITransCommit
ld: 0711-317 ERROR: Undefined symbol: .OCIStringPtr
ld: 0711-317 ERROR: Undefined symbol: .OCIStringSize
ld: 0711-317 ERROR: Undefined symbol: .OCIObjectGetAttr
ld: 0711-317 ERROR: Undefined symbol: .OCIIterCreate
ld: 0711-317 ERROR: Undefined symbol: .OCIIterNext
ld: 0711-317 ERROR: Undefined symbol: .OCIIterDelete
ld: 0711-317 ERROR: Undefined symbol: .OCIParamGet
ld: 0711-317 ERROR: Undefined symbol: .OCIDefineByPos
ld: 0711-317 ERROR: Undefined symbol: .OCIStmtExecute
ld: 0711-317 ERROR: Undefined symbol: .OCISessionGet
ld: 0711-317 ERROR: Undefined symbol: .OCIServerAttach
ld: 0711-317 ERROR: Undefined symbol: .OCISessionBegin
ld: 0711-317 ERROR: Undefined symbol: .OCIObjectPin
ld: 0711-317 ERROR: Undefined symbol: .OCIDescribeAny
ld: 0711-317 ERROR: Undefined symbol: .OCIStmtPrepare
ld: 0711-317 ERROR: Undefined symbol: .OCIStmtPrepare2
ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more information.
collect2: ld returned 8 exit status
error: command '/usr/local/lib/python2.7/config/ld_so_aix' failed with exit 
status 1

 
Has this cx_oracle5.0.4 source code been compiled on a 64bit AIX environment
(with oracle 11.2 64bit) using gcc and not xlC before? 

It seems as if Oracle11.2 does not have 32bit libs

Thanks
Zane




________________________________
From: Tamás Gulácsi <gt...@gt...>
To: cx-...@li...
Sent: Tue, December 14, 2010 12:53:31 PM
Subject: Re: [cx-oracle-users] cx_oracle module AIX6.1 Oracle

 Hi Zane,

> What about the suggested
> file $(which python); ldd $(which python)
> commands?
>

??? result ???

>
> This is the command setup.py wants to use to compile cx_Oracle - clearly it
> uses cc_r, which is an AIX xlc variant.
>
> cc_r: unrecognized option '-qlanglvl=extc89'
> > /opt/freeware/lib/python2.6/config/ld_so_aix cc_r -qlanglvl=extc89
> > -bI:/opt/freeware/lib/python2.6/config/python.exp
> > build/temp.aix-6.1-2.6-10g/cx_Oracle.o
> > -L/app/oracle/product/11.2.0/dbhome_1/lib
> > -L/app/oracle/product/11.2.0/dbhome_1 -lclntsh -o
> > build/lib.aix-6.1-2.6-10g/cx_Oracle.so
> > cc_r: unrecognized option '-qlanglvl=extc89'
> >
>
> Seems your version of cc_r is not the same as your Python was built with.
>

So it is even clearer now: Python was build with cc_r, but you want to
use gcc - this will not work for sure.

Tamás Gulácsi

------------------------------------------------------------------------------
Lotusphere 2011
Register now for Lotusphere 2011 and learn how
to connect the dots, take your collaborative environment
to the next level, and enter the era of Social Business.
http://p.sf.net/sfu/lotusphere-d2d
_______________________________________________
cx-oracle-users mailing list
cx-...@li...
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users



      

Re: [cx-oracle-users] Crash of OCIStmtRelease during cursor.close()

[<Gui...@su...>]

Hi all,
The problem I had with OCIStmtRelease a month ago has finally been solved. Even though it turned out not to be cxOracle's fault at all, I thought I'd give the solution here in case anyone ever comes across this issue.

The problem was that under cxOracle 4.4 and Oracle 11, our program used to crash randomly during calls to the OCI.
At first I thought it was a problem with cxOracle, but it turns out it was due to a new diagnostics tool called ADR that Oracle introduced in their 11g version.
The solution is to either set the environment variable PTHREAD_DEFAULT_STACK_SIZE to a big enough value, or to disable ADR altogether. I chose to disable it since I don't know what 'big enough' means and I can't take the risk of having this problem occur ever again. 

So thanks a lot for your help anyway, especially to Anthony and Amaury. 




-----Message d'origine-----
De : Gui...@su... [mailto:Gui...@su...] 
Envoyé : vendredi 5 novembre 2010 12:13
À : cx-...@li...
Objet : Re: [cx-oracle-users] Crash of OCIStmtRelease during cursor.close()


> There is an internal method Cursor_FreeHandle() which is called.
> Cursor_Free() does not directly call Cursor_Close() so they are not
> the same thing.

Right, but Cursor_FreeHandle is where my program crashes, during the
execution of OCIStmtRelease, so this will still get called and my
program will probably still crash for the same reason that it does now,
won't it?

But I can't just talk the talk and not walk the walk. As I said, I'll do
the tests today so we'll know for sure. 

By the way, I know it's a long shot but I found this Oracle trace when
the program crashes. If it means anything to anyone. 

_kpedbg_dmp_stack()+231
<-_kpeDbgCrash()+51
<-__VInfreq__kpustmtrelease()+341
<-_OCIStmtRelease()+87
<-_OCIStmtRelease()+49
Before that it's Cursor_FreeHandle() and Cursor_Close() that are called
and lead to OCIStmtRelease.


Thanks,
Guillaume



------------------------------------------------------------------------------
The Next 800 Companies to Lead America's Growth: New Video Whitepaper
David G. Thomson, author of the best-selling book "Blueprint to a 
Billion" shares his insights and actions to help propel your 
business during the next growth cycle. Listen Now!
http://p.sf.net/sfu/SAP-dev2dev
_______________________________________________
cx-oracle-users mailing list
cx-...@li...
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

Re: [cx-oracle-users] cx_oracle module AIX6.1 Oracle

[Zane A. <zan...@ya...>]

Thanks

Will download python src, compile with gcc and then compile cx_oracle with gcc 
too.
As a start.

Thanks
Zane




________________________________
From: Tamás Gulácsi <gt...@gt...>
To: cx-...@li...
Sent: Tue, December 14, 2010 12:53:31 PM
Subject: Re: [cx-oracle-users] cx_oracle module AIX6.1 Oracle

 Hi Zane,

> What about the suggested
> file $(which python); ldd $(which python)
> commands?
>

??? result ???

>
> This is the command setup.py wants to use to compile cx_Oracle - clearly it
> uses cc_r, which is an AIX xlc variant.
>
> cc_r: unrecognized option '-qlanglvl=extc89'
> > /opt/freeware/lib/python2.6/config/ld_so_aix cc_r -qlanglvl=extc89
> > -bI:/opt/freeware/lib/python2.6/config/python.exp
> > build/temp.aix-6.1-2.6-10g/cx_Oracle.o
> > -L/app/oracle/product/11.2.0/dbhome_1/lib
> > -L/app/oracle/product/11.2.0/dbhome_1 -lclntsh -o
> > build/lib.aix-6.1-2.6-10g/cx_Oracle.so
> > cc_r: unrecognized option '-qlanglvl=extc89'
> >
>
> Seems your version of cc_r is not the same as your Python was built with.
>

So it is even clearer now: Python was build with cc_r, but you want to
use gcc - this will not work for sure.

Tamás Gulácsi

------------------------------------------------------------------------------
Lotusphere 2011
Register now for Lotusphere 2011 and learn how
to connect the dots, take your collaborative environment
to the next level, and enter the era of Social Business.
http://p.sf.net/sfu/lotusphere-d2d
_______________________________________________
cx-oracle-users mailing list
cx-...@li...
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users



      

Re: [cx-oracle-users] cx_oracle module AIX6.1 Oracle

[Tamás G. <gt...@gt...>]

 Hi Zane,

> What about the suggested
> file $(which python); ldd $(which python)
> commands?
>

??? result ???

>
> This is the command setup.py wants to use to compile cx_Oracle - clearly it
> uses cc_r, which is an AIX xlc variant.
>
> cc_r: unrecognized option '-qlanglvl=extc89'
> > /opt/freeware/lib/python2.6/config/ld_so_aix cc_r -qlanglvl=extc89
> > -bI:/opt/freeware/lib/python2.6/config/python.exp
> > build/temp.aix-6.1-2.6-10g/cx_Oracle.o
> > -L/app/oracle/product/11.2.0/dbhome_1/lib
> > -L/app/oracle/product/11.2.0/dbhome_1 -lclntsh -o
> > build/lib.aix-6.1-2.6-10g/cx_Oracle.so
> > cc_r: unrecognized option '-qlanglvl=extc89'
> >
>
> Seems your version of cc_r is not the same as your Python was built with.
>

So it is even clearer now: Python was build with cc_r, but you want to
use gcc - this will not work for sure.

Tamás Gulácsi

Re: [cx-oracle-users] cx_oracle module AIX6.1 Oracle 11.2(64bit) (Zane Ally)

[Zane A. <zan...@ya...>]

Hi Tamas

Yes, forgot to mention that I installed gcc and then linked the the gcc binary 
to cc_r
as below:

ln -s  /opt/freeware/bin/gcc /usr/bin/cc_r

[zaclppxdba01:root:/home/root:] file $(which python)
/usr/bin/python: executable (RISC System/6000) or object module
[zaclppxdba01:root:/home/root:] ldd $(which python)
/usr/bin/python needs:
         /usr/lib/threads/libc.a(shr.o)
         /usr/lib/libpthreads.a(shr_comm.o)
         /usr/lib/libpthreads.a(shr_xpg5.o)
         /opt/freeware/lib/libpython2.6.a(libpython2.6.so)
         /unix
         /usr/lib/libcrypt.a(shr.o)
         /usr/lib/libdl.a(shr.o)
[zaclppxdba01:root:/home/root:]

I installed python rpm and did not compile it.

Thanks
Zane



________________________________
From: Tamás Gulácsi <gt...@gt...>
To: cx-...@li...
Sent: Tue, December 14, 2010 10:30:06 AM
Subject: Re: [cx-oracle-users] cx_oracle module AIX6.1 Oracle 11.2(64bit) (Zane 
Ally)


Date: Tue, 14 Dec 2010 00:00:53 -0800 (PST)
>From: Zane Ally <zan...@ya...>
>Subject: Re: [cx-oracle-users] cx_oracle module AIX6.1 Oracle
>       11.2(64bit)
>To: cx-...@li...
>Message-ID: <319...@we...>
>Content-Type: text/plain; charset="iso-8859-1"
>
>Hi
>
>Thanks for the feedback, much appreciated.
>Yes, thought I was being a bit ambitious.
>
>-No AIX xlC Compiler installed, using gcc.
>-Python 2.6 was not compiled, I installed rpm binary
>-cx_oracle source?is cx_Oracle-5.0.4.tar.gz
>
>My environement:
>
>[zaclppxdba01:root:/home/root:] rpm -aq | grep gcc
>gcc-4.2.0-3
>
>[zaclppxdba01:root:/home/root:] rpm -aq | egrep "gcc|python"
>gcc-4.2.0-3
>python-2.6.2-1
>python-devel-2.6.2-1
>
>[zaclppxdba01:root:/home/root:] oslevel -s
>6100-05-01-1016
>
>[zaclppxdba01:root:/home/root:] python -V
>Python 2.6.2
>
>
This says nothing about the "wideness" of the installed Python (whether it is 32 
or 64 bit).
What about the suggested 
file $(which python); ldd $(which python)
commands?

And the error
>?
>****************
>[zaclppxdba01:root:/software/Python/cx_Oracle-5.0.4:] python setup.py build
>running build
>running build_ext
>building 'cx_Oracle' extension
>cc_r -qlanglvl=extc89 -DNDEBUG -O
>-I/app/oracle/product/11.2.0/dbhome_1/rdbms/demo
>-I/app/oracle/product/11.2.0/dbhome_1/rdbms/public
>-I/opt/freeware/include/python2.6 -c cx_Oracle.c -o
>build/temp.aix-6.1-2.6-10g/cx_Oracle.o -DBUILD_VERSION=5.0.4
>

This is the command setup.py wants to use to compile cx_Oracle - clearly it uses 
cc_r, which is an AIX xlc variant. 

cc_r: unrecognized option '-qlanglvl=extc89'
>/opt/freeware/lib/python2.6/config/ld_so_aix cc_r -qlanglvl=extc89
>-bI:/opt/freeware/lib/python2.6/config/python.exp
>build/temp.aix-6.1-2.6-10g/cx_Oracle.o 
-L/app/oracle/product/11.2.0/dbhome_1/lib
>-L/app/oracle/product/11.2.0/dbhome_1 -lclntsh -o
>build/lib.aix-6.1-2.6-10g/cx_Oracle.so
>cc_r: unrecognized option '-qlanglvl=extc89'
>

Seems your version of cc_r is not the same as your Python was built with.

ld: 0711-317 ERROR: Undefined symbol: .OCIErrorGet
>ld: 0711-317 ERROR: Undefined symbol: .OCIAttrSet
>ld: 0711-317 ERROR: Undefined symbol: .OCIHandleAlloc
>ld: 0711-317 ERROR: Undefined symbol: .OCIHandleFree
>ld: 0711-317 ERROR: Undefined symbol: .OCIStmtRelease
>ld: 0711-317 ERROR: Undefined symbol: .OCIIntervalGetDaySecond
>ld: 0711-317 ERROR: Undefined symbol: .OCIIntervalSetDaySecond
>ld: 0711-317 ERROR: Undefined symbol: .OCIDescriptorFree
>ld: 0711-317 ERROR: Undefined symbol: .OCIDescriptorAlloc
>ld: 0711-317 ERROR: Undefined symbol: .OCINumberToReal
>ld: 0711-317 ERROR: Undefined symbol: .OCINumberToInt
>ld: 0711-317 ERROR: Undefined symbol: .OCINumberToText
>ld: 0711-317 ERROR: Undefined symbol: .OCINumberFromInt
>ld: 0711-317 ERROR: Undefined symbol: .OCINumberFromText
>ld: 0711-317 ERROR: Undefined symbol: .OCINumberFromReal
>ld: 0711-317 ERROR: Undefined symbol: .OCIAttrGet
>ld: 0711-317 ERROR: Undefined symbol: .OCIBindByName
>ld: 0711-317 ERROR: Undefined symbol: .OCIBindByPos
>ld: 0711-317 ERROR: Undefined symbol: .OCIParamGet
>ld: 0711-317 ERROR: Undefined symbol: .OCIDefineByPos
>ld: 0711-317 ERROR: Undefined symbol: .OCIDateTimeGetDate
>ld: 0711-317 ERROR: Undefined symbol: .OCIDateTimeGetTime
>ld: 0711-317 ERROR: Undefined symbol: .OCIStringPtr
>ld: 0711-317 ERROR: Undefined symbol: .OCIStringSize
>ld: 0711-317 ERROR: Undefined symbol: .OCIIterCreate
>ld: 0711-317 ERROR: Undefined symbol: .OCIIterNext
>ld: 0711-317 ERROR: Undefined symbol: .OCIIterDelete
>ld: 0711-317 ERROR: Undefined symbol: .OCIDefineObject
>ld: 0711-317 ERROR: Undefined symbol: .OCIObjectPin
>ld: 0711-317 ERROR: Undefined symbol: .OCIDescribeAny
>ld: 0711-317 ERROR: Undefined symbol: .OCIObjectFree
>ld: 0711-317 ERROR: Undefined symbol: .OCILobTrim
>ld: 0711-317 ERROR: Undefined symbol: .OCILobWrite
>ld: 0711-317 ERROR: Undefined symbol: .OCILobIsTemporary
>ld: 0711-317 ERROR: Undefined symbol: .OCILobCreateTemporary
>ld: 0711-317 ERROR: Undefined symbol: .OCILobFreeTemporary
>ld: 0711-317 ERROR: Undefined symbol: .OCIDateTimeConstruct
>ld: 0711-317 ERROR: Undefined symbol: .OCIDateTimeCheck
>ld: 0711-317 ERROR: Undefined symbol: .OCIStmtExecute
>ld: 0711-317 ERROR: Undefined symbol: .OCILobFileExists
>ld: 0711-317 ERROR: Undefined symbol: .OCILobFileSetName
>ld: 0711-317 ERROR: Undefined symbol: .OCILobFileGetName
>ld: 0711-317 ERROR: Undefined symbol: .OCILobIsOpen
>ld: 0711-317 ERROR: Undefined symbol: .OCILobGetChunkSize
>ld: 0711-317 ERROR: Undefined symbol: .OCILobGetLength
>ld: 0711-317 ERROR: Undefined symbol: .OCILobFileOpen
>ld: 0711-317 ERROR: Undefined symbol: .OCILobRead
>ld: 0711-317 ERROR: Undefined symbol: .OCILobFileClose
>ld: 0711-317 ERROR: Undefined symbol: .OCILobClose
>ld: 0711-317 ERROR: Undefined symbol: .OCILobOpen
>ld: 0711-317 ERROR: Undefined symbol: .OCITransRollback
>ld: 0711-317 ERROR: Undefined symbol: .OCISessionRelease
>ld: 0711-317 ERROR: Undefined symbol: .OCIStmtPrepare
>ld: 0711-317 ERROR: Undefined symbol: .OCIStmtGetBindInfo
>ld: 0711-317 ERROR: Undefined symbol: .OCIStmtPrepare2
>ld: 0711-317 ERROR: Undefined symbol: .OCIStmtFetch
>ld: 0711-317 ERROR: Undefined symbol: .OCINlsCharSetIdToName
>ld: 0711-317 ERROR: Undefined symbol: .OCINlsNameMap
>ld: 0711-317 ERROR: Undefined symbol: .OCIPasswordChange
>ld: 0711-317 ERROR: Undefined symbol: .OCISubscriptionRegister
>ld: 0711-317 ERROR: Undefined symbol: .OCIEnvNlsCreate
>ld: 0711-317 ERROR: Undefined symbol: .OCINlsNumericInfoGet
>ld: 0711-317 ERROR: Undefined symbol: .OCICollSize
>ld: 0711-317 ERROR: Undefined symbol: .OCICollGetElem
>ld: 0711-317 ERROR: Undefined symbol: .OCIDBStartup
>ld: 0711-317 ERROR: Undefined symbol: .OCIDBShutdown
>ld: 0711-317 ERROR: Undefined symbol: .OCIPing
>ld: 0711-317 ERROR: Undefined symbol: .OCIUserCallbackGet
>ld: 0711-317 ERROR: Undefined symbol: .OCIUserCallbackRegister
>ld: 0711-317 ERROR: Undefined symbol: .OCIBreak
>ld: 0711-317 ERROR: Undefined symbol: .OCISessionEnd
>ld: 0711-317 ERROR: Undefined symbol: .OCITransPrepare
>ld: 0711-317 ERROR: Undefined symbol: .OCITransStart
>ld: 0711-317 ERROR: Undefined symbol: .OCITransCommit
>ld: 0711-317 ERROR: Undefined symbol: .OCIClientVersion
>ld: 0711-317 ERROR: Undefined symbol: .OCISubscriptionUnRegister
>ld: 0711-317 ERROR: Undefined symbol: .OCIObjectGetAttr
>ld: 0711-317 ERROR: Undefined symbol: .OCIObjectUnpin
>ld: 0711-317 ERROR: Undefined symbol: .OCISessionPoolCreate
>ld: 0711-317 ERROR: Undefined symbol: .OCISessionPoolDestroy
>ld: 0711-317 ERROR: Undefined symbol: .OCISessionGet
>ld: 0711-317 ERROR: Undefined symbol: .OCIServerAttach
>ld: 0711-317 ERROR: Undefined symbol: .OCISessionBegin
>ld: 0711-317 ERROR: Undefined symbol: .OCIServerDetach
>ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more information.
>collect2: ld returned 8 exit status
>[zaclppxdba01:root:/software/Python/cx_Oracle-5.0.4:]
>****************?
>

Maybe the easiest would be to use your favourite available compiler on that 
platform, and compile your Python AND cx_Oracle with the same.

Tamás Gulácsi


      

Re: [cx-oracle-users] cx_oracle module AIX6.1 Oracle 11.2(64bit) (Zane Ally)

[Tamás G. <gt...@gt...>]

>
> Date: Tue, 14 Dec 2010 00:00:53 -0800 (PST)
> From: Zane Ally <zan...@ya...>
> Subject: Re: [cx-oracle-users] cx_oracle module AIX6.1 Oracle
>        11.2(64bit)
> To: cx-...@li...
> Message-ID: <319...@we...>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Hi
>
> Thanks for the feedback, much appreciated.
> Yes, thought I was being a bit ambitious.
>
> -No AIX xlC Compiler installed, using gcc.
> -Python 2.6 was not compiled, I installed rpm binary
> -cx_oracle source?is cx_Oracle-5.0.4.tar.gz
>
> My environement:
>
> [zaclppxdba01:root:/home/root:] rpm -aq | grep gcc
> gcc-4.2.0-3
>
> [zaclppxdba01:root:/home/root:] rpm -aq | egrep "gcc|python"
> gcc-4.2.0-3
> python-2.6.2-1
> python-devel-2.6.2-1
>
> [zaclppxdba01:root:/home/root:] oslevel -s
> 6100-05-01-1016
>
> [zaclppxdba01:root:/home/root:] python -V
> Python 2.6.2
>
> This says nothing about the "wideness" of the installed Python (whether it
is 32 or 64 bit).
What about the suggested
file $(which python); ldd $(which python)
commands?


> And the error
> ?
> ****************
> [zaclppxdba01:root:/software/Python/cx_Oracle-5.0.4:] python setup.py build
> running build
> running build_ext
> building 'cx_Oracle' extension
> cc_r -qlanglvl=extc89 -DNDEBUG -O
> -I/app/oracle/product/11.2.0/dbhome_1/rdbms/demo
> -I/app/oracle/product/11.2.0/dbhome_1/rdbms/public
> -I/opt/freeware/include/python2.6 -c cx_Oracle.c -o
> build/temp.aix-6.1-2.6-10g/cx_Oracle.o -DBUILD_VERSION=5.0.4
>

This is the command setup.py wants to use to compile cx_Oracle - clearly it
uses cc_r, which is an AIX xlc variant.

cc_r: unrecognized option '-qlanglvl=extc89'
> /opt/freeware/lib/python2.6/config/ld_so_aix cc_r -qlanglvl=extc89
> -bI:/opt/freeware/lib/python2.6/config/python.exp
> build/temp.aix-6.1-2.6-10g/cx_Oracle.o
> -L/app/oracle/product/11.2.0/dbhome_1/lib
> -L/app/oracle/product/11.2.0/dbhome_1 -lclntsh -o
> build/lib.aix-6.1-2.6-10g/cx_Oracle.so
> cc_r: unrecognized option '-qlanglvl=extc89'
>

Seems your version of cc_r is not the same as your Python was built with.

ld: 0711-317 ERROR: Undefined symbol: .OCIErrorGet
> ld: 0711-317 ERROR: Undefined symbol: .OCIAttrSet
> ld: 0711-317 ERROR: Undefined symbol: .OCIHandleAlloc
> ld: 0711-317 ERROR: Undefined symbol: .OCIHandleFree
> ld: 0711-317 ERROR: Undefined symbol: .OCIStmtRelease
> ld: 0711-317 ERROR: Undefined symbol: .OCIIntervalGetDaySecond
> ld: 0711-317 ERROR: Undefined symbol: .OCIIntervalSetDaySecond
> ld: 0711-317 ERROR: Undefined symbol: .OCIDescriptorFree
> ld: 0711-317 ERROR: Undefined symbol: .OCIDescriptorAlloc
> ld: 0711-317 ERROR: Undefined symbol: .OCINumberToReal
> ld: 0711-317 ERROR: Undefined symbol: .OCINumberToInt
> ld: 0711-317 ERROR: Undefined symbol: .OCINumberToText
> ld: 0711-317 ERROR: Undefined symbol: .OCINumberFromInt
> ld: 0711-317 ERROR: Undefined symbol: .OCINumberFromText
> ld: 0711-317 ERROR: Undefined symbol: .OCINumberFromReal
> ld: 0711-317 ERROR: Undefined symbol: .OCIAttrGet
> ld: 0711-317 ERROR: Undefined symbol: .OCIBindByName
> ld: 0711-317 ERROR: Undefined symbol: .OCIBindByPos
> ld: 0711-317 ERROR: Undefined symbol: .OCIParamGet
> ld: 0711-317 ERROR: Undefined symbol: .OCIDefineByPos
> ld: 0711-317 ERROR: Undefined symbol: .OCIDateTimeGetDate
> ld: 0711-317 ERROR: Undefined symbol: .OCIDateTimeGetTime
> ld: 0711-317 ERROR: Undefined symbol: .OCIStringPtr
> ld: 0711-317 ERROR: Undefined symbol: .OCIStringSize
> ld: 0711-317 ERROR: Undefined symbol: .OCIIterCreate
> ld: 0711-317 ERROR: Undefined symbol: .OCIIterNext
> ld: 0711-317 ERROR: Undefined symbol: .OCIIterDelete
> ld: 0711-317 ERROR: Undefined symbol: .OCIDefineObject
> ld: 0711-317 ERROR: Undefined symbol: .OCIObjectPin
> ld: 0711-317 ERROR: Undefined symbol: .OCIDescribeAny
> ld: 0711-317 ERROR: Undefined symbol: .OCIObjectFree
> ld: 0711-317 ERROR: Undefined symbol: .OCILobTrim
> ld: 0711-317 ERROR: Undefined symbol: .OCILobWrite
> ld: 0711-317 ERROR: Undefined symbol: .OCILobIsTemporary
> ld: 0711-317 ERROR: Undefined symbol: .OCILobCreateTemporary
> ld: 0711-317 ERROR: Undefined symbol: .OCILobFreeTemporary
> ld: 0711-317 ERROR: Undefined symbol: .OCIDateTimeConstruct
> ld: 0711-317 ERROR: Undefined symbol: .OCIDateTimeCheck
> ld: 0711-317 ERROR: Undefined symbol: .OCIStmtExecute
> ld: 0711-317 ERROR: Undefined symbol: .OCILobFileExists
> ld: 0711-317 ERROR: Undefined symbol: .OCILobFileSetName
> ld: 0711-317 ERROR: Undefined symbol: .OCILobFileGetName
> ld: 0711-317 ERROR: Undefined symbol: .OCILobIsOpen
> ld: 0711-317 ERROR: Undefined symbol: .OCILobGetChunkSize
> ld: 0711-317 ERROR: Undefined symbol: .OCILobGetLength
> ld: 0711-317 ERROR: Undefined symbol: .OCILobFileOpen
> ld: 0711-317 ERROR: Undefined symbol: .OCILobRead
> ld: 0711-317 ERROR: Undefined symbol: .OCILobFileClose
> ld: 0711-317 ERROR: Undefined symbol: .OCILobClose
> ld: 0711-317 ERROR: Undefined symbol: .OCILobOpen
> ld: 0711-317 ERROR: Undefined symbol: .OCITransRollback
> ld: 0711-317 ERROR: Undefined symbol: .OCISessionRelease
> ld: 0711-317 ERROR: Undefined symbol: .OCIStmtPrepare
> ld: 0711-317 ERROR: Undefined symbol: .OCIStmtGetBindInfo
> ld: 0711-317 ERROR: Undefined symbol: .OCIStmtPrepare2
> ld: 0711-317 ERROR: Undefined symbol: .OCIStmtFetch
> ld: 0711-317 ERROR: Undefined symbol: .OCINlsCharSetIdToName
> ld: 0711-317 ERROR: Undefined symbol: .OCINlsNameMap
> ld: 0711-317 ERROR: Undefined symbol: .OCIPasswordChange
> ld: 0711-317 ERROR: Undefined symbol: .OCISubscriptionRegister
> ld: 0711-317 ERROR: Undefined symbol: .OCIEnvNlsCreate
> ld: 0711-317 ERROR: Undefined symbol: .OCINlsNumericInfoGet
> ld: 0711-317 ERROR: Undefined symbol: .OCICollSize
> ld: 0711-317 ERROR: Undefined symbol: .OCICollGetElem
> ld: 0711-317 ERROR: Undefined symbol: .OCIDBStartup
> ld: 0711-317 ERROR: Undefined symbol: .OCIDBShutdown
> ld: 0711-317 ERROR: Undefined symbol: .OCIPing
> ld: 0711-317 ERROR: Undefined symbol: .OCIUserCallbackGet
> ld: 0711-317 ERROR: Undefined symbol: .OCIUserCallbackRegister
> ld: 0711-317 ERROR: Undefined symbol: .OCIBreak
> ld: 0711-317 ERROR: Undefined symbol: .OCISessionEnd
> ld: 0711-317 ERROR: Undefined symbol: .OCITransPrepare
> ld: 0711-317 ERROR: Undefined symbol: .OCITransStart
> ld: 0711-317 ERROR: Undefined symbol: .OCITransCommit
> ld: 0711-317 ERROR: Undefined symbol: .OCIClientVersion
> ld: 0711-317 ERROR: Undefined symbol: .OCISubscriptionUnRegister
> ld: 0711-317 ERROR: Undefined symbol: .OCIObjectGetAttr
> ld: 0711-317 ERROR: Undefined symbol: .OCIObjectUnpin
> ld: 0711-317 ERROR: Undefined symbol: .OCISessionPoolCreate
> ld: 0711-317 ERROR: Undefined symbol: .OCISessionPoolDestroy
> ld: 0711-317 ERROR: Undefined symbol: .OCISessionGet
> ld: 0711-317 ERROR: Undefined symbol: .OCIServerAttach
> ld: 0711-317 ERROR: Undefined symbol: .OCISessionBegin
> ld: 0711-317 ERROR: Undefined symbol: .OCIServerDetach
> ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more
> information.
> collect2: ld returned 8 exit status
> [zaclppxdba01:root:/software/Python/cx_Oracle-5.0.4:]
> ****************?
>

Maybe the easiest would be to use your favourite available compiler on that
platform, and compile your Python AND cx_Oracle with the same.

Tamás Gulácsi

Re: [cx-oracle-users] cx_oracle module AIX6.1 Oracle 11.2(64bit)

[Zane A. <zan...@ya...>]

Hi 

Thanks for the feedback, much appreciated.
Yes, thought I was being a bit ambitious.

-No AIX xlC Compiler installed, using gcc.
-Python 2.6 was not compiled, I installed rpm binary
-cx_oracle source is cx_Oracle-5.0.4.tar.gz 

My environement:

[zaclppxdba01:root:/home/root:] rpm -aq | grep gcc
gcc-4.2.0-3

[zaclppxdba01:root:/home/root:] rpm -aq | egrep "gcc|python"
gcc-4.2.0-3
python-2.6.2-1
python-devel-2.6.2-1

[zaclppxdba01:root:/home/root:] oslevel -s
6100-05-01-1016

[zaclppxdba01:root:/home/root:] python -V
Python 2.6.2

And the error
 
****************
[zaclppxdba01:root:/software/Python/cx_Oracle-5.0.4:] python setup.py build
running build
running build_ext
building 'cx_Oracle' extension
cc_r -qlanglvl=extc89 -DNDEBUG -O 
-I/app/oracle/product/11.2.0/dbhome_1/rdbms/demo 
-I/app/oracle/product/11.2.0/dbhome_1/rdbms/public 
-I/opt/freeware/include/python2.6 -c cx_Oracle.c -o 
build/temp.aix-6.1-2.6-10g/cx_Oracle.o -DBUILD_VERSION=5.0.4
cc_r: unrecognized option '-qlanglvl=extc89'
/opt/freeware/lib/python2.6/config/ld_so_aix cc_r -qlanglvl=extc89 
-bI:/opt/freeware/lib/python2.6/config/python.exp 
build/temp.aix-6.1-2.6-10g/cx_Oracle.o -L/app/oracle/product/11.2.0/dbhome_1/lib 
-L/app/oracle/product/11.2.0/dbhome_1 -lclntsh -o 
build/lib.aix-6.1-2.6-10g/cx_Oracle.so
cc_r: unrecognized option '-qlanglvl=extc89'
ld: 0711-317 ERROR: Undefined symbol: .OCIErrorGet
ld: 0711-317 ERROR: Undefined symbol: .OCIAttrSet
ld: 0711-317 ERROR: Undefined symbol: .OCIHandleAlloc
ld: 0711-317 ERROR: Undefined symbol: .OCIHandleFree
ld: 0711-317 ERROR: Undefined symbol: .OCIStmtRelease
ld: 0711-317 ERROR: Undefined symbol: .OCIIntervalGetDaySecond
ld: 0711-317 ERROR: Undefined symbol: .OCIIntervalSetDaySecond
ld: 0711-317 ERROR: Undefined symbol: .OCIDescriptorFree
ld: 0711-317 ERROR: Undefined symbol: .OCIDescriptorAlloc
ld: 0711-317 ERROR: Undefined symbol: .OCINumberToReal
ld: 0711-317 ERROR: Undefined symbol: .OCINumberToInt
ld: 0711-317 ERROR: Undefined symbol: .OCINumberToText
ld: 0711-317 ERROR: Undefined symbol: .OCINumberFromInt
ld: 0711-317 ERROR: Undefined symbol: .OCINumberFromText
ld: 0711-317 ERROR: Undefined symbol: .OCINumberFromReal
ld: 0711-317 ERROR: Undefined symbol: .OCIAttrGet
ld: 0711-317 ERROR: Undefined symbol: .OCIBindByName
ld: 0711-317 ERROR: Undefined symbol: .OCIBindByPos
ld: 0711-317 ERROR: Undefined symbol: .OCIParamGet
ld: 0711-317 ERROR: Undefined symbol: .OCIDefineByPos
ld: 0711-317 ERROR: Undefined symbol: .OCIDateTimeGetDate
ld: 0711-317 ERROR: Undefined symbol: .OCIDateTimeGetTime
ld: 0711-317 ERROR: Undefined symbol: .OCIStringPtr
ld: 0711-317 ERROR: Undefined symbol: .OCIStringSize
ld: 0711-317 ERROR: Undefined symbol: .OCIIterCreate
ld: 0711-317 ERROR: Undefined symbol: .OCIIterNext
ld: 0711-317 ERROR: Undefined symbol: .OCIIterDelete
ld: 0711-317 ERROR: Undefined symbol: .OCIDefineObject
ld: 0711-317 ERROR: Undefined symbol: .OCIObjectPin
ld: 0711-317 ERROR: Undefined symbol: .OCIDescribeAny
ld: 0711-317 ERROR: Undefined symbol: .OCIObjectFree
ld: 0711-317 ERROR: Undefined symbol: .OCILobTrim
ld: 0711-317 ERROR: Undefined symbol: .OCILobWrite
ld: 0711-317 ERROR: Undefined symbol: .OCILobIsTemporary
ld: 0711-317 ERROR: Undefined symbol: .OCILobCreateTemporary
ld: 0711-317 ERROR: Undefined symbol: .OCILobFreeTemporary
ld: 0711-317 ERROR: Undefined symbol: .OCIDateTimeConstruct
ld: 0711-317 ERROR: Undefined symbol: .OCIDateTimeCheck
ld: 0711-317 ERROR: Undefined symbol: .OCIStmtExecute
ld: 0711-317 ERROR: Undefined symbol: .OCILobFileExists
ld: 0711-317 ERROR: Undefined symbol: .OCILobFileSetName
ld: 0711-317 ERROR: Undefined symbol: .OCILobFileGetName
ld: 0711-317 ERROR: Undefined symbol: .OCILobIsOpen
ld: 0711-317 ERROR: Undefined symbol: .OCILobGetChunkSize
ld: 0711-317 ERROR: Undefined symbol: .OCILobGetLength
ld: 0711-317 ERROR: Undefined symbol: .OCILobFileOpen
ld: 0711-317 ERROR: Undefined symbol: .OCILobRead
ld: 0711-317 ERROR: Undefined symbol: .OCILobFileClose
ld: 0711-317 ERROR: Undefined symbol: .OCILobClose
ld: 0711-317 ERROR: Undefined symbol: .OCILobOpen
ld: 0711-317 ERROR: Undefined symbol: .OCITransRollback
ld: 0711-317 ERROR: Undefined symbol: .OCISessionRelease
ld: 0711-317 ERROR: Undefined symbol: .OCIStmtPrepare
ld: 0711-317 ERROR: Undefined symbol: .OCIStmtGetBindInfo
ld: 0711-317 ERROR: Undefined symbol: .OCIStmtPrepare2
ld: 0711-317 ERROR: Undefined symbol: .OCIStmtFetch
ld: 0711-317 ERROR: Undefined symbol: .OCINlsCharSetIdToName
ld: 0711-317 ERROR: Undefined symbol: .OCINlsNameMap
ld: 0711-317 ERROR: Undefined symbol: .OCIPasswordChange
ld: 0711-317 ERROR: Undefined symbol: .OCISubscriptionRegister
ld: 0711-317 ERROR: Undefined symbol: .OCIEnvNlsCreate
ld: 0711-317 ERROR: Undefined symbol: .OCINlsNumericInfoGet
ld: 0711-317 ERROR: Undefined symbol: .OCICollSize
ld: 0711-317 ERROR: Undefined symbol: .OCICollGetElem
ld: 0711-317 ERROR: Undefined symbol: .OCIDBStartup
ld: 0711-317 ERROR: Undefined symbol: .OCIDBShutdown
ld: 0711-317 ERROR: Undefined symbol: .OCIPing
ld: 0711-317 ERROR: Undefined symbol: .OCIUserCallbackGet
ld: 0711-317 ERROR: Undefined symbol: .OCIUserCallbackRegister
ld: 0711-317 ERROR: Undefined symbol: .OCIBreak
ld: 0711-317 ERROR: Undefined symbol: .OCISessionEnd
ld: 0711-317 ERROR: Undefined symbol: .OCITransPrepare
ld: 0711-317 ERROR: Undefined symbol: .OCITransStart
ld: 0711-317 ERROR: Undefined symbol: .OCITransCommit
ld: 0711-317 ERROR: Undefined symbol: .OCIClientVersion
ld: 0711-317 ERROR: Undefined symbol: .OCISubscriptionUnRegister
ld: 0711-317 ERROR: Undefined symbol: .OCIObjectGetAttr
ld: 0711-317 ERROR: Undefined symbol: .OCIObjectUnpin
ld: 0711-317 ERROR: Undefined symbol: .OCISessionPoolCreate
ld: 0711-317 ERROR: Undefined symbol: .OCISessionPoolDestroy
ld: 0711-317 ERROR: Undefined symbol: .OCISessionGet
ld: 0711-317 ERROR: Undefined symbol: .OCIServerAttach
ld: 0711-317 ERROR: Undefined symbol: .OCISessionBegin
ld: 0711-317 ERROR: Undefined symbol: .OCIServerDetach
ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more information.
collect2: ld returned 8 exit status
[zaclppxdba01:root:/software/Python/cx_Oracle-5.0.4:]
**************** 
 
Thanks
Zane


________________________________
From: inkblotter <ink...@gm...>
To: cx-...@li...
Sent: Tue, December 14, 2010 4:36:12 AM
Subject: Re: [cx-oracle-users] cx_oracle module AIX6.1 Oracle 11.2(64bit)

I have built many version of cx_Oracle on AIX 6.1, most recently with xlC_r  10 
compiler, against Oracle 10 and 11.2.  All 64-bit.

It takes a fair amount of finesse to build it, and depends on how you build 
python as well.  I recommend the latest version of cx_Oracle source code.   


I have built cx_Oracle against python 3.2 as well as against python 2.4--2.7, 64 
bit on many different platforms.

On AIX  you cannot expect to simply type 'python setup.py build', and expect it 
to work.  So please be specific: oslevel -s,  xlC_r -qversion, python -V and the 
error you are encountering and I will try to help.

If you have problems you cannot resolve please raise those issues on this 
mailing list.


BTW , it doesn't matter that you have no 32-bit libs.  That complaint is proably 
specious.  It may mean that your python was built 32-bit and that would be a 
problem.   file `which python` and ldd `which python` might give some clues.


On 12/13/2010 04:19 PM, Zane Ally wrote: 
Hi
>
>Please advise if source is available for cx_oracle to be compiled on AIX6.1 
>running Oracle 11.2 64bit.
>Have some problems compiling this on the system above on a IBM Power7 Server.
>
>Is this the issue with Oracle11.2 not having 32bit libraries?
>I do not see any lib32 libraries in my Oracle 11.2 Enterprise Edition install on 
>AIX6.1
>
>
>Please assist
>
>Thanks
>Zane
>
> ------------------------------------------------------------------------------ 
>Lotusphere 2011 Register now for Lotusphere 2011 and learn how to connect the 
>dots, take your collaborative environment to the next level, and enter the era 
>of Social Business. http://p.sf.net/sfu/lotusphere-d2d
> _______________________________________________ cx-oracle-users mailing list 
>cx-...@li... 
>https://lists.sourceforge.net/lists/listinfo/cx-oracle-users   
>



      

Re: [cx-oracle-users] cx_oracle module AIX6.1 Oracle 11.2(64bit)

[inkblotter <ink...@gm...>]

I have built many version of cx_Oracle on AIX 6.1, most recently with 
xlC_r  10 compiler, against Oracle 10 and 11.2.  All 64-bit.

It takes a fair amount of finesse to build it, and depends on how you 
build python as well.  I recommend the latest version of cx_Oracle 
source code.

I have built cx_Oracle against python 3.2 as well as against python 
2.4--2.7, 64 bit on many different platforms.

On AIX  you cannot expect to simply type 'python setup.py build', and 
expect it to work.  So please be specific: oslevel -s,  xlC_r -qversion, 
python -V and the error you are encountering and I will try to help.

If you have problems you cannot resolve please raise those issues on 
this mailing list.


BTW , it doesn't matter that you have no 32-bit libs.  That complaint is 
proably specious.  It may mean that your python was built 32-bit and 
that would be a problem.   file `which python` and ldd `which python` 
might give some clues.


On 12/13/2010 04:19 PM, Zane Ally wrote:
> Hi
> Please advise if source is available for cx_oracle to be compiled on 
> AIX6.1 running Oracle 11.2 64bit.
> Have some problems compiling this on the system above on a IBM Power7 
> Server.
> Is this the issue with Oracle11.2 not having 32bit libraries?
> I do not see any lib32 libraries in my Oracle 11.2 Enterprise Edition 
> install on AIX6.1
> Please assist
> Thanks
> Zane
>
>
> ------------------------------------------------------------------------------
> Lotusphere 2011
> Register now for Lotusphere 2011 and learn how
> to connect the dots, take your collaborative environment
> to the next level, and enter the era of Social Business.
> http://p.sf.net/sfu/lotusphere-d2d
>
>
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>