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

Re: [cx-oracle-users] Setting client_identifier upon connect()

[Dag W. <da...@wi...>]

On Fri, 24 Aug 2012, Dag Wieers wrote:

> On Fri, 24 Aug 2012, Anthony Tuininga wrote:
>
>>  On Fri, Aug 24, 2012 at 8:30 AM, Walter Dörwald <wa...@li...>
>>  wrote:
>> >  On 24.08.12 16:00, Anthony Tuininga wrote:
>> > 
>> > >  Yes, it actually is possible and was just implemented as requested by
>> > >  Rodney Barnett. 5.1.2 has this feature included. :-)
>> > 
>> > 
>> >  Not for client_identifier:
>>
>>  You're right. I was thinking of clientinfo but that's different. Sorry
>>  about the confusion! I'll look into adding clientidentifier as well.
>
> That would be great. Let me know if I need to test something.

I made the necessary changes and requested a pull on bitbucket.org, I hope 
this is acceptable.

-- 
-- dag wieers, da...@wi..., http://dag.wieers.com/
-- dagit linux solutions, in...@da..., http://dagit.net/

[Any errors in spelling, tact or fact are transmission errors]

Re: [cx-oracle-users] A probably stupid question...

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

On Tue, Aug 28, 2012 at 1:44 PM, Kim <kim...@ya...> wrote:
> whatstr="SELECT field111 from MSG_ARCHIVE where "+searchField+" =:record_number
> and field4 between :s_time and :e_time"
> curs.prepare(whatstr)
> curs.execute(None, {'record_number':mrn,'s_time':start_time, 'e_time':end_time})
>
> searchField is actually field111, mrn is a set number (9 digits),
> the start_time and end_time are oracle timestamps.
>
> This simply hangs -- no error, no return. If I hit ctrl-c, it simply says
> keyboard interrupt (no kidding...).
>
> I am having difficulties with a python script, that was working with our 10g
> database and 11g client, but now does not work...
>
> whatstr=('select '+out_fields+' from MSG_ARCHIVE where '+searchField+' =
> :record_number and field4 between :s_time and :e_time')
> print whatstr
> curs.execute(whatstr,{'record_number':mrn, 's_time':start_time,
> 'e_time':end_time})
>
> Can anyone think of why this would have changed? I can run either a
> record_number search or a "between timestamp" search and have it work fine.
>
> Thank you very much for your time!

The problem is likely an issue with bind variable values or type
mismatches but you can only really find out by testing and debugging.
Nothing obvious to my mind from what you have written. You can make
things a lot simpler, though.

cursor.execute(sql, record_number = mrn, s_time = start_time, e_time = end_time)

Questions to consider:

If you replace the bind variables with constants does the query return
as expected?
What are the actual types of the column values that are being queried?
What are the actual types of the bind variables being passed in?
Can you issue the same query in SQL*Plus and have it return as expected?

Hopefully some of those will help you diagnose the problem. I've had a
few of these and they can be very painful to figure out. They're
"obvious" once you figure them out, of course, but getting there can
be very time consuming. Good luck!

Anthony

[cx-oracle-users] A probably stupid question...

[Kim <kim...@ya...>]

whatstr="SELECT field111 from MSG_ARCHIVE where "+searchField+" =:record_number
and field4 between :s_time and :e_time"
curs.prepare(whatstr)
curs.execute(None, {'record_number':mrn,'s_time':start_time, 'e_time':end_time})

searchField is actually field111, mrn is a set number (9 digits), 
the start_time and end_time are oracle timestamps.

This simply hangs -- no error, no return. If I hit ctrl-c, it simply says
keyboard interrupt (no kidding...).

I am having difficulties with a python script, that was working with our 10g
database and 11g client, but now does not work...

whatstr=('select '+out_fields+' from MSG_ARCHIVE where '+searchField+' =
:record_number and field4 between :s_time and :e_time')
print whatstr
curs.execute(whatstr,{'record_number':mrn, 's_time':start_time, 
'e_time':end_time})

Can anyone think of why this would have changed? I can run either a
record_number search or a "between timestamp" search and have it work fine.

Thank you very much for your time!

Re: [cx-oracle-users] Setting client_identifier upon connect()

[Dag W. <da...@wi...>]

On Mon, 27 Aug 2012, Anthony Tuininga wrote:

> On Mon, Aug 27, 2012 at 4:28 AM, Dag Wieers <da...@wi...> wrote:
>
>> I am probably doing something wrong, but I was interested in the changes to
>> allow to set the client_info on connect, but when using the SVN trunk I
>> don't see the 5.1.2 changes. It appears to be stale at 5.1.1 since
>> 2012-02-12 04:47:13 +0100.
>>
>> Where should I look for the most recent developments ?
>
> I have switched to bitbucket and Mercurial. I made that announcement
> several months ago but I clearly need to turn *off* the Subversion to
> avoid confusion. Here is the link
>
> https://bitbucket.org/anthony_tuininga/cx_oracle

Ok, sorry for that. I only joined the mailinglist last friday and the 
Sourceforge archives are not the most convenient to get up to speed. It 
took me some time to find the references to the client_info discussion.

PS I don't think I found a link on the homepage, and since Sourceforge is 
where the website is hosten, people will automatically look there. Maybe 
you can disable the CVS and SVN service on Sourceforge ?

-- 
-- dag wieers, da...@wi..., http://dag.wieers.com/
-- dagit linux solutions, in...@da..., http://dagit.net/

[Any errors in spelling, tact or fact are transmission errors]

Re: [cx-oracle-users] Setting client_identifier upon connect()

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

On Mon, Aug 27, 2012 at 4:28 AM, Dag Wieers <da...@wi...> wrote:
> On Fri, 24 Aug 2012, Dag Wieers wrote:
>
>> On Fri, 24 Aug 2012, Anthony Tuininga wrote:
>>
>>>  On Fri, Aug 24, 2012 at 8:30 AM, Walter Dörwald <wa...@li...>
>>>  wrote:
>>> >  On 24.08.12 16:00, Anthony Tuininga wrote:
>>> > > >  Yes, it actually is possible and was just implemented as requested
>>> > > > by
>>> > >  Rodney Barnett. 5.1.2 has this feature included. :-)
>>> > >  Not for client_identifier:
>>>
>>>  You're right. I was thinking of clientinfo but that's different. Sorry
>>>  about the confusion! I'll look into adding clientidentifier as well.
>>
>>
>> That would be great. Let me know if I need to test something.
>
>
> I am probably doing something wrong, but I was interested in the changes to
> allow to set the client_info on connect, but when using the SVN trunk I
> don't see the 5.1.2 changes. It appears to be stale at 5.1.1 since
> 2012-02-12 04:47:13 +0100.
>
> Where should I look for the most recent developments ?

I have switched to bitbucket and Mercurial. I made that announcement
several months ago but I clearly need to turn *off* the Subversion to
avoid confusion. Here is the link

https://bitbucket.org/anthony_tuininga/cx_oracle

Anthony

Re: [cx-oracle-users] Setting client_identifier upon connect()

[Dag W. <da...@wi...>]

On Fri, 24 Aug 2012, Dag Wieers wrote:

> On Fri, 24 Aug 2012, Anthony Tuininga wrote:
>
>>  On Fri, Aug 24, 2012 at 8:30 AM, Walter Dörwald <wa...@li...>
>>  wrote:
>> >  On 24.08.12 16:00, Anthony Tuininga wrote:
>> > 
>> > >  Yes, it actually is possible and was just implemented as requested by
>> > >  Rodney Barnett. 5.1.2 has this feature included. :-)
>> > 
>> >  Not for client_identifier:
>>
>>  You're right. I was thinking of clientinfo but that's different. Sorry
>>  about the confusion! I'll look into adding clientidentifier as well.
>
> That would be great. Let me know if I need to test something.

I am probably doing something wrong, but I was interested in the changes 
to allow to set the client_info on connect, but when using the SVN trunk I 
don't see the 5.1.2 changes. It appears to be stale at 5.1.1 since 
2012-02-12 04:47:13 +0100.

Where should I look for the most recent developments ?

-- 
-- dag wieers, da...@wi..., http://dag.wieers.com/
-- dagit linux solutions, in...@da..., http://dagit.net/

[Any errors in spelling, tact or fact are transmission errors]

Re: [cx-oracle-users] Setting client_identifier upon connect()

[Dag W. <da...@wi...>]

On Fri, 24 Aug 2012, Anthony Tuininga wrote:

> On Fri, Aug 24, 2012 at 8:30 AM, Walter Dörwald <wa...@li...> wrote:
>> On 24.08.12 16:00, Anthony Tuininga wrote:
>>
>>> Yes, it actually is possible and was just implemented as requested by
>>> Rodney Barnett. 5.1.2 has this feature included. :-)
>>
>>
>> Not for client_identifier:
>
> You're right. I was thinking of clientinfo but that's different. Sorry
> about the confusion! I'll look into adding clientidentifier as well.

That would be great. Let me know if I need to test something.

-- 
-- dag wieers, da...@wi..., http://dag.wieers.com/
-- dagit linux solutions, in...@da..., http://dagit.net/

[Any errors in spelling, tact or fact are transmission errors]

Re: [cx-oracle-users] Setting client_identifier upon connect()

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

On Fri, Aug 24, 2012 at 8:30 AM, Walter Dörwald <wa...@li...> wrote:
> On 24.08.12 16:00, Anthony Tuininga wrote:
>
>> Hi,
>>
>> Yes, it actually is possible and was just implemented as requested by
>> Rodney Barnett. 5.1.2 has this feature included. :-)
>
>
> Not for client_identifier:

You're right. I was thinking of clientinfo but that's different. Sorry
about the confusion! I'll look into adding clientidentifier as well.

Anthony

>
> $ python3.2
> Python 3.2.3 (default, Jul 20 2012, 17:32:16)
> [GCC 4.2.1 (Based on Apple Inc. build 5658) (LLVM build 2336.1.00)] on
> darwin
> Type "help", "copyright", "credits" or "license" for more information.
>>>> import cx_Oracle
>>>> cx_Oracle
> <module 'cx_Oracle' from
> '/Users/walter/.local/lib/python3.2/site-packages/cx_Oracle-5.1.2-py3.2-macosx-10.6-x86_64.egg/cx_Oracle.so'>
>>>> db = cx_Oracle.connect('u/p@db', client_identifier='foo')
> Traceback (most recent call last):
>   File "<stdin>", line 1, in <module>
> TypeError: 'client_identifier' is an invalid keyword argument for this
> function
>
> Servus,
>    Walter
>
>
>> On Fri, Aug 24, 2012 at 6:57 AM, Dag Wieers <da...@wi...> wrote:
>>>
>>> Hi,
>>>
>>> I expect this to not be possible. I am in the situation where a tool
>>> written in perl is allowed to access the database, but a tool using
>>> python
>>> is not (with the same credentials). When adding a symlink from ./perl to
>>> /usr/bin/python and using that as the shebang does work.
>>>
>>> Given the fact that the client_identifier is so easily circumvented I was
>>> wondering whether it would be possible to modify the client_identifier
>>> used upon connect() rather than having to resort to such workarounds.
>>>
>>> (Yes, I know changing the ACL is probably the best way forward and is in
>>> fact formally requested, but due to complex corporate processes this may
>>> take weeks to get executed anyway...)
>>>
>>> I know it is possible to modify the client_identifier once connected, but
>>> it seems useful to also be able to modify the client_identifier upon
>>> connect, maybe as an argument to connect().
>>>
>>> If it is not currently possible, could it be implemented in cx_Oracle ?
>>>
>>> Kind regards,
>>> --
>>> -- dag wieers, da...@wi..., http://dag.wieers.com/
>>> -- dagit linux solutions, in...@da..., http://dagit.net/
>>>
>>> [Any errors in spelling, tact or fact are transmission errors]
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> Live Security Virtual Conference
>>> Exclusive live event will cover all the ways today's security and
>>> threat landscape has changed and how IT managers can respond. Discussions
>>> will include endpoint security, mobile security and the latest in malware
>>> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
>>> _______________________________________________
>>> cx-oracle-users mailing list
>>> cx-...@li...
>>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>>
>>
>>
>> ------------------------------------------------------------------------------
>> Live Security Virtual Conference
>> Exclusive live event will cover all the ways today's security and
>> threat landscape has changed and how IT managers can respond. Discussions
>> will include endpoint security, mobile security and the latest in malware
>> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
>> _______________________________________________
>> cx-oracle-users mailing list
>> cx-...@li...
>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>>
>

Re: [cx-oracle-users] Setting client_identifier upon connect()

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

On 24.08.12 16:00, Anthony Tuininga wrote:

> Hi,
>
> Yes, it actually is possible and was just implemented as requested by
> Rodney Barnett. 5.1.2 has this feature included. :-)

Not for client_identifier:

$ python3.2
Python 3.2.3 (default, Jul 20 2012, 17:32:16)
[GCC 4.2.1 (Based on Apple Inc. build 5658) (LLVM build 2336.1.00)] on 
darwin
Type "help", "copyright", "credits" or "license" for more information.
 >>> import cx_Oracle
 >>> cx_Oracle
<module 'cx_Oracle' from 
'/Users/walter/.local/lib/python3.2/site-packages/cx_Oracle-5.1.2-py3.2-macosx-10.6-x86_64.egg/cx_Oracle.so'>
 >>> db = cx_Oracle.connect('u/p@db', client_identifier='foo')
Traceback (most recent call last):
   File "<stdin>", line 1, in <module>
TypeError: 'client_identifier' is an invalid keyword argument for this 
function

Servus,
    Walter

> On Fri, Aug 24, 2012 at 6:57 AM, Dag Wieers <da...@wi...> wrote:
>> Hi,
>>
>> I expect this to not be possible. I am in the situation where a tool
>> written in perl is allowed to access the database, but a tool using python
>> is not (with the same credentials). When adding a symlink from ./perl to
>> /usr/bin/python and using that as the shebang does work.
>>
>> Given the fact that the client_identifier is so easily circumvented I was
>> wondering whether it would be possible to modify the client_identifier
>> used upon connect() rather than having to resort to such workarounds.
>>
>> (Yes, I know changing the ACL is probably the best way forward and is in
>> fact formally requested, but due to complex corporate processes this may
>> take weeks to get executed anyway...)
>>
>> I know it is possible to modify the client_identifier once connected, but
>> it seems useful to also be able to modify the client_identifier upon
>> connect, maybe as an argument to connect().
>>
>> If it is not currently possible, could it be implemented in cx_Oracle ?
>>
>> Kind regards,
>> --
>> -- dag wieers, da...@wi..., http://dag.wieers.com/
>> -- dagit linux solutions, in...@da..., http://dagit.net/
>>
>> [Any errors in spelling, tact or fact are transmission errors]
>>
>> ------------------------------------------------------------------------------
>> Live Security Virtual Conference
>> Exclusive live event will cover all the ways today's security and
>> threat landscape has changed and how IT managers can respond. Discussions
>> will include endpoint security, mobile security and the latest in malware
>> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
>> _______________________________________________
>> cx-oracle-users mailing list
>> cx-...@li...
>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>

Re: [cx-oracle-users] Setting client_identifier upon connect()

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

Hi,

Yes, it actually is possible and was just implemented as requested by
Rodney Barnett. 5.1.2 has this feature included. :-)

Anthony

On Fri, Aug 24, 2012 at 6:57 AM, Dag Wieers <da...@wi...> wrote:
> Hi,
>
> I expect this to not be possible. I am in the situation where a tool
> written in perl is allowed to access the database, but a tool using python
> is not (with the same credentials). When adding a symlink from ./perl to
> /usr/bin/python and using that as the shebang does work.
>
> Given the fact that the client_identifier is so easily circumvented I was
> wondering whether it would be possible to modify the client_identifier
> used upon connect() rather than having to resort to such workarounds.
>
> (Yes, I know changing the ACL is probably the best way forward and is in
> fact formally requested, but due to complex corporate processes this may
> take weeks to get executed anyway...)
>
> I know it is possible to modify the client_identifier once connected, but
> it seems useful to also be able to modify the client_identifier upon
> connect, maybe as an argument to connect().
>
> If it is not currently possible, could it be implemented in cx_Oracle ?
>
> Kind regards,
> --
> -- dag wieers, da...@wi..., http://dag.wieers.com/
> -- dagit linux solutions, in...@da..., http://dagit.net/
>
> [Any errors in spelling, tact or fact are transmission errors]
>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

[cx-oracle-users] Setting client_identifier upon connect()

[Dag W. <da...@wi...>]

Hi,

I expect this to not be possible. I am in the situation where a tool 
written in perl is allowed to access the database, but a tool using python 
is not (with the same credentials). When adding a symlink from ./perl to 
/usr/bin/python and using that as the shebang does work.

Given the fact that the client_identifier is so easily circumvented I was 
wondering whether it would be possible to modify the client_identifier 
used upon connect() rather than having to resort to such workarounds.

(Yes, I know changing the ACL is probably the best way forward and is in 
fact formally requested, but due to complex corporate processes this may 
take weeks to get executed anyway...)

I know it is possible to modify the client_identifier once connected, but 
it seems useful to also be able to modify the client_identifier upon 
connect, maybe as an argument to connect().

If it is not currently possible, could it be implemented in cx_Oracle ?

Kind regards,
-- 
-- dag wieers, da...@wi..., http://dag.wieers.com/
-- dagit linux solutions, in...@da..., http://dagit.net/

[Any errors in spelling, tact or fact are transmission errors]

Re: [cx-oracle-users] Issues installing and running

[Jessica C. <Jes...@fo...>]

Never mind. I tried again and it worked. Not sure what I did. 


>>> "Jessica Clarke" <Jes...@fo...> 21/08/2012 2:44 PM >>>
I have downloaded the source code as I couldn't get it to work with the Installer either. 
When running my script I get this error: 
 
Traceback (most recent call last):
   File  "file.py", line 9, in <module>
  conn = cx_oracle.connect(dbconnect_string)
NameError: global name 'cx_Oracle' is not defined
 
 
I tried to install the cx_oracle as suggested, but this happened:
 
>python setup.py build
running build
running build_ext
building 'cx_Oracle' extension
error: Unable to find vcvarsall.bat
 
Can someone please assist me. I'm running XP, oracle 10, and Python 2.7, 
I'm not really a whiz with binaries/source/and console work... 
 
Cheers, 
Jess
 

 ( http://twitter.com/forestrytasmania )  ( http://www.youtube.com/user/forestrytas?feature=results_main )
Forestry creates regional employment:
http://youtu.be/UBIUGiCiX00
Growing tomorrow's high conservation value forests:
http://www.youtube.com/watch?v=wP6XCailI-A 
---------------------------------------------------------------
Forestry creates regional employment:
 http://youtu.be/UBIUGiCiX00
Growing tomorrow's high conservation value forests:
 http://www.youtube.com/watch?v=wP6XCailI-A

[cx-oracle-users] Issues installing and running

[Jessica C. <Jes...@fo...>]

I have downloaded the source code as I couldn't get it to work with the Installer either. 
When running my script I get this error: 
 
Traceback (most recent call last):
   File  "file.py", line 9, in <module>
  conn = cx_oracle.connect(dbconnect_string)
NameError: global name 'cx_Oracle' is not defined
 
 
I tried to install the cx_oracle as suggested, but this happened:
 
>python setup.py build
running build
running build_ext
building 'cx_Oracle' extension
error: Unable to find vcvarsall.bat
 
Can someone please assist me. I'm running XP, oracle 10, and Python 2.7, 
I'm not really a whiz with binaries/source/and console work... 
 
Cheers, 
Jess
 

---------------------------------------------------------------
Forestry creates regional employment:
 http://youtu.be/UBIUGiCiX00
Growing tomorrow's high conservation value forests:
 http://www.youtube.com/watch?v=wP6XCailI-A

[cx-oracle-users] Any support on role:SYSASM available for cx_Oracle

[Suse S. <sin...@gm...>]

Hi Guru,

   I want to get help is there any existing support for role:SYSASM ?

   yes cx_Oracle can be used to connect Database, but I wonder any solution
to connect SYSASM job, any documents or best practice you've been processed?

   or if any other similar python solutions which can handle SYSASM is
welcome

-- 
Regards,
-suse

Re: [cx-oracle-users] Accented character coming as "?" in select query output

[johnny j. <joh...@gm...>]

Hi Anthony,

Let me try with the global profile setting.

Great Thanks,

Johnny

On Thu, Aug 9, 2012 at 9:16 PM, Anthony Tuininga <ant...@gm...
> wrote:

> Hi Johnny,
>
> Unfortunately no assumptions can be made about the best encoding and
> that needs to be set up by whoever is using the Oracle client.
> Fortunately you can set the environment variable in your profile or
> the global profile and never have to worry about it again. Glad you
> got things figured out.
>
> Anthony
>
> On Thu, Aug 9, 2012 at 3:26 PM, johnny jebaraj
> <joh...@gm...> wrote:
> > Hi Anthony,
> >
> > After setting the encoding from the code, it started returning characters
> > correctly.
> >
> > Line to add before making oracle connection from python code:
> >
> > os.environ["NLS_LANG"] = ".UTF8"
> >
> > Is there a way to set this as default for cx_Oracle module rather than
> > setting it in the code?
> >
> > Great Thanks,
> >
> > Johnny
> >
> >
> >
> >
> > On Thu, Aug 9, 2012 at 3:56 PM, Anthony Tuininga
> > <ant...@gm...> wrote:
> >>
> >> Hi Johnny,
> >>
> >> You need to make sure you are setting your NLS_LANG environment
> >> variable correctly. If it is set to a character set that does not
> >> support the characters you are trying to retrieve you will get
> >> question marks. You can try querying through SQL*Plus first and
> >> getting things working there. Once they are working there you should
> >> be fine with cx_Oracle as well. There are other options available but
> >> they are far more complicated and you need a good understanding of
> >> character sets, encodings and the like. I would try setting NLS_LANG
> >> first. :-)
> >>
> >> Anthony
> >>
> >> On Thu, Aug 9, 2012 at 12:23 PM, johnny jebaraj
> >> <joh...@gm...> wrote:
> >> > Hi All,
> >> >
> >> > I am new to Oracle as well as to cx_Oracle forum.
> >> >
> >> > Recently I installed cx_Oracle module in my Red Hat linux machine and
> >> > tried
> >> > to do some DB fetch[select] from oracle.
> >> >
> >> > Looks like the accented character from my Oracle table is being
> >> > retrieved as
> >> > ? symbol (or) replaced to another character, not sure what was the
> >> > problem.
> >> >
> >> > Example:
> >> >
> >> > In DB                            --> output from python program
> >> >
> >> > Caché                           --> Cache
> >> > Permian–Triassic           --> Permian?Triassic
> >> >
> >> > Did anyone faced this problem while using this module?
> >> >
> >> > I am using cx_Oracle-5.1.2 and Oracle 11g Database.
> >> >
> >> > Any help to solve this problem is very much appreciated.
> >> >
> >> > Thanks,
> >> >
> >> > Johnny
> >> >
> >> >
> >> >
> ------------------------------------------------------------------------------
> >> > Live Security Virtual Conference
> >> > Exclusive live event will cover all the ways today's security and
> >> > threat landscape has changed and how IT managers can respond.
> >> > Discussions
> >> > will include endpoint security, mobile security and the latest in
> >> > malware
> >> > threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> >> > _______________________________________________
> >> > cx-oracle-users mailing list
> >> > cx-...@li...
> >> > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
> >> >
> >>
> >>
> >>
> ------------------------------------------------------------------------------
> >> Live Security Virtual Conference
> >> Exclusive live event will cover all the ways today's security and
> >> threat landscape has changed and how IT managers can respond.
> Discussions
> >> will include endpoint security, mobile security and the latest in
> malware
> >> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> >> _______________________________________________
> >> cx-oracle-users mailing list
> >> cx-...@li...
> >> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
> >
> >
> >
> >
> ------------------------------------------------------------------------------
> > Live Security Virtual Conference
> > Exclusive live event will cover all the ways today's security and
> > threat landscape has changed and how IT managers can respond. Discussions
> > will include endpoint security, mobile security and the latest in malware
> > threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> > _______________________________________________
> > cx-oracle-users mailing list
> > cx-...@li...
> > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
> >
>
>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>

Re: [cx-oracle-users] Accented character coming as "?" in select query output

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

Hi Johnny,

Unfortunately no assumptions can be made about the best encoding and
that needs to be set up by whoever is using the Oracle client.
Fortunately you can set the environment variable in your profile or
the global profile and never have to worry about it again. Glad you
got things figured out.

Anthony

On Thu, Aug 9, 2012 at 3:26 PM, johnny jebaraj
<joh...@gm...> wrote:
> Hi Anthony,
>
> After setting the encoding from the code, it started returning characters
> correctly.
>
> Line to add before making oracle connection from python code:
>
> os.environ["NLS_LANG"] = ".UTF8"
>
> Is there a way to set this as default for cx_Oracle module rather than
> setting it in the code?
>
> Great Thanks,
>
> Johnny
>
>
>
>
> On Thu, Aug 9, 2012 at 3:56 PM, Anthony Tuininga
> <ant...@gm...> wrote:
>>
>> Hi Johnny,
>>
>> You need to make sure you are setting your NLS_LANG environment
>> variable correctly. If it is set to a character set that does not
>> support the characters you are trying to retrieve you will get
>> question marks. You can try querying through SQL*Plus first and
>> getting things working there. Once they are working there you should
>> be fine with cx_Oracle as well. There are other options available but
>> they are far more complicated and you need a good understanding of
>> character sets, encodings and the like. I would try setting NLS_LANG
>> first. :-)
>>
>> Anthony
>>
>> On Thu, Aug 9, 2012 at 12:23 PM, johnny jebaraj
>> <joh...@gm...> wrote:
>> > Hi All,
>> >
>> > I am new to Oracle as well as to cx_Oracle forum.
>> >
>> > Recently I installed cx_Oracle module in my Red Hat linux machine and
>> > tried
>> > to do some DB fetch[select] from oracle.
>> >
>> > Looks like the accented character from my Oracle table is being
>> > retrieved as
>> > ? symbol (or) replaced to another character, not sure what was the
>> > problem.
>> >
>> > Example:
>> >
>> > In DB                            --> output from python program
>> >
>> > Caché                           --> Cache
>> > Permian–Triassic           --> Permian?Triassic
>> >
>> > Did anyone faced this problem while using this module?
>> >
>> > I am using cx_Oracle-5.1.2 and Oracle 11g Database.
>> >
>> > Any help to solve this problem is very much appreciated.
>> >
>> > Thanks,
>> >
>> > Johnny
>> >
>> >
>> > ------------------------------------------------------------------------------
>> > Live Security Virtual Conference
>> > Exclusive live event will cover all the ways today's security and
>> > threat landscape has changed and how IT managers can respond.
>> > Discussions
>> > will include endpoint security, mobile security and the latest in
>> > malware
>> > threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
>> > _______________________________________________
>> > cx-oracle-users mailing list
>> > cx-...@li...
>> > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>> >
>>
>>
>> ------------------------------------------------------------------------------
>> Live Security Virtual Conference
>> Exclusive live event will cover all the ways today's security and
>> threat landscape has changed and how IT managers can respond. Discussions
>> will include endpoint security, mobile security and the latest in malware
>> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
>> _______________________________________________
>> cx-oracle-users mailing list
>> cx-...@li...
>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>
>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>

Re: [cx-oracle-users] Accented character coming as "?" in select query output

[johnny j. <joh...@gm...>]

Hi Anthony,

After setting the encoding from the code, it started returning characters
correctly.

*Line to add before making oracle connection from python code:*

os.environ["NLS_LANG"] = ".UTF8"

Is there a way to set this as default for cx_Oracle module rather than
setting it in the code?

Great Thanks,

Johnny



On Thu, Aug 9, 2012 at 3:56 PM, Anthony Tuininga <ant...@gm...
> wrote:

> Hi Johnny,
>
> You need to make sure you are setting your NLS_LANG environment
> variable correctly. If it is set to a character set that does not
> support the characters you are trying to retrieve you will get
> question marks. You can try querying through SQL*Plus first and
> getting things working there. Once they are working there you should
> be fine with cx_Oracle as well. There are other options available but
> they are far more complicated and you need a good understanding of
> character sets, encodings and the like. I would try setting NLS_LANG
> first. :-)
>
> Anthony
>
> On Thu, Aug 9, 2012 at 12:23 PM, johnny jebaraj
> <joh...@gm...> wrote:
> > Hi All,
> >
> > I am new to Oracle as well as to cx_Oracle forum.
> >
> > Recently I installed cx_Oracle module in my Red Hat linux machine and
> tried
> > to do some DB fetch[select] from oracle.
> >
> > Looks like the accented character from my Oracle table is being
> retrieved as
> > ? symbol (or) replaced to another character, not sure what was the
> problem.
> >
> > Example:
> >
> > In DB                            --> output from python program
> >
> > Caché                           --> Cache
> > Permian–Triassic           --> Permian?Triassic
> >
> > Did anyone faced this problem while using this module?
> >
> > I am using cx_Oracle-5.1.2 and Oracle 11g Database.
> >
> > Any help to solve this problem is very much appreciated.
> >
> > Thanks,
> >
> > Johnny
> >
> >
> ------------------------------------------------------------------------------
> > Live Security Virtual Conference
> > Exclusive live event will cover all the ways today's security and
> > threat landscape has changed and how IT managers can respond. Discussions
> > will include endpoint security, mobile security and the latest in malware
> > threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> > _______________________________________________
> > cx-oracle-users mailing list
> > cx-...@li...
> > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
> >
>
>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>

Re: [cx-oracle-users] Accented character coming as "?" in select query output

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

Hi Johnny,

You need to make sure you are setting your NLS_LANG environment
variable correctly. If it is set to a character set that does not
support the characters you are trying to retrieve you will get
question marks. You can try querying through SQL*Plus first and
getting things working there. Once they are working there you should
be fine with cx_Oracle as well. There are other options available but
they are far more complicated and you need a good understanding of
character sets, encodings and the like. I would try setting NLS_LANG
first. :-)

Anthony

On Thu, Aug 9, 2012 at 12:23 PM, johnny jebaraj
<joh...@gm...> wrote:
> Hi All,
>
> I am new to Oracle as well as to cx_Oracle forum.
>
> Recently I installed cx_Oracle module in my Red Hat linux machine and tried
> to do some DB fetch[select] from oracle.
>
> Looks like the accented character from my Oracle table is being retrieved as
> ? symbol (or) replaced to another character, not sure what was the problem.
>
> Example:
>
> In DB                            --> output from python program
>
> Caché                           --> Cache
> Permian–Triassic           --> Permian?Triassic
>
> Did anyone faced this problem while using this module?
>
> I am using cx_Oracle-5.1.2 and Oracle 11g Database.
>
> Any help to solve this problem is very much appreciated.
>
> Thanks,
>
> Johnny
>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>

[cx-oracle-users] Accented character coming as "?" in select query output

[johnny j. <joh...@gm...>]

Hi All,

I am new to Oracle as well as to cx_Oracle forum.

Recently I installed cx_Oracle module in my Red Hat linux machine and tried
to do some DB fetch[select] from oracle.

Looks like the accented character from my Oracle table is being retrieved
as ? symbol (or) replaced to another character, not sure what was the
problem.

*Example:*

In DB                            --> output from python program

Caché                           --> Cache
Permian–Triassic           --> Permian?Triassic

Did anyone faced this problem while using this module?

I am using cx_Oracle-5.1.2 and Oracle 11g Database.

Any help to solve this problem is very much appreciated.

Thanks,

Johnny

[cx-oracle-users] AUTO: OOO.... (returning 07/30/2012)

[Brij M P. <brp...@in...>]

I am out of the office until 07/30/2012.

Please contact abd...@lo.../atu...@lo... for any issues.

I will respond to your message when I return. Please contact
es...@ca....
DSS Escalations:
jg...@in...
sal...@in...


Note: This is an automated response to your message  "cx-oracle-users
Digest, Vol 72, Issue 5" sent on 26/07/2012 23:07:23.

This is the only notification you will receive while this person is away.

Re: [cx-oracle-users] retrieving a single record from a stored function

[Brannon, T. M <ter...@jp...>]

Just a bit of feedback. I did manage to get this working by explicit programming, but would prefer .callfunc() if possible:

curs.execute('SELECT * FROM TABLE(get_status(5624966))')
result = curs.fetchone()

From: Brannon, Terrence M
Sent: Thursday, July 26, 2012 1:20 PM
To: 'cx-...@li...'
Subject: retrieving a single record from a stored function

Hello,

I have a stored function which returns a record with 2 columns. One column is a string and the other is a number.

I have successfully called stored functions which only return a number, but don't know the proper calling convention for Cursor.callfunc() when the returnType is a record. The docs make a statement that the notation is the same as for setinputsizes(). Naively, since the first argument to setinputsizes is *args, you could just list all the record args inline:

        result = curs.callfunc('our_stored_func_returning_a_record_of_2_args', cx.STRING, cx.NUMBER, [self.our.id])

But this failed with the message """function takes at most 3 arguments (4 given"""

So then I tried

        result = curs.callfunc('our_stored_func_returning_a_record_of_2_args', [cx.STRING, cx.NUMBER], [self.our.id])

But that fails with the error """number of elements must be an integer"""





This communication is for informational purposes only. It is not
intended as an offer or solicitation for the purchase or sale of
any financial instrument or as an official confirmation of any
transaction. All market prices, data and other information are not
warranted as to completeness or accuracy and are subject to change
without notice. Any comments or statements made herein do not
necessarily reflect those of JPMorgan Chase & Co., its subsidiaries
and affiliates.

This transmission may contain information that is privileged,
confidential, legally privileged, and/or exempt from disclosure
under applicable law. If you are not the intended recipient, you
are hereby notified that any disclosure, copying, distribution, or
use of the information contained herein (including any reliance
thereon) is STRICTLY PROHIBITED. Although this transmission and any
attachments are believed to be free of any virus or other defect
that might affect any computer system into which it is received and
opened, it is the responsibility of the recipient to ensure that it
is virus free and no responsibility is accepted by JPMorgan Chase &
Co., its subsidiaries and affiliates, as applicable, for any loss
or damage arising in any way from its use. If you received this
transmission in error, please immediately contact the sender and
destroy the material in its entirety, whether in electronic or hard
copy format. Thank you.

Please refer to http://www.jpmorgan.com/pages/disclosures for
disclosures relating to European legal entities.

[cx-oracle-users] retrieving a single record from a stored function

[Brannon, T. M <ter...@jp...>]

Hello,

I have a stored function which returns a record with 2 columns. One column is a string and the other is a number.

I have successfully called stored functions which only return a number, but don't know the proper calling convention for Cursor.callfunc() when the returnType is a record. The docs make a statement that the notation is the same as for setinputsizes(). Naively, since the first argument to setinputsizes is *args, you could just list all the record args inline:

        result = curs.callfunc('our_stored_func_returning_a_record_of_2_args', cx.STRING, cx.NUMBER, [self.our.id])

But this failed with the message """function takes at most 3 arguments (4 given"""

So then I tried

        result = curs.callfunc('our_stored_func_returning_a_record_of_2_args', [cx.STRING, cx.NUMBER], [self.our.id])

But that fails with the error """number of elements must be an integer"""





This communication is for informational purposes only. It is not
intended as an offer or solicitation for the purchase or sale of
any financial instrument or as an official confirmation of any
transaction. All market prices, data and other information are not
warranted as to completeness or accuracy and are subject to change
without notice. Any comments or statements made herein do not
necessarily reflect those of JPMorgan Chase & Co., its subsidiaries
and affiliates.

This transmission may contain information that is privileged,
confidential, legally privileged, and/or exempt from disclosure
under applicable law. If you are not the intended recipient, you
are hereby notified that any disclosure, copying, distribution, or
use of the information contained herein (including any reliance
thereon) is STRICTLY PROHIBITED. Although this transmission and any
attachments are believed to be free of any virus or other defect
that might affect any computer system into which it is received and
opened, it is the responsibility of the recipient to ensure that it
is virus free and no responsibility is accepted by JPMorgan Chase &
Co., its subsidiaries and affiliates, as applicable, for any loss
or damage arising in any way from its use. If you received this
transmission in error, please immediately contact the sender and
destroy the material in its entirety, whether in electronic or hard
copy format. Thank you.

Please refer to http://www.jpmorgan.com/pages/disclosures for
disclosures relating to European legal entities.

Re: [cx-oracle-users] cx_Oracle 5.1.2

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

On 07.07.12 05:30, Anthony Tuininga wrote:

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

What about client_identifier?

Servus,
    Walter

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

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

You're welcome. Glad to hear things are working for you.

Anthony

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

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

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

Hi Anthony,

	I appreciate the quick response.  I downloaded the newest msi and uninstalled and reinstalled and the cx_Oracle.pyd file is now there and importable.

Thanks,
Joe

On Jul 13, 2012, at 11:45 AM, Anthony Tuininga wrote:

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