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

Re: [cx-oracle-users] ORA-01000: maximum open cursors exceeded error

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

Hi,

I don't have access to an AIX box to see if this problem is specific
to that platform....but I do use Django on Windows and Linux and do
not run into any problems. Can you show me why you believe that the
open cursor count is unchanged when calling cursor.close()? If you put
such checking code in your script I can run it on the platforms I have
access to and see if we get different results. Thanks.

Anthony

On Tue, Feb 8, 2011 at 9:22 AM, Vikrant Angia <vik...@gm...> wrote:
> Hi,
> I am currently using Python 2.7.1 on AIX 6.1 with cx_Oracle 5.0.4 and notice
> that cursor.close() is NOT decrementing the open cursor count in Oracle.
> The open cursor count is only decremented when the connection itself if
> closed.
> The connection object is created internally by the django framework and
> hence I do not have control over closing it.
> There are other applications running on the same AIX box against the same
> Oracle version and they seem to be working fine - no open cursor leaks.
> Can somebody point me in the right direction?
> The versions of the software used is shown below :
> AIX VERSION
> $ oslevel -r
> 6100-01
> $ uname -a
> AIX camanht1 1 6 00C70D354C00
>
> ORACLE VERSION
> SQL*Plus: Release 11.1.0.6.0 - Production on Tue Feb 8 06:43:25 2011
> Copyright (c) 1982, 2007, Oracle.  All rights reserved.
>
> Connected to:
> Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
> With the Partitioning, OLAP, Data Mining and Real Application Testing
> options
> PYTHON AND CX_ORACLE VERSION
> $ ./python
> Python 2.7.1 (r271:86832, Feb  7 2011, 06:50:53)
> [GCC 4.2.4] on aix6
> Type "help", "copyright", "credits" or "license" for more information.
>>>> import cx_Oracle
>>>> cx_Oracle.version
> '5.0.4'
> COMMANDS TO REPRODUCE
>>>> connection=cx_Oracle.connect("VANGIA/logfire%5678@CADEVMNH")
>>>> cur=connection.cursor()
>>>> cur.execute("select sysdate from dual")    #### Number of open cursors
>>>> is incremented
> <__builtin__.OracleCursor on <cx_Oracle.Connection to VANGIA@CADEVMNH>>
>>>> res=cur.fetchone()
>>>> res[0]
> datetime.datetime(2011, 2, 8, 6, 55, 38)
>>>> cur.close()   #### Number of open cursors is NOT decremented
>>>> del cur       #### Number of open cursors is NOT decremented
>>>> del connection   #### Opened cursors are released at this point
>
>
> Thanks,
> Vikrant Angia
> ------------------------------------------------------------------------------
> The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
> Pinpoint memory and threading errors before they happen.
> Find and fix more than 250 security defects in the development cycle.
> Locate bottlenecks in serial and parallel code that limit performance.
> http://p.sf.net/sfu/intel-dev2devfeb
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>

[cx-oracle-users] ORA-01000: maximum open cursors exceeded error

[Vikrant A. <vik...@gm...>]

Hi,

I am currently using Python 2.7.1 on AIX 6.1 with cx_Oracle 5.0.4 and notice
that cursor.close() is NOT decrementing the open cursor count in Oracle.
The open cursor count is only decremented when the connection itself if
closed.
The connection object is created internally by the django framework and
hence I do not have control over closing it.
There are other applications running on the same AIX box against the same
Oracle version and they seem to be working fine - no open cursor leaks.

Can somebody point me in the right direction?

The versions of the software used is shown below :

AIX VERSION
$ oslevel -r
6100-01
$ uname -a
AIX camanht1 1 6 00C70D354C00


ORACLE VERSION
SQL*Plus: Release 11.1.0.6.0 - Production on Tue Feb 8 06:43:25 2011

Copyright (c) 1982, 2007, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing
options

PYTHON AND CX_ORACLE VERSION
$ ./python
Python 2.7.1 (r271:86832, Feb  7 2011, 06:50:53)
[GCC 4.2.4] on aix6
Type "help", "copyright", "credits" or "license" for more information.
>>> import cx_Oracle
>>> cx_Oracle.version
'5.0.4'

COMMANDS TO REPRODUCE
>>> connection=cx_Oracle.connect("VANGIA/logfire%5678@CADEVMNH")
>>> cur=connection.cursor()
>>> cur.execute("select sysdate from dual")    #### Number of open cursors
is incremented
<__builtin__.OracleCursor on <cx_Oracle.Connection to VANGIA@CADEVMNH>>
>>> res=cur.fetchone()
>>> res[0]
datetime.datetime(2011, 2, 8, 6, 55, 38)
>>> cur.close()   #### Number of open cursors is NOT decremented
>>> del cur       #### Number of open cursors is NOT decremented
>>> del connection   #### Opened cursors are released at this point



Thanks,
Vikrant Angia

[cx-oracle-users] Cx Oracle Tools

[Roberto B. I. <bet...@ho...>]

Hi People

Can anyone help me to run a script using cx_OracleTools ???

Someone told me to use PatchDB ,  but i dont know how to use it  =( 

I have Python 2.7
Oracle 10g
Windows Server 2003

Help Meeee I really need to finish this.

 		 	   		  

[cx-oracle-users] Problem with Cx_OracleTools

[Roberto B. I. <bet...@ho...>]

Hi people

Im new with Python and Cx_OracleTools.

Where am I supposed to install cx_OracleTools ??? In program Files or in Python27 Folder ???

Can anyone help me how to run a script using PatchDB ???

Pleaseeee


 		 	   		  

Re: [cx-oracle-users] Cx_Oracle Module Problem

[Amaury F. d'A. <ama...@gm...>]

Hi,

2011/2/3 Roberto Badillo Ibarra <bet...@ho...>:
> Can I run a SQL Script Using Cx_Oracle Module ??

Not with cx_Oracle, but cx_OracleTools can run a SQL script.
http://cx-oracletools.sourceforge.net/
See the PatchDB utility.

> Can I run cursos.execute With the data I put here Below ???
>
> truncate table missed_int_day;
> truncate table missed_int_hr;
>
> DECLARE
> ORG_EXTERNAL_ID  VARCHAR2(100) := 'Company';
> B_DATE  NUMBER := '20100322';
> E_DATE  NUMBER := '20110103' ;
>
> BEGIN
> missed_pk.missed_int_day (
> ORG_EXTERNAL_ID, -- IN VARCHAR2,
> B_DATE, -- IN NUMBER, -- '20101101'
> E_DATE-- IN NUMBER  -- '20101201'
> ) ;

This snippet contains 3 statements, to be executed separately:
- two "truncate" statements: pass them to a cursor.execute(),
and don't forget to remove the semicolons at the end.
- one PL/SQL block (a "END;" is probably missing): you can pass a
whole pl/sql block to cursor.execute(), it can look this way:

cursor.execute("""
   DECLARE
       ....
   BEGIN
       ...
   END;
""")

A pl/sql block ends with "END;" (with a semicolon).
The trailing '/' that you see in sqlplus scripts should be removed.

I've never used it, but cx_OracleTools will certainly handle all this.

-- 
Amaury Forgeot d'Arc

[cx-oracle-users] Cx_Oracle Module Problem

[Roberto B. I. <bet...@ho...>]

Hi People

Im new with Cx_Oracle Module and Python, I have a Big Question.

Can I run a SQL Script Using Cx_Oracle Module ??
Can I run cursos.execute With the data I put here Below ???

PLEASE HELP MEEE



truncate table missed_int_day;
truncate table missed_int_hr;

DECLARE
ORG_EXTERNAL_ID  VARCHAR2(100) := 'Company';
B_DATE  NUMBER := '20100322';
E_DATE  NUMBER := '20110103' ;

BEGIN
missed_pk.missed_int_day (
ORG_EXTERNAL_ID, -- IN VARCHAR2,
B_DATE, -- IN NUMBER, -- '20101101'
E_DATE-- IN NUMBER  -- '20101201'
) ;
 		 	   		  

Re: [cx-oracle-users] [help] import cx_Oracle is not a valid win32 application

[树上蹭灰 <cn....@gm...>]

thanks all,
i reinstalled python 2.6.2 32bit and cx_oracle 10g 32bit on win2k3.
import cx_Oracle is no problem.


2011/1/31 W. Craig Trader <cra...@gm...>

> What version of the Oracle 10g drivers are you using?  If you're using the
> 32-bit versions, when everything else is 64-bit, that will cause problems.
> You also need to have the Oracle driver's directory in your system path.
>
> - Craig -
>
> 2011/1/30 树上蹭灰 <cn....@gm...>
>
>> hi guys,
>>
>> win2k3 std.64bit
>> Oracle 10g
>> python 2.6.6 amd64
>> cx_Oracle 5.0.4-10g  amd64
>>
>> >>> import cx_Oracle
>>
>> Traceback (most recent call last):
>>   File "<pyshell#0>", line 1, in <module>
>>     import cx_Oracle
>> ImportError: DLL load failed: %1 is not a valid Win32 application.
>> >>
>>
>>
>>
>> help....
>>
>>
>>
>> --
>> cn.popeye
>>
>>
>> ------------------------------------------------------------------------------
>> Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
>> Finally, a world-class log management solution at an even better
>> price-free!
>> Download using promo code Free_Logger_4_Dev2Dev. Offer expires
>> February 28th, so secure your free ArcSight Logger TODAY!
>> http://p.sf.net/sfu/arcsight-sfd2d
>> _______________________________________________
>> cx-oracle-users mailing list
>> cx-...@li...
>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>>
>>
>
>
> ------------------------------------------------------------------------------
> Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
> Finally, a world-class log management solution at an even better
> price-free!
> Download using promo code Free_Logger_4_Dev2Dev. Offer expires
> February 28th, so secure your free ArcSight Logger TODAY!
> http://p.sf.net/sfu/arcsight-sfd2d
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>


-- 
树上蹭灰

[cx-oracle-users] ImportError DLL load failed %1 is not a valid Win32 application

[Gerrat R. <gri...@co...>]

I can't get the 64bit cx_Oracle for python 2.7 installed
(cx_Oracle-5.0.4-11g-unicode.win-amd64-py2.7.msi).

(or rather, it seems to have installed, but won't import)

 

I am running the 64bit Windows 7, have 64bit python installed, and have
the 64bit oracle client installed.

 

Reviewing some other questions led me to try running "Dependency
Walker", which shows that it can't find "MSVCR90.DLL" or "IESHIMS.DLL".


I'm not sure if this would be the right approach, but I found these
files, and put them in my path, but I get the same python error.

 

But now Dependency walker gives me different errors :

 

Error: At least one module has an unresolved import due to a missing
export function in an implicitly dependent module.

Error: Modules with different CPU types were found.

Warning: At least one module has an unresolved import due to a missing
export function in a delay-load dependent module.

 

I'd appreciate any suggestions. 

Thanks.

Re: [cx-oracle-users] [help] import cx_Oracle is not a valid win32 application

[W. C. T. <cra...@gm...>]

What version of the Oracle 10g drivers are you using?  If you're using the
32-bit versions, when everything else is 64-bit, that will cause problems.
You also need to have the Oracle driver's directory in your system path.

- Craig -

2011/1/30 树上蹭灰 <cn....@gm...>

> hi guys,
>
> win2k3 std.64bit
> Oracle 10g
> python 2.6.6 amd64
> cx_Oracle 5.0.4-10g  amd64
>
> >>> import cx_Oracle
>
> Traceback (most recent call last):
>   File "<pyshell#0>", line 1, in <module>
>     import cx_Oracle
> ImportError: DLL load failed: %1 is not a valid Win32 application.
> >>
>
>
>
> help....
>
>
>
> --
> cn.popeye
>
>
> ------------------------------------------------------------------------------
> Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
> Finally, a world-class log management solution at an even better
> price-free!
> Download using promo code Free_Logger_4_Dev2Dev. Offer expires
> February 28th, so secure your free ArcSight Logger TODAY!
> http://p.sf.net/sfu/arcsight-sfd2d
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>

Re: [cx-oracle-users] [help] import cx_Oracle is not a valid win32 application

[树上蹭灰 <cn....@gm...>]

python 2.6.6 amd64 is 64bit.
cx_Oracle 5.0.4-10g for python2.6 & amd64



2011/1/31 Amaury Forgeot d'Arc <ama...@gm...>

> Hi,
>
> 2011/1/31 树上蹭灰 <cn....@gm...>:
> > hi guys,
> >
> > win2k3 std.64bit
> > Oracle 10g
> > python 2.6.6 amd64
> > cx_Oracle 5.0.4-10g  amd64
> >
> >>>> import cx_Oracle
> >
> > Traceback (most recent call last):
> >   File "<pyshell#0>", line 1, in <module>
> >     import cx_Oracle
> > ImportError: DLL load failed: %1 is not a valid Win32 application.
> >>>
>
> Which version of Python are you using?
> Is it a 32bit version by any chance?
>
> --
> Amaury Forgeot d'Arc
>
>
> ------------------------------------------------------------------------------
> Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
> Finally, a world-class log management solution at an even better
> price-free!
> Download using promo code Free_Logger_4_Dev2Dev. Offer expires
> February 28th, so secure your free ArcSight Logger TODAY!
> http://p.sf.net/sfu/arcsight-sfd2d
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>



-- 
树上蹭灰

Re: [cx-oracle-users] [help] import cx_Oracle is not a valid win32 application

[Amaury F. d'A. <ama...@gm...>]

Hi,

2011/1/31 树上蹭灰 <cn....@gm...>:
> hi guys,
>
> win2k3 std.64bit
> Oracle 10g
> python 2.6.6 amd64
> cx_Oracle 5.0.4-10g  amd64
>
>>>> import cx_Oracle
>
> Traceback (most recent call last):
>   File "<pyshell#0>", line 1, in <module>
>     import cx_Oracle
> ImportError: DLL load failed: %1 is not a valid Win32 application.
>>>

Which version of Python are you using?
Is it a 32bit version by any chance?

-- 
Amaury Forgeot d'Arc

[cx-oracle-users] [help] import cx_Oracle is not a valid win32 application

[树上蹭灰 <cn....@gm...>]

hi guys,

win2k3 std.64bit
Oracle 10g
python 2.6.6 amd64
cx_Oracle 5.0.4-10g  amd64

>>> import cx_Oracle

Traceback (most recent call last):
  File "<pyshell#0>", line 1, in <module>
    import cx_Oracle
ImportError: DLL load failed: %1 is not a valid Win32 application.
>>



help....



-- 
cn.popeye

[cx-oracle-users] SessionPool documentation misleading

[Henning v. B. <hen...@ar...>]

The documentation for cx_Oracle 5.0.4 states:
SessionPool.release(/connection/)

       Release the connection back to the pool. This will be done
       automatically as well if the connection object is garbage collected.

At least with cx_Oracle 5.0.3 (Python 2.6 / win32 / Oracle 10) this is
misleading.

I recently changed a server program using cx_Oracle from using a DIY
dummy-session pool(where acquire always returns a new session and 
release always closes the session) to using the cx_Oracle session pool.

As a part of this change, I replaced every occurence of
     conn = cx_Oracle.connect(...)
     ....
     conn.close()
with
     conn = mysessionpool.acquire()
     ....
     mysessionpool.release(conn)
or mysessionpool.drop(conn) if an cx_Oracle.DatabaseError occured.

Later, I wondered why there were so many sessions in the DB.
And my program hung after a while.
By debugging, I found that mysessionpool.acquire() did not
return when the program hung.

It turned out that in one code location, I forgot to replace 
conn.close() with mysessionpool.release(conn).

After changing this line, the program worked.

The cursor object was only referenced by a local variable,
and thus should have been freed after the function ended, I thought.

But obviously that's not the case.

I guess it's not freed (and thus the DB session persists) because
probably the cursor object is still referenced from the SessionPool 
object(?)

Conclusion:
While the documentation maybe technically correct, it is at least
misleading.
In order for the DB session to be closed, you must call the SessionPool
release method
(or delete the Session as well as the whole SessionPool object).

So be careful when using the SessionPool.

Henning

Re: [cx-oracle-users] Unable to load cx_Oracle in python -- Fixed

[Jim T. <jim...@ls...>]

I was using Oracle 10.1 OCI.dll and this was incompatible with cx_Oracle 
-- I moved to instant client 11 and cx_Oracle for 11g and Python 2.7 and 
it now imports.

I appreciate the help from a member in the group.

On 1/27/2011 10:32 AM, Jim Thompson wrote:
> On a Windows XP box    import cx_Oracle fails.
>
> Profile from Dependency Walker:
>
>
> DllMain(0x1E000000, DLL_PROCESS_ATTACH, 0x0022FD30) in "PYTHON27.DLL"
> returned 1 (0x1).
> Unloaded "SHIMENG.DLL" at address 0x5CB70000.
> LoadLibraryExA("C:\Python27\lib\site-packages\cx_Oracle.pyd",
> 0x00000000, LOAD_WITH_ALTERED_SEARCH_PATH) called from "PYTHON27.DLL" at
> address 0x1E02BE5F.
> Loaded "CX_ORACLE.PYD" at address 0x69E80000.  Successfully hooked module.
> Loaded "OCI.DLL" at address 0x10000000.  Successfully hooked module.
> Unloaded "CX_ORACLE.PYD" at address 0x69E80000.
> Unloaded "OCI.DLL" at address 0x10000000.
> LoadLibraryExA("C:\Python27\lib\site-packages\cx_Oracle.pyd",
> 0x00000000, LOAD_WITH_ALTERED_SEARCH_PATH) returned NULL. Error: The
> specified procedure could not be found (127).
>
>
> On a Win XP machine that works it loads an older version of MSVCR90.dll
> than is loaded on the machine that fails.
>
> This is Python 2.7.1 and the Oracle 10g non unicode version of cx_Oracle.
>

-- 
Jim Thompson

Reply To: ji...@ls...

LSF Development Corp.     Jim Thompson
PO Box 201                6311 Ski Texas Lane	
Martindale, TX  78655     Rosharon, TX 77583

832 423 7428 (mobile - ATT)
775 264 6670 (e-fax)

http://www.lsfdev.com
http://www.SanMarcosRiverRanch.com

Re: [cx-oracle-users] Unable to load cx_Oracle in python

[Amaury F. d'A. <ama...@gm...>]

Hi

2011/1/27 Jim Thompson <jim...@ls...>:
> On a Windows XP box    import cx_Oracle fails.
>
> Profile from Dependency Walker:
>
>
> DllMain(0x1E000000, DLL_PROCESS_ATTACH, 0x0022FD30) in "PYTHON27.DLL"
> returned 1 (0x1).
> Unloaded "SHIMENG.DLL" at address 0x5CB70000.
> LoadLibraryExA("C:\Python27\lib\site-packages\cx_Oracle.pyd",
> 0x00000000, LOAD_WITH_ALTERED_SEARCH_PATH) called from "PYTHON27.DLL" at
> address 0x1E02BE5F.
> Loaded "CX_ORACLE.PYD" at address 0x69E80000.  Successfully hooked module.
> Loaded "OCI.DLL" at address 0x10000000.  Successfully hooked module.
> Unloaded "CX_ORACLE.PYD" at address 0x69E80000.
> Unloaded "OCI.DLL" at address 0x10000000.
> LoadLibraryExA("C:\Python27\lib\site-packages\cx_Oracle.pyd",
> 0x00000000, LOAD_WITH_ALTERED_SEARCH_PATH) returned NULL. Error: The
> specified procedure could not be found (127).
>
>
> On a Win XP machine that works it loads an older version of MSVCR90.dll
> than is loaded on the machine that fails.
>
> This is Python 2.7.1 and the Oracle 10g non unicode version of cx_Oracle.

Which OCI.DLL does it find? Maybe it's from an older Oracle version?

-- 
Amaury Forgeot d'Arc

[cx-oracle-users] Unable to load cx_Oracle in python

[Jim T. <jim...@ls...>]

On a Windows XP box    import cx_Oracle fails.

Profile from Dependency Walker:


DllMain(0x1E000000, DLL_PROCESS_ATTACH, 0x0022FD30) in "PYTHON27.DLL" 
returned 1 (0x1).
Unloaded "SHIMENG.DLL" at address 0x5CB70000.
LoadLibraryExA("C:\Python27\lib\site-packages\cx_Oracle.pyd", 
0x00000000, LOAD_WITH_ALTERED_SEARCH_PATH) called from "PYTHON27.DLL" at 
address 0x1E02BE5F.
Loaded "CX_ORACLE.PYD" at address 0x69E80000.  Successfully hooked module.
Loaded "OCI.DLL" at address 0x10000000.  Successfully hooked module.
Unloaded "CX_ORACLE.PYD" at address 0x69E80000.
Unloaded "OCI.DLL" at address 0x10000000.
LoadLibraryExA("C:\Python27\lib\site-packages\cx_Oracle.pyd", 
0x00000000, LOAD_WITH_ALTERED_SEARCH_PATH) returned NULL. Error: The 
specified procedure could not be found (127).


On a Win XP machine that works it loads an older version of MSVCR90.dll 
than is loaded on the machine that fails.

This is Python 2.7.1 and the Oracle 10g non unicode version of cx_Oracle.

-- 
Jim Thompson

Reply To: ji...@ls...

LSF Development Corp.     Jim Thompson
PO Box 201                6311 Ski Texas Lane	
Martindale, TX  78655     Rosharon, TX 77583

832 423 7428 (mobile - ATT)
775 264 6670 (e-fax)

http://www.lsfdev.com
http://www.SanMarcosRiverRanch.com

Re: [cx-oracle-users] Cx_Oracle - Rounding Problem

[Roberto B. I. <bet...@ho...>]

Hey Paul

Thanks a lot, it works

Best Regars,
Roberto Badillo

> Date: Tue, 18 Jan 2011 20:12:48 +0000
> From: p.f...@gm...
> To: cx-...@li...
> Subject: Re: [cx-oracle-users] Cx_Oracle - Rounding Problem
> 
> On 18 January 2011 19:54, Roberto Badillo Ibarra <bet...@ho...> wrote:
> > Sorry, i forget to tell you that on Python I'm just Printing the Object, So
> > I know that the problem is not on Python.
> 
> There may be no problem at all (other than normal float rounding,
> which I suspect you're not aware of). See
> http://docs.python.org/tutorial/floatingpoint.html
> 
> >python
> Python 2.7 (r27:82525, Jul  4 2010, 09:01:59) [MSC v.1500 32 bit
> (Intel)] on win32
> Type "help", "copyright", "credits" or "license" for more information.
> >>> print 99345999999.9999
> 99346000000.0
> >>>
> 
> You might want to read up on Python's Decimal type
> (http://docs.python.org/library/decimal.html) and its use in cx_Oracle
> (see, for example,
> http://www.oracle.com/technetwork/articles/tuininga-cx-oracle-084866.html).
> 
> Paul.
> 
> ------------------------------------------------------------------------------
> Protect Your Site and Customers from Malware Attacks
> Learn about various malware tactics and how to avoid them. Understand 
> malware threats, the impact they can have on your business, and how you 
> can protect your company and customers by using code signing.
> http://p.sf.net/sfu/oracle-sfdevnl
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
 		 	   		  

Re: [cx-oracle-users] Cx_Oracle - Rounding Problem

[Anurag C. <anu...@gm...>]

This is easily done in Python.

Please use the fetched value in the manner that I have indicate below and
see if it helps your cause.

>>> A=cursor.fetchall()
>>> B=A[0][0]
>>> print B
346000000.0
>>> B.real
345999999.9999

Regards,
Anurag

On Wed, Jan 19, 2011 at 1:22 AM, Roberto Badillo Ibarra <
bet...@ho...> wrote:

>  Hi,
>
> Well , when i have a float number with different numbers from 9 is ok, but
> when i have a number like 99345999999.9999 let me show you my problem
>
> For example, I have a value of 99345999999.9999 in the DB
>
> >>> query="select number from Data"
> >>> cursor.execute(str(query))
> >>> A=cursor.fetchall()
> >>> B=A[0][0]
> >>> print B
> 99346000000.0
>
> I dont know why the object on Python script is rounding my float numbers.
>
> I dont want to print or save in a variable this value=99346000000.0  , I
> want 99345999999.9999
>
> Please Help Me
>
>
> ------------------------------
> From: anu...@gm...
> Date: Wed, 19 Jan 2011 00:06:16 +0530
> Subject: Re: [cx-oracle-users] Cx_Oracle - Rounding Problem
> To: cx-...@li...; bet...@ho...;
> ama...@gm...; jb...@gm...; ant...@gm...
>
>
> cx_Oracle fetches the value as it is in the DB for me.
>
> For example, I have a value of 26.3672 in the DB and it appears as it
> is.......Below is my code snippet.
>
> >>> query="select unit_vol from item"
> >>> cursor.execute(str(query))
> >>> A=cursor.fetchall()
> >>> B=A[0][0]
> >>> print B
> 26.3672
>
> It could be that you are doing some Type Conversion Un-Intentionally in
> your Python Code.
>
> Please post your code snippet along with the value that you have in DB so
> that we can help you further.
>
> Regards,
> Anurag
>
> On Tue, Jan 18, 2011 at 11:53 PM, Roberto Badillo Ibarra <
> bet...@ho...> wrote:
>
>
> Hello,
>
> My name is Roberto, Im new with all the stuff of Cx_Oracle.
>
> I'm working with Python 2.7
> S.O. Windows Server 2003
>
> Well, my problem is that when I'm doing a query to the database i have a
> column with a big float number but when I print my object I  see that my
> numbers are rounded ,  what can I do ?  I need the number with no rounding ,
> please help me
>
> I'm new with this stuff.
>
>
> ------------------------------------------------------------------------------
> Protect Your Site and Customers from Malware Attacks
> Learn about various malware tactics and how to avoid them. Understand
> malware threats, the impact they can have on your business, and how you
> can protect your company and customers by using code signing.
> http://p.sf.net/sfu/oracle-sfdevnl
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>
>

Re: [cx-oracle-users] Cx_Oracle - Rounding Problem

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

On 18 January 2011 19:54, Roberto Badillo Ibarra <bet...@ho...> wrote:
> Sorry, i forget to tell you that on Python I'm just Printing the Object, So
> I know that the problem is not on Python.

There may be no problem at all (other than normal float rounding,
which I suspect you're not aware of). See
http://docs.python.org/tutorial/floatingpoint.html

>python
Python 2.7 (r27:82525, Jul  4 2010, 09:01:59) [MSC v.1500 32 bit
(Intel)] on win32
Type "help", "copyright", "credits" or "license" for more information.
>>> print 99345999999.9999
99346000000.0
>>>

You might want to read up on Python's Decimal type
(http://docs.python.org/library/decimal.html) and its use in cx_Oracle
(see, for example,
http://www.oracle.com/technetwork/articles/tuininga-cx-oracle-084866.html).

Paul.

Re: [cx-oracle-users] Cx_Oracle - Rounding Problem

[Roberto B. I. <bet...@ho...>]

Sorry, i forget to tell you that on Python I'm just Printing the Object, So I know that the problem is not on Python.

From: anu...@gm...
Date: Wed, 19 Jan 2011 00:06:16 +0530
Subject: Re: [cx-oracle-users] Cx_Oracle - Rounding Problem
To: cx-...@li...; bet...@ho...; ama...@gm...; jb...@gm...; ant...@gm...

cx_Oracle fetches the value as it is in the DB for me. 
For example, I have a value of 26.3672 in the DB and it appears as it is.......Below is my code snippet.


>>> query="select unit_vol from item"
>>> cursor.execute(str(query))>>> A=cursor.fetchall()>>> B=A[0][0]>>> print B26.3672
It could be that you are doing some Type Conversion Un-Intentionally in your Python Code. 



Please post your code snippet along with the value that you have in DB so that we can help you further.
Regards,Anurag

On Tue, Jan 18, 2011 at 11:53 PM, Roberto Badillo Ibarra <bet...@ho...> wrote:









Hello,

My name is Roberto, Im new with all the stuff of Cx_Oracle.

I'm working with Python 2.7
S.O. Windows Server 2003

Well, my problem is that when I'm doing a query to the database i have a column with a big float number but when I print my object I  see that my numbers are rounded ,  what can I do ?  I need the number with no rounding , please help me




I'm new with this stuff.
 		 	   		  

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

Protect Your Site and Customers from Malware Attacks

Learn about various malware tactics and how to avoid them. Understand

malware threats, the impact they can have on your business, and how you

can protect your company and customers by using code signing.

http://p.sf.net/sfu/oracle-sfdevnl
_______________________________________________

cx-oracle-users mailing list

cx-...@li...

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



 		 	   		  

Re: [cx-oracle-users] Cx_Oracle - Rounding Problem

[Roberto B. I. <bet...@ho...>]

Hi,

Well , when i have a float number with different numbers from 9 is ok, but when i have a number like 99345999999.9999 let me show you my problem



For example, I have a value of 99345999999.9999 in the DB

>>> query="select number from Data"
>>> cursor.execute(str(query))>>> A=cursor.fetchall()>>> B=A[0][0]>>> print B
99346000000.0

I dont know why the object on Python script is rounding my float numbers.

I dont want to print or save in a variable this value=99346000000.0  , I want 99345999999.9999

Please Help Me


From: anu...@gm...
Date: Wed, 19 Jan 2011 00:06:16 +0530
Subject: Re: [cx-oracle-users] Cx_Oracle - Rounding Problem
To: cx-...@li...; bet...@ho...; ama...@gm...; jb...@gm...; ant...@gm...

cx_Oracle fetches the value as it is in the DB for me. 
For example, I have a value of 26.3672 in the DB and it appears as it is.......Below is my code snippet.


>>> query="select unit_vol from item"
>>> cursor.execute(str(query))>>> A=cursor.fetchall()>>> B=A[0][0]>>> print B26.3672
It could be that you are doing some Type Conversion Un-Intentionally in your Python Code. 



Please post your code snippet along with the value that you have in DB so that we can help you further.
Regards,Anurag

On Tue, Jan 18, 2011 at 11:53 PM, Roberto Badillo Ibarra <bet...@ho...> wrote:









Hello,

My name is Roberto, Im new with all the stuff of Cx_Oracle.

I'm working with Python 2.7
S.O. Windows Server 2003

Well, my problem is that when I'm doing a query to the database i have a column with a big float number but when I print my object I  see that my numbers are rounded ,  what can I do ?  I need the number with no rounding , please help me




I'm new with this stuff.
 		 	   		  

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

Protect Your Site and Customers from Malware Attacks

Learn about various malware tactics and how to avoid them. Understand

malware threats, the impact they can have on your business, and how you

can protect your company and customers by using code signing.

http://p.sf.net/sfu/oracle-sfdevnl
_______________________________________________

cx-oracle-users mailing list

cx-...@li...

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



 		 	   		  

Re: [cx-oracle-users] Cx_Oracle - Rounding Problem

[Anurag C. <anu...@gm...>]

cx_Oracle fetches the value as it is in the DB for me.

For example, I have a value of 26.3672 in the DB and it appears as it
is.......Below is my code snippet.

>>> query="select unit_vol from item"
>>> cursor.execute(str(query))
>>> A=cursor.fetchall()
>>> B=A[0][0]
>>> print B
26.3672

It could be that you are doing some Type Conversion Un-Intentionally in your
Python Code.

Please post your code snippet along with the value that you have in DB so
that we can help you further.

Regards,
Anurag

On Tue, Jan 18, 2011 at 11:53 PM, Roberto Badillo Ibarra <
bet...@ho...> wrote:

>
> Hello,
>
> My name is Roberto, Im new with all the stuff of Cx_Oracle.
>
> I'm working with Python 2.7
> S.O. Windows Server 2003
>
> Well, my problem is that when I'm doing a query to the database i have a
> column with a big float number but when I print my object I  see that my
> numbers are rounded ,  what can I do ?  I need the number with no rounding ,
> please help me
>
> I'm new with this stuff.
>
>
> ------------------------------------------------------------------------------
> Protect Your Site and Customers from Malware Attacks
> Learn about various malware tactics and how to avoid them. Understand
> malware threats, the impact they can have on your business, and how you
> can protect your company and customers by using code signing.
> http://p.sf.net/sfu/oracle-sfdevnl
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>

[cx-oracle-users] Cx_Oracle - Rounding Problem

[Roberto B. I. <bet...@ho...>]

Hello,

My name is Roberto, Im new with all the stuff of Cx_Oracle.

I'm working with Python 2.7
S.O. Windows Server 2003

Well, my problem is that when I'm doing a query to the database i have a column with a big float number but when I print my object I  see that my numbers are rounded ,  what can I do ?  I need the number with no rounding , please help me

I'm new with this stuff.
 		 	   		  

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

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

Hi all,

According to your recommendations I have changed the source:

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

tmp_ex = 0

try:
    con = cx_Oracle.connect('...')
    cs = con.cursor()
    cs.execute ("select 1 from dual")
    con.rollback ()
    con.close()
    STATUS = "UP"
except cx_Oracle.Error as ex:
    tmp_ex = ex
    STATUS = "DOWN"

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

Now I have:
...
2011-01-18 01:13:01 UP 0
2011-01-18 01:14:02 UP 0
2011-01-18 01:15:01 DOWN ORA-12541: TNS:no listener

2011-01-18 01:16:01 DOWN ORA-12541: TNS:no listener

2011-01-18 01:17:01 DOWN ORA-12541: TNS:no listener

2011-01-18 01:18:02 DOWN ORA-12541: TNS:no listener

2011-01-18 01:19:01 DOWN ORA-12541: TNS:no listener

2011-01-18 01:20:01 DOWN ORA-12541: TNS:no listener

2011-01-18 01:21:04 DOWN ORA-12543: TNS:destination host unreachable

2011-01-18 01:22:05 DOWN ORA-12543: TNS:destination host unreachable

2011-01-18 01:23:04 DOWN ORA-12543: TNS:destination host unreachable

2011-01-18 01:24:04 DOWN ORA-12543: TNS:destination host unreachable

2011-01-18 01:25:04 DOWN ORA-12543: TNS:destination host unreachable

2011-01-18 01:26:01 DOWN ORA-12541: TNS:no listener

2011-01-18 01:27:01 DOWN ORA-12541: TNS:no listener

2011-01-18 01:28:01 DOWN ORA-12541: TNS:no listener

2011-01-18 01:29:02 UP 0
2011-01-18 01:30:02 UP 0
...

It seems to work.
Thank you :-)


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





























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

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

[Massa, H. A. <ch...@gh...>]

in extension to you Paul's code, I recommend to fire up a dummy-query to
make sure the database is alive and kicking and really listening, as in

>
> try:
>   con = cx_Oracle.connect('xxx/yyy@zzz')
>
      cs = con.cursor()
      cs.execute ("select 1 from dual")
      cn.rollback()

>   STATUS= "UP"
>




-- 
GHUM GmbH
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607

Amtsgericht Stuttgart, HRB 734971
-
persuadere.
et programmare