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

Re: [cx-oracle-users] User defined types / objects

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

Anthony Tuininga kirjoitti:
> On 8/3/06, Jani Tiainen <jan...@ke...> wrote:
>> Hi,
>>
>> I was trying to read user defined type (actually MDSYS.SDO_GEOMETRY to
>> be able to mess with spatial stuff) from database and I got only
>> "unhandled datatype" exception.
>>
>> Is user defined types or objects supported by cx_Oracle?
> 
> Not yet.

Well, not first one. AFAIK only Oracle's own JDBC drivers are only
drivers beside raw OCI that supports objects.

>> Is there plans to support them?
> 
> Yes. But nothing definite at the moment.

Hmm... Then if I have time I might take a look at them, since I really
need those spatial objects... :D

-- 

Jani Tiainen

Re: [cx-oracle-users] Issue with fetchraw and executemanyprepared on 4.2.0

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

Thanks for that it now works fine.

Chris

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

> Yes. That is expected behavior. I guess I should have been clearer in
> the change log. :-(
> 
> The new cursor attribute bindarraysize is used to control the number
> of rows used to bind. If you use execute() the default of 1 is
> perfectly acceptable. If you use executemany() automatic rebinds are
> done as needed. That is __not__ done with executemanyprepared() as it
> is assumed that everything is ready to go. If you change your one
> statement to say "c2.bindarraysize = 5" then everything should work as
> before. Hopefully that makes sense to you. :-)
> 
> On 8/3/06, Chris Dunscombe <cdu...@ya...> wrote:
> > Anthony,
> >
> > Here's the test case (surfaced as Oracle primary key errors) for issues with fetchraw /
> > executmanyprepared in 4.2.0 (Oracle 9.2.0.7 on Linux)
> >
> > Table setup
> >
> > create table input (col1 char(3), col2 char(2));
> > insert into input values ('xxx', 'xx');
> > insert into input values ('yyy', 'yy');
> > create table output (col1 char(3), col2 char(2));
> >
> > Python code
> >
> > import cx_Oracle as cx
> > db1 = cx.connect("u1/p1@db1")
> > c1 = db1.cursor()
> > c2 = db1.cursor()
> > c1.arraysize = 5
> > c2.arraysize = 5
> > sourceVars = c1.execute("select col1,col2 from input")
> > targetVars = c2.setinputsizes(*sourceVars)
> > c2.prepare("insert into output (col1,col2) values(:arg1, :arg2)")
> > rowsFetched = c1.fetchraw()
> > print str(rowsFetched)
> > c2.executemanyprepared(rowsFetched)
> > db1.commit()
> >
> > Fails with:
> >
> > Traceback (most recent call last):
> >   File "selIns.py", line 13, in ?
> >     c2.executemanyprepared(rowsFetched)
> > cx_Oracle.InterfaceError: iterations exceed bind array size
> >
> > in 4.2.0 but works fine with 4.1.2
> >
> > Hope this helps.
> >
> > Chris
> >
> >
> > __________________________________________________
> > 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] Issue with fetchraw and executemanyprepared on 4.2.0

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

Yes. That is expected behavior. I guess I should have been clearer in
the change log. :-(

The new cursor attribute bindarraysize is used to control the number
of rows used to bind. If you use execute() the default of 1 is
perfectly acceptable. If you use executemany() automatic rebinds are
done as needed. That is __not__ done with executemanyprepared() as it
is assumed that everything is ready to go. If you change your one
statement to say "c2.bindarraysize = 5" then everything should work as
before. Hopefully that makes sense to you. :-)

On 8/3/06, Chris Dunscombe <cdu...@ya...> wrote:
> Anthony,
>
> Here's the test case (surfaced as Oracle primary key errors) for issues with fetchraw /
> executmanyprepared in 4.2.0 (Oracle 9.2.0.7 on Linux)
>
> Table setup
>
> create table input (col1 char(3), col2 char(2));
> insert into input values ('xxx', 'xx');
> insert into input values ('yyy', 'yy');
> create table output (col1 char(3), col2 char(2));
>
> Python code
>
> import cx_Oracle as cx
> db1 = cx.connect("u1/p1@db1")
> c1 = db1.cursor()
> c2 = db1.cursor()
> c1.arraysize = 5
> c2.arraysize = 5
> sourceVars = c1.execute("select col1,col2 from input")
> targetVars = c2.setinputsizes(*sourceVars)
> c2.prepare("insert into output (col1,col2) values(:arg1, :arg2)")
> rowsFetched = c1.fetchraw()
> print str(rowsFetched)
> c2.executemanyprepared(rowsFetched)
> db1.commit()
>
> Fails with:
>
> Traceback (most recent call last):
>   File "selIns.py", line 13, in ?
>     c2.executemanyprepared(rowsFetched)
> cx_Oracle.InterfaceError: iterations exceed bind array size
>
> in 4.2.0 but works fine with 4.1.2
>
> Hope this helps.
>
> Chris
>
>
> __________________________________________________
> 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] User defined types / objects

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

On 8/3/06, Jani Tiainen <jan...@ke...> wrote:
> Hi,
>
> I was trying to read user defined type (actually MDSYS.SDO_GEOMETRY to
> be able to mess with spatial stuff) from database and I got only
> "unhandled datatype" exception.
>
> Is user defined types or objects supported by cx_Oracle?

Not yet.

> Is there plans to support them?

Yes. But nothing definite at the moment.

> --
>
> Jani Tiainen
>
> -------------------------------------------------------------------------
> 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] building version 4.2 with Python 2.2

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

They are indeed harmless.

On 8/2/06, David Carson <dcc...@gm...> wrote:
> I just tried to build 4.2 on an old RedHat 7.3 machine, using Python 2.2.  I
> get lots of warnings that I don't see when I build with Python 2.3 or 2.4.
> Is this to be expected?  They look harmless enough:
>
>  [build-sc@smoke cx_Oracle-4.2] python2 setup.py build
>  running build
>  running build_ext
>  building 'cx_Oracle' extension
>  creating build
>  creating build/temp.linux-i686-2.2
>  gcc -DNDEBUG -g -O3 -Wall -Wstrict-prototypes -fPIC
> -I/opt/oracle/product/9.2.0/rdbms/demo
> -I/opt/oracle/product/9.2.0/rdbms/public
> -I/opt/oracle/product/9.2.0/network/public
> -I/opt/oracle/product/9.2.0/sdk/include
> -I/usr/include/python2.2 -c cx_Oracle.c -o
> build/temp.linux-i686-2.2/cx_Oracle.o -DBUILD_VERSION=4.2
>  In file included from
> /opt/oracle/product/9.2.0/rdbms/demo/oci.h:2138,
>                   from cx_Oracle.c:9:
>  /opt/oracle/product/9.2.0/rdbms/demo/oci1.h:148: warning:
> function declaration isn't a prototype
>  In file included from
> /opt/oracle/product/9.2.0/rdbms/demo/ociap.h:190,
>                   from
> /opt/oracle/product/9.2.0/rdbms/demo/oci.h:2163,
>                   from cx_Oracle.c:9:
>  /opt/oracle/product/9.2.0/rdbms/public/nzt.h:667: warning:
> function declaration isn't a prototype
>  /opt/oracle/product/9.2.0/rdbms/public/nzt.h:2655:
> warning: function declaration isn't a prototype
>  /opt/oracle/product/9.2.0/rdbms/public/nzt.h:2664:
> warning: function declaration isn't a prototype
>  /opt/oracle/product/9.2.0/rdbms/public/nzt.h:2674:
> warning: function declaration isn't a prototype
>  /opt/oracle/product/9.2.0/rdbms/public/nzt.h:2683:
> warning: function declaration isn't a prototype
>  /opt/oracle/product/9.2.0/rdbms/public/nzt.h:2692:
> warning: function declaration isn't a prototype
>  /opt/oracle/product/9.2.0/rdbms/public/nzt.h:2701:
> warning: function declaration isn't a prototype
>  /opt/oracle/product/9.2.0/rdbms/public/nzt.h:2709:
> warning: function declaration isn't a prototype
>  /opt/oracle/product/9.2.0/rdbms/public/nzt.h:2719:
> warning: function declaration isn't a prototype
>  In file included from
> /opt/oracle/product/9.2.0/rdbms/demo/oci.h:2163,
>                   from cx_Oracle.c:9:
>  /opt/oracle/product/9.2.0/rdbms/demo/ociap.h:6888:
> warning: function declaration isn't a prototype
>  /opt/oracle/product/9.2.0/rdbms/demo/ociap.h:9790:
> warning: function declaration isn't a prototype
>  /opt/oracle/product/9.2.0/rdbms/demo/ociap.h:9796:
> warning: function declaration isn't a prototype
>  In file included from Connection.c:416,
>                   from SessionPool.c:134,
>                   from cx_Oracle.c:111:
>  Callback.c: In function `Callback_BindByNameArgs':
>  Callback.c:78: warning: value computed is not used
>  Callback.c:79: warning: value computed is not used
>  Callback.c: In function `Callback_DefineByPosArgs':
>  Callback.c:123: warning: value computed is not used
>  Callback.c:124: warning: value computed is not used
>  Callback.c: In function `Callback_ExecuteArgs':
>  Callback.c:155: warning: value computed is not used
>  Callback.c:157: warning: value computed is not used
>  Callback.c: In function `Callback_FetchArgs':
>  Callback.c:178: warning: value computed is not used
>  Callback.c: In function `Callback_PrepareArgs':
>  Callback.c:203: warning: value computed is not used
>  creating build/lib.linux-i686-2.2
>  gcc -shared build/temp.linux-i686-2.2/cx_Oracle.o
> -L/opt/oracle/product/9.2.0/lib -L/opt/oracle/product/9.2.0
> -Wl,-R/opt/oracle/product/9.2.0/lib
> -Wl,-R/opt/oracle/product/9.2.0 -lclntsh -o
> build/lib.linux-i686-2.2/cx_Oracle.so
>  [build-sc@smoke cx_Oracle-4.2]
>
>
> -------------------------------------------------------------------------
> 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
>
>
>

[cx-oracle-users] Issue with fetchraw and executemanyprepared on 4.2.0

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

Anthony,

Here's the test case (surfaced as Oracle primary key errors) for issues with fetchraw /
executmanyprepared in 4.2.0 (Oracle 9.2.0.7 on Linux)

Table setup

create table input (col1 char(3), col2 char(2));
insert into input values ('xxx', 'xx');
insert into input values ('yyy', 'yy');
create table output (col1 char(3), col2 char(2));

Python code

import cx_Oracle as cx
db1 = cx.connect("u1/p1@db1")
c1 = db1.cursor()
c2 = db1.cursor()
c1.arraysize = 5
c2.arraysize = 5
sourceVars = c1.execute("select col1,col2 from input")
targetVars = c2.setinputsizes(*sourceVars)
c2.prepare("insert into output (col1,col2) values(:arg1, :arg2)")
rowsFetched = c1.fetchraw()
print str(rowsFetched)
c2.executemanyprepared(rowsFetched)
db1.commit()

Fails with:

Traceback (most recent call last):
  File "selIns.py", line 13, in ?
    c2.executemanyprepared(rowsFetched)
cx_Oracle.InterfaceError: iterations exceed bind array size

in 4.2.0 but works fine with 4.1.2

Hope this helps.

Chris


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

[cx-oracle-users] User defined types / objects

[Jani T. <jan...@ke...>]

Hi,

I was trying to read user defined type (actually MDSYS.SDO_GEOMETRY to 
be able to mess with spatial stuff) from database and I got only 
"unhandled datatype" exception.

Is user defined types or objects supported by cx_Oracle?

Is there plans to support them?

-- 

Jani Tiainen

[cx-oracle-users] building version 4.2 with Python 2.2

[David C. <dcc...@gm...>]

I just tried to build 4.2 on an old RedHat 7.3 machine, using Python 2.2.  I
get lots of warnings that I don't see when I build with Python 2.3 or 2.4.
Is this to be expected?  They look harmless enough:

[build-sc@smoke cx_Oracle-4.2] python2 setup.py build
running build
running build_ext
building 'cx_Oracle' extension
creating build
creating build/temp.linux-i686-2.2
gcc -DNDEBUG -g -O3 -Wall -Wstrict-prototypes -fPIC
-I/opt/oracle/product/9.2.0/rdbms/demo
-I/opt/oracle/product/9.2.0/rdbms/public
-I/opt/oracle/product/9.2.0/network/public
-I/opt/oracle/product/9.2.0/sdk/include -I/usr/include/python2.2 -c
cx_Oracle.c -o build/temp.linux-i686-2.2/cx_Oracle.o -DBUILD_VERSION=4.2
In file included from /opt/oracle/product/9.2.0/rdbms/demo/oci.h:2138,
                 from cx_Oracle.c:9:
/opt/oracle/product/9.2.0/rdbms/demo/oci1.h:148: warning: function
declaration isn't a prototype
In file included from /opt/oracle/product/9.2.0/rdbms/demo/ociap.h:190,
                 from /opt/oracle/product/9.2.0/rdbms/demo/oci.h:2163,
                 from cx_Oracle.c:9:
/opt/oracle/product/9.2.0/rdbms/public/nzt.h:667: warning: function
declaration isn't a prototype
/opt/oracle/product/9.2.0/rdbms/public/nzt.h:2655: warning: function
declaration isn't a prototype
/opt/oracle/product/9.2.0/rdbms/public/nzt.h:2664: warning: function
declaration isn't a prototype
/opt/oracle/product/9.2.0/rdbms/public/nzt.h:2674: warning: function
declaration isn't a prototype
/opt/oracle/product/9.2.0/rdbms/public/nzt.h:2683: warning: function
declaration isn't a prototype
/opt/oracle/product/9.2.0/rdbms/public/nzt.h:2692: warning: function
declaration isn't a prototype
/opt/oracle/product/9.2.0/rdbms/public/nzt.h:2701: warning: function
declaration isn't a prototype
/opt/oracle/product/9.2.0/rdbms/public/nzt.h:2709: warning: function
declaration isn't a prototype
/opt/oracle/product/9.2.0/rdbms/public/nzt.h:2719: warning: function
declaration isn't a prototype
In file included from /opt/oracle/product/9.2.0/rdbms/demo/oci.h:2163,
                 from cx_Oracle.c:9:
/opt/oracle/product/9.2.0/rdbms/demo/ociap.h:6888: warning: function
declaration isn't a prototype
/opt/oracle/product/9.2.0/rdbms/demo/ociap.h:9790: warning: function
declaration isn't a prototype
/opt/oracle/product/9.2.0/rdbms/demo/ociap.h:9796: warning: function
declaration isn't a prototype
In file included from Connection.c:416,
                 from SessionPool.c:134,
                 from cx_Oracle.c:111:
Callback.c: In function `Callback_BindByNameArgs':
Callback.c:78: warning: value computed is not used
Callback.c:79: warning: value computed is not used
Callback.c: In function `Callback_DefineByPosArgs':
Callback.c:123: warning: value computed is not used
Callback.c:124: warning: value computed is not used
Callback.c: In function `Callback_ExecuteArgs':
Callback.c:155: warning: value computed is not used
Callback.c:157: warning: value computed is not used
Callback.c: In function `Callback_FetchArgs':
Callback.c:178: warning: value computed is not used
Callback.c: In function `Callback_PrepareArgs':
Callback.c:203: warning: value computed is not used
creating build/lib.linux-i686-2.2
gcc -shared build/temp.linux-i686-2.2/cx_Oracle.o
-L/opt/oracle/product/9.2.0/lib -L/opt/oracle/product/9.2.0
-Wl,-R/opt/oracle/product/9.2.0/lib -Wl,-R/opt/oracle/product/9.2.0 -lclntsh
-o build/lib.linux-i686-2.2/cx_Oracle.so
[build-sc@smoke cx_Oracle-4.2]

[cx-oracle-users] Nicola Piazza is working remotely from customer site

[Nicola P. <nic...@it...>]

I will be out of the office starting  07/31/2006 and will not return until
08/31/2006.

I'm working from a remote site, disconnected from network.
I'm able to read and reply to email only during the evening.

Please contact my manager Salvo Aliffi if you need a backup

For urgent questions, please call me on my mobile phone: +39.335.7840975

Regards
Nicola Piazza

Re: [cx-oracle-users] finding the module from a connection

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

Yes, that is the correct place. And apparently you also discovered
that this is not a problem with cx_Oracle 4.2.... :-)

On 7/29/06, Mario Frasca <mf...@zo...> wrote:
> On 2006-0728 08:06:07, Mario Frasca wrote:
> > open database connection cx. [...]
> > of the module by taking cx.__class__.__module__
> >
> > for a cx_Oracle database connection I get the string '__builtin__'
> >
> > any hints?
>
> I found the problem...  to solve it I had to modify the sources, not
> much, but still...
>
> http://docs.python.org/ext/dnt-type-methods.html states:
>     char *tp_name; /* For printing, in format "<module>.<name>" */
>
> but
> mario@loki:~/cx_Oracle-4.1$ grep tp_name Connection.c
>     "OracleConnection",       // tp_name
>
> modifying it to "cx_Oracle.OracleConnection" solves the problem.
>
> I filed a bug report on the sourceforge cx_Oracle project, hope that is
> the correct place.
>
> regards, thanks,
>
> Mario Frasca
>
>
> --
> il melo fa la mela
> il pero fa la pera
> il fico fa eccezione
>          Peppe Barra
>
> -------------------------------------------------------------------------
> 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] finding the module from a connection

[Mario F. <mf...@zo...>]

On 2006-0728 08:06:07, Mario Frasca wrote:
> open database connection cx. [...]
> of the module by taking cx.__class__.__module__
> 
> for a cx_Oracle database connection I get the string '__builtin__'
> 
> any hints?

I found the problem...  to solve it I had to modify the sources, not
much, but still...  

http://docs.python.org/ext/dnt-type-methods.html states:
    char *tp_name; /* For printing, in format "<module>.<name>" */

but 
mario@loki:~/cx_Oracle-4.1$ grep tp_name Connection.c 
    "OracleConnection",       // tp_name

modifying it to "cx_Oracle.OracleConnection" solves the problem.

I filed a bug report on the sourceforge cx_Oracle project, hope that is
the correct place.

regards, thanks,

Mario Frasca


-- 
il melo fa la mela
il pero fa la pera
il fico fa eccezione
         Peppe Barra

[cx-oracle-users] finding the module from a connection

[Mario F. <mf...@zo...>]

I'm writing a library making use of various dbapi2 modules.

one of the options to inizialize my library is from an open database
connection cx.

I don't know how to get the *module* from the connection object, but
with most other dbapi2 modules, I can at least retrieve the *name*
of the module by taking cx.__class__.__module__

for a cx_Oracle database connection I get the string '__builtin__'

any hints?

thanks in advance,
Mario Frasca

-- 
How about some patent on "(a+b)^2 == a^2+2ab+b^2" ... choose free software!

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

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

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

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

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

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.

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.

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
> > >
> > >
> > >
> > > __________________________________________________
> > > Do You Yahoo!?
> > > Tired of spam?  Yahoo! Mail has the best spam protection around
> > > http://mail.yahoo.com
> > >
> > >
> > > _______________________________________________
> > > 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 

[cx-oracle-users] cx_Oracle 4.2

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

What is cx_Oracle?

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


Where do I get it?

http://starship.python.net/crew/atuining


What's new?

 1) Added support for parsing an Oracle statement as requested by Patrick
    Blackwill.
 2) Added support for BFILEs at the request of Matthew Cahn.
 3) Added support for binding decimal.Decimal objects to cursors.
 4) Added support for reading from NCLOBs as requested by Chris Dunscombe.
 5) Added connection attributes encoding and nencoding which return the IANA
    character set name for the character set and national character set in use
    by the client.
 6) Rework module initialization to use the techniques recommended by the
    Python documentation as one user was experiencing random segfaults due
    to the use of the module dictionary after the initialization was complete.
 7) Removed support for the OPT_Threading attribute. Use the threaded keyword
    when creating connections and session pools instead.
 8) Removed support for the OPT_NumbersAsStrings attribute. Use the
    numbersAsStrings attribute on cursors instead.
 9) Use type long rather than type int in order to support long integers on
    64-bit machines as reported by Uwe Hoffmann.
10) Add cursor attribute "bindarraysize" which is defaulted to 1 and is used
    to determine the size of the arrays created for bind variables.
11) Added repr() methods to provide something a little more useful than the
    standard type name and memory address.
12) Added keyword argument support to the functions that imply such in the
    documentation as requested by Harald Armin Massa.
13) Treat an empty dictionary passed through to cursor.execute() as keyword
    arguments the same as if no keyword arguments were specified at all, as
    requested by Fabien Grumelard.
14) Fixed memory leak when a LOB read would fail.
15) Set the LDFLAGS value in the environment rather than directly in the
    setup.py file in order to satisfy those who wish to enable the use of
    debugging symbols.
16) Use __DATE__ and __TIME__ to determine the date and time of the build
    rather than passing it through directly.
17) Use Oracle types and add casts to reduce warnings as requested by Amaury
    Forgeot d'Arc.
18) Fixed typo in error message.

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

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

Great. Thanks for the update.

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
> > >
> > >
> > >
> > > __________________________________________________
> > > Do You Yahoo!?
> > > Tired of spam?  Yahoo! Mail has the best spam protection around
> > > http://mail.yahoo.com
> > >
> > >
> > > _______________________________________________
> > > 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] ImportError: libclntsh.so.10.1: cannot open shared object file: Permission denied

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

If the crontab scheduled job is running as the same user as the user
you login to on the terminal then I have no idea what might be going
on. Anyone else?

On 7/20/06, map...@ya...
<map...@ya...> wrote:
>
> The "permission denied" doesn't happen when I login to terminal and run the
> application. It just happen when I run the application through crontab
> scheduled jobs!
>
>
> Anthony Tuininga <ant...@gm...> wrote:
>
>  Hmm, is the key in the phrase "permission denied"? It seems to have
> found everything but it doesn't have the ability to actually load that
> or other shared libraries that it references.
>
> On 7/20/06, Ali Moeen wrote:
> > Hi,
> >
> > I am using RedHat Linux 4. and I developed an oracle 10g based application
> > by using cs_Oracle (cx_Oracle-4.1-10g-py23-1.i386.rpm) and Python 2.3.4.
> >
> > When I run the application through direct console connection, I works
> > perfect.
> >
> > But, when I schedule a crontab job to run the application, I receive this
> > error:
> >
> > Traceback (most recent call last):
> > File "/home/nsm1/NSM1/NSM1.py", line 5, in ?
> > import cx_Oracle
> > ImportError: libclntsh.so.10.1: cannot open shared object file: Permission
> > denied
> >
> >
> > How can I fix the problem?
> >
> > Any help would be appreciated,
> > Alan
> >
> > BTW:
> >
> > I have the following settings in my /etc/profile file:
> >
> > #-------------------------------------------
> > ORACLE_BASE=/home/oracle/oracle/product
> > ORACLE_HOME=$ORACLE_BASE/10.2.0/db_1
> > LD_LIBRARY_PATH=$ORACLE_HOME/lib
> > PATH=$PATH:$ORACLE_HOME/bin
> > ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
> > export ORACLE_BASE ORACLE_HOME ORACLE_SID LD_LIBRARY_PATH PATH
> > #-------------------------------------------
> >
> >
> >
> >
> >
> -------------------------------------------------------------------------
> > 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
>
>
> -------------------------------------------------------------------------
> 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] ImportError: libclntsh.so.10.1: cannot open shared object file: Permission denied

[<map...@ya...>]

  The “permission denied” doesn’t happen when I login to terminal and run the application. It just happen when I run the application through crontab scheduled jobs!
  

Anthony Tuininga <ant...@gm...> wrote: Hmm, is the key in the phrase "permission denied"? It seems to have
found everything but it doesn't have the ability to actually load that
or other shared libraries that it references.

On 7/20/06, Ali Moeen  wrote:
> Hi,
>
> I am using RedHat Linux 4. and I developed an oracle 10g based application
> by using cs_Oracle (cx_Oracle-4.1-10g-py23-1.i386.rpm) and Python 2.3.4.
>
> When I run the application through direct console connection, I works
> perfect.
>
> But, when I schedule a crontab job to run the application, I receive this
> error:
>
> Traceback (most recent call last):
>   File "/home/nsm1/NSM1/NSM1.py", line 5, in ?
>     import cx_Oracle
> ImportError: libclntsh.so.10.1: cannot open shared object file: Permission
> denied
>
>
> How can I fix the problem?
>
> Any help would be appreciated,
> Alan
>
> BTW:
>
> I have the following settings in my /etc/profile file:
>
> #-------------------------------------------
> ORACLE_BASE=/home/oracle/oracle/product
> ORACLE_HOME=$ORACLE_BASE/10.2.0/db_1
> LD_LIBRARY_PATH=$ORACLE_HOME/lib
> PATH=$PATH:$ORACLE_HOME/bin
> ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
> export ORACLE_BASE ORACLE_HOME ORACLE_SID LD_LIBRARY_PATH PATH
> #-------------------------------------------
>
>
>
>
> -------------------------------------------------------------------------
> 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

Re: [cx-oracle-users] ImportError: libclntsh.so.10.1: cannot open shared object file: Permission denied

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

Hmm, is the key in the phrase "permission denied"? It seems to have
found everything but it doesn't have the ability to actually load that
or other shared libraries that it references.

On 7/20/06, Ali Moeen <map...@ya...> wrote:
> Hi,
>
> I am using RedHat Linux 4. and I developed an oracle 10g based application
> by using cs_Oracle (cx_Oracle-4.1-10g-py23-1.i386.rpm) and Python 2.3.4.
>
> When I run the application through direct console connection, I works
> perfect.
>
> But, when I schedule a crontab job to run the application, I receive this
> error:
>
> Traceback (most recent call last):
>   File "/home/nsm1/NSM1/NSM1.py", line 5, in ?
>     import cx_Oracle
> ImportError: libclntsh.so.10.1: cannot open shared object file: Permission
> denied
>
>
> How can I fix the problem?
>
> Any help would be appreciated,
> Alan
>
> BTW:
>
> I have the following settings in my /etc/profile file:
>
> #-------------------------------------------
> ORACLE_BASE=/home/oracle/oracle/product
> ORACLE_HOME=$ORACLE_BASE/10.2.0/db_1
> LD_LIBRARY_PATH=$ORACLE_HOME/lib
> PATH=$PATH:$ORACLE_HOME/bin
> ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
> export ORACLE_BASE ORACLE_HOME ORACLE_SID LD_LIBRARY_PATH PATH
> #-------------------------------------------
>
>
>
>
> -------------------------------------------------------------------------
> 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
>
>
>

[cx-oracle-users] ImportError: libclntsh.so.10.1: cannot open shared object file: Permission denied

[Ali M. <map...@ya...>]

Hi,

I am using RedHat Linux 4. and I developed an oracle 10g based application by using cs_Oracle (cx_Oracle-4.1-10g-py23-1.i386.rpm) and Python 2.3.4.

When I run the application through direct console connection, I works perfect.

But, when I schedule a crontab job to run the application, I receive this error:

Traceback (most recent call last):
  File "/home/nsm1/NSM1/NSM1.py", line 5, in ?
    import cx_Oracle
ImportError: libclntsh.so.10.1: cannot open shared object file: Permission denied


How can I fix the problem?

Any help would be appreciated,
Alan

BTW:

I have the following settings in my /etc/profile file:

#-------------------------------------------
ORACLE_BASE=/home/oracle/oracle/product
ORACLE_HOME=$ORACLE_BASE/10.2.0/db_1
LD_LIBRARY_PATH=$ORACLE_HOME/lib
PATH=$PATH:$ORACLE_HOME/bin
ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export ORACLE_BASE ORACLE_HOME ORACLE_SID LD_LIBRARY_PATH PATH
#-------------------------------------------

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

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

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
> >
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Tired of spam?  Yahoo! Mail has the best spam protection around
> > http://mail.yahoo.com
> >
> >
> > _______________________________________________
> > cx-oracle-users mailing list
> > cx-...@li...
> > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
> >
>

Re: [cx-oracle-users] building cx_Oracle-4.1.2 from tar ball

[YongChul K. <god...@gm...>]

Thanks! I solved this after I sent out previous email... :-)

Thank you,
YongChul

On 7/14/06, Anthony Tuininga <ant...@gm...> wrote:
> On Linux, what will be built is cx_Oracle.so. cx_Oracle.pyd is only
> built on Windows. If the shared library cx_Oracle.so was built and
> installed properly you should be able to import cx_Oracle and use it
> to connect to an Oracle database.
>
> On 7/12/06, YongChul Kwon <god...@gm...> wrote:
> > Hello,
> >
> > I'm trying to build cx_Oracle 4.1.2 from source tar ball.
> > I have followed setup procedure but there is no cx_Oracle.pyd
> > generated; the shared library was compiled and installed successfully.
> >
> > Isn't the "setup.py build" command supposed to generate both shared
> > library and cx_Oracle.pyd?
> >
> > I'm using Linux 2.6, Oracle 10g and Python 2.4...
> >
> > Thank you,
> > YongChul
> >
> >
> > -------------------------------------------------------------------------
> > 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
>


-- 
YongChul

Re: [cx-oracle-users] building cx_Oracle-4.1.2 from tar ball

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

On Linux, what will be built is cx_Oracle.so. cx_Oracle.pyd is only
built on Windows. If the shared library cx_Oracle.so was built and
installed properly you should be able to import cx_Oracle and use it
to connect to an Oracle database.

On 7/12/06, YongChul Kwon <god...@gm...> wrote:
> Hello,
>
> I'm trying to build cx_Oracle 4.1.2 from source tar ball.
> I have followed setup procedure but there is no cx_Oracle.pyd
> generated; the shared library was compiled and installed successfully.
>
> Isn't the "setup.py build" command supposed to generate both shared
> library and cx_Oracle.pyd?
>
> I'm using Linux 2.6, Oracle 10g and Python 2.4...
>
> Thank you,
> YongChul
>
>
> -------------------------------------------------------------------------
> 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] building cx_Oracle-4.1.2 from tar ball

[YongChul K. <god...@gm...>]

Hello,

I'm trying to build cx_Oracle 4.1.2 from source tar ball.
I have followed setup procedure but there is no cx_Oracle.pyd
generated; the shared library was compiled and installed successfully.

Isn't the "setup.py build" command supposed to generate both shared
library and cx_Oracle.pyd?

I'm using Linux 2.6, Oracle 10g and Python 2.4...

Thank you,
YongChul

[cx-oracle-users] building cx_Oracle-4.1.2 from tar ball

[YongChul K. <god...@gm...>]

Hello,

I'm trying to build cx_Oracle 4.1.2 from source tar ball.
I have followed setup procedure but there is no cx_Oracle.pyd
generated; the shared library was compiled and installed successfully.

Isn't the "setup.py build" command supposed to generate both shared
library and cx_Oracle.pyd?

I'm using Linux 2.6, Oracle 10g and Python 2.4...

Thank you,
YongChul