cx-oracle-users Mailing List for cx_Oracle (Page 2)
Brought to you by:
atuining
Menu
▾
▴
cx-oracle-users — Primary discussion list for users (and developers) of cx_Oracle
You can subscribe to this list here.
| 2003 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
(5) |
Aug
(9) |
Sep
(8) |
Oct
(12) |
Nov
(4) |
Dec
(8) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2004 |
Jan
(15) |
Feb
(12) |
Mar
(11) |
Apr
(5) |
May
(7) |
Jun
(8) |
Jul
(12) |
Aug
(2) |
Sep
(14) |
Oct
(17) |
Nov
(20) |
Dec
(3) |
| 2005 |
Jan
(16) |
Feb
(9) |
Mar
(22) |
Apr
(21) |
May
(73) |
Jun
(16) |
Jul
(15) |
Aug
(10) |
Sep
(32) |
Oct
(35) |
Nov
(22) |
Dec
(13) |
| 2006 |
Jan
(42) |
Feb
(36) |
Mar
(13) |
Apr
(18) |
May
(8) |
Jun
(17) |
Jul
(24) |
Aug
(30) |
Sep
(35) |
Oct
(33) |
Nov
(33) |
Dec
(11) |
| 2007 |
Jan
(35) |
Feb
(31) |
Mar
(35) |
Apr
(64) |
May
(38) |
Jun
(12) |
Jul
(18) |
Aug
(34) |
Sep
(75) |
Oct
(29) |
Nov
(51) |
Dec
(11) |
| 2008 |
Jan
(27) |
Feb
(46) |
Mar
(48) |
Apr
(36) |
May
(59) |
Jun
(42) |
Jul
(25) |
Aug
(34) |
Sep
(57) |
Oct
(97) |
Nov
(59) |
Dec
(57) |
| 2009 |
Jan
(48) |
Feb
(48) |
Mar
(45) |
Apr
(24) |
May
(46) |
Jun
(52) |
Jul
(52) |
Aug
(37) |
Sep
(27) |
Oct
(40) |
Nov
(37) |
Dec
(13) |
| 2010 |
Jan
(16) |
Feb
(9) |
Mar
(24) |
Apr
(6) |
May
(27) |
Jun
(28) |
Jul
(60) |
Aug
(16) |
Sep
(33) |
Oct
(20) |
Nov
(39) |
Dec
(30) |
| 2011 |
Jan
(23) |
Feb
(43) |
Mar
(16) |
Apr
(29) |
May
(23) |
Jun
(16) |
Jul
(10) |
Aug
(8) |
Sep
(18) |
Oct
(42) |
Nov
(26) |
Dec
(20) |
| 2012 |
Jan
(17) |
Feb
(27) |
Mar
|
Apr
(20) |
May
(18) |
Jun
(7) |
Jul
(24) |
Aug
(21) |
Sep
(23) |
Oct
(18) |
Nov
(12) |
Dec
(5) |
| 2013 |
Jan
(14) |
Feb
(10) |
Mar
(20) |
Apr
(65) |
May
(3) |
Jun
(8) |
Jul
(6) |
Aug
(3) |
Sep
|
Oct
(3) |
Nov
(28) |
Dec
(3) |
| 2014 |
Jan
(3) |
Feb
(9) |
Mar
(4) |
Apr
(7) |
May
(20) |
Jun
(2) |
Jul
(20) |
Aug
(7) |
Sep
(11) |
Oct
(8) |
Nov
(6) |
Dec
(12) |
| 2015 |
Jan
(16) |
Feb
(10) |
Mar
(14) |
Apr
(8) |
May
|
Jun
(8) |
Jul
(15) |
Aug
(7) |
Sep
(1) |
Oct
(33) |
Nov
(8) |
Dec
(5) |
| 2016 |
Jan
(18) |
Feb
(12) |
Mar
(6) |
Apr
(14) |
May
(5) |
Jun
(3) |
Jul
|
Aug
(21) |
Sep
|
Oct
(15) |
Nov
(8) |
Dec
|
| 2017 |
Jan
|
Feb
(14) |
Mar
(21) |
Apr
(9) |
May
(6) |
Jun
(11) |
Jul
(23) |
Aug
(6) |
Sep
(5) |
Oct
(7) |
Nov
(1) |
Dec
(1) |
| 2018 |
Jan
|
Feb
|
Mar
(16) |
Apr
(2) |
May
(1) |
Jun
|
Jul
(2) |
Aug
|
Sep
(2) |
Oct
|
Nov
|
Dec
|
| 2019 |
Jan
(2) |
Feb
(3) |
Mar
(1) |
Apr
(1) |
May
|
Jun
|
Jul
(2) |
Aug
(1) |
Sep
(2) |
Oct
|
Nov
|
Dec
(1) |
| 2020 |
Jan
|
Feb
(4) |
Mar
|
Apr
|
May
(2) |
Jun
(1) |
Jul
(4) |
Aug
|
Sep
(1) |
Oct
|
Nov
|
Dec
(3) |
| 2021 |
Jan
|
Feb
(5) |
Mar
|
Apr
(7) |
May
(6) |
Jun
(1) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(1) |
Dec
|
| 2022 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(1) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2023 |
Jan
|
Feb
(1) |
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Kubo T. <ku...@ji...> - 2020-05-29 14:41:41
|
https://github.com/oracle/python-cx_Oracle/issues/376 |
|
From: Anderson C. T. <and...@op...> - 2020-05-29 03:24:42
|
Hi list,
I’m facing a strength behaviour on a Python project (the first one I’m using cx_Oracle). Scenario:
This python application must access database and get some simple data (query returning two columns and no more than 4 or 5 rows).
After run this query, I must call invoke a shell script from my Python code and I must check the retcode, returned by the shell.
The problem is that subprocess.call() always return 0 (zero) as retcode from shell (even when shell explicitly exit with any other retcode), and this is happening only If a use cx_Oracle.
My environment:
Oracle Linux 7.7
Python 2.7.5
Oracle 11.2.0.4
I could reproduce this problem with a simple test case that I’m sending below.
Please my apologies by any english mistakes.
testenv.py file
# -*- coding: latin-1 -*-
'''
Created on 28 de mai de 2020
'''
from os import environ
from execshell import TestClass
def entrypoint():
environ['ORACLE_HOME'] = '/u01/app/oracle/product/11.2.0.4/dbhome_ee'
environ['ORACLE_SID'] = 'orcl'
x = TestClass()
x.exec_shell()
x.exec_query()
x.exec_shell()
if __name__=='__main__':
entrypoint()
execshell.py file
# -*- coding: latin-1 -*-
'''
Created on 28 de mai de 2020
‘''
import cx_Oracle
from subprocess import call
class TestClass(object):
def __init__(self):
self.rman_configs = None
def exec_shell(self):
print 'TestClass::exec_shell()'
rc = call('/tmp/orcl-callback.sh')
print 'TestClass::exec_shell() -> os.call returned code {} from shell'.format(rc)
def exec_query(self):
conn = None
cur = None
print 'TestClass::exec_query(). Running seelect hello from dual'
try:
conn = cx_Oracle.connect(mode=cx_Oracle.SYSDBA)
cur = conn.cursor()
cur.execute("select 'hello' from dual")
for v in cur:
print v
except cx_Oracle.Error as e1:
raise e1
finally:
if cur:
cur.close()
if conn:
conn.close()
the called shell script (oral-callback.sh):
#!/bin/bash
echo " This is a echo from shell script"
echo " The shell will simulate an error, returning non zero code"
sleep 2
exit 125
|
|
From: John N. <mr....@gm...> - 2020-02-11 02:12:09
|
Triggers and two database links? On Mon, Feb 10, 2020 at 8:03 PM M.M.Rashid (Rubel) <mm...@gm...> wrote: > Hello Community, > > Need suggestion - need to sync two oracle databases/schemas. Any changes > on source DB to be propagated to the target DB (INSERT/UPDATE/DELETE). > Commercial tools out there in the market but is not an option. I was > thinking of using oracle exp/imp and Python to automate. Any suggestion is > appreciated. Source is on-prem and target is hosted on AWS. > > Thanks, > Rubel > > > > On Mon, Feb 10, 2020 at 8:55 PM < > cx-...@li...> wrote: > >> Send cx-oracle-users mailing list submissions to >> cx-...@li... >> >> To subscribe or unsubscribe via the World Wide Web, visit >> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >> or, via email, send a message with subject or body 'help' to >> cx-...@li... >> >> You can reach the person managing the list at >> cx-...@li... >> >> When replying, please edit your Subject line so it is more specific >> than "Re: Contents of cx-oracle-users digest..." >> >> >> Today's Topics: >> >> 1. Re: cx-oracle-users Digest, Vol 142, Issue 1 (M.M.Rashid (Rubel)) >> >> >> ---------------------------------------------------------------------- >> >> Message: 1 >> Date: Mon, 10 Feb 2020 16:25:58 +0800 >> From: "M.M.Rashid (Rubel)" <mm...@gm...> >> To: cx-...@li... >> Subject: Re: [cx-oracle-users] cx-oracle-users Digest, Vol 142, Issue >> 1 >> Message-ID: >> <CABs5CDFw5Z_6f2TpH2vkf8qStv+0AF=f= >> vPc...@ma...> >> Content-Type: text/plain; charset="utf-8" >> >> Dear All, >> >> Looking for some case studies on syncing two oracle databases/schemas >> using >> Python. There are commercial tools out in the market but we prefer to do >> something using cx_Oracle , Python, exp/imp...etc >> >> Thanks in advance >> >> Regards, >> Rashid >> >> On Tue, Dec 3, 2019 at 8:16 PM < >> cx-...@li...> wrote: >> >> > Send cx-oracle-users mailing list submissions to >> > cx-...@li... >> > >> > To subscribe or unsubscribe via the World Wide Web, visit >> > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >> > or, via email, send a message with subject or body 'help' to >> > cx-...@li... >> > >> > You can reach the person managing the list at >> > cx-...@li... >> > >> > When replying, please edit your Subject line so it is more specific >> > than "Re: Contents of cx-oracle-users digest..." >> > >> > >> > Today's Topics: >> > >> > 1. cx_Oracle 7.3 (Anthony Tuininga) >> > >> > >> > ---------------------------------------------------------------------- >> > >> > Message: 1 >> > Date: Mon, 2 Dec 2019 18:09:14 -0700 >> > From: Anthony Tuininga <ant...@gm...> >> > To: cx-...@li..., DB...@py..., >> > pyt...@py... >> > Subject: [cx-oracle-users] cx_Oracle 7.3 >> > Message-ID: >> > < >> > CAE...@ma...> >> > Content-Type: text/plain; charset="utf-8" >> > >> > What is cx_Oracle? >> > >> > cx_Oracle is a Python extension module that enables access to Oracle >> > Database for Python 3.x and 2.x and conforms to the Python database API >> 2.0 >> > specifications with a number of enhancements. >> > >> > >> > Where do I get it? >> > https://oracle.github.io/python-cx_Oracle >> > >> > The easiest method to install/upgrade cx_Oracle is via pip as in >> > >> > python -m pip install cx_Oracle --upgrade >> > >> > >> > What's new? >> > >> > See my colleague's blog post for an overview: >> > >> > >> https://blogs.oracle.com/opal/python-cx_oracle-73-for-oracle-database-is-on-pypi >> > >> > See the full release notes for all of the details: >> > >> > >> https://cx-oracle.readthedocs.io/en/latest/release_notes.html#version-7-3-december-2019 >> > >> > Please provide any feedback via GitHub issues ( >> > https://github.com/oracle/python-cx_Oracle/issues). >> > -------------- next part -------------- >> > An HTML attachment was scrubbed... >> > >> > ------------------------------ >> > >> > >> > >> > ------------------------------ >> > >> > Subject: Digest Footer >> > >> > _______________________________________________ >> > cx-oracle-users mailing list >> > cx-...@li... >> > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >> > >> > >> > ------------------------------ >> > >> > End of cx-oracle-users Digest, Vol 142, Issue 1 >> > *********************************************** >> > >> >> >> -- >> M. M. RASHID(Rubel) >> Perth, Australia. >> E-mail: mm...@gm... >> Phone: +61 406996028 (Mobile) >> -------------- next part -------------- >> An HTML attachment was scrubbed... >> >> ------------------------------ >> >> >> >> ------------------------------ >> >> Subject: Digest Footer >> >> _______________________________________________ >> cx-oracle-users mailing list >> cx-...@li... >> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >> >> >> ------------------------------ >> >> End of cx-oracle-users Digest, Vol 143, Issue 1 >> *********************************************** > > >> > > -- > M. M. RASHID(Rubel) > Perth, Australia. > E-mail: mm...@gm... > Phone: +61 406996028 (Mobile) > _______________________________________________ > cx-oracle-users mailing list > cx-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > -- John A. Nielson (504) 344.7225 |
|
From: M.M.Rashid (Rubel) <mm...@gm...> - 2020-02-11 02:03:11
|
Hello Community, Need suggestion - need to sync two oracle databases/schemas. Any changes on source DB to be propagated to the target DB (INSERT/UPDATE/DELETE). Commercial tools out there in the market but is not an option. I was thinking of using oracle exp/imp and Python to automate. Any suggestion is appreciated. Source is on-prem and target is hosted on AWS. Thanks, Rubel On Mon, Feb 10, 2020 at 8:55 PM < cx-...@li...> wrote: > Send cx-oracle-users mailing list submissions to > cx-...@li... > > To subscribe or unsubscribe via the World Wide Web, visit > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > or, via email, send a message with subject or body 'help' to > cx-...@li... > > You can reach the person managing the list at > cx-...@li... > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of cx-oracle-users digest..." > > > Today's Topics: > > 1. Re: cx-oracle-users Digest, Vol 142, Issue 1 (M.M.Rashid (Rubel)) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Mon, 10 Feb 2020 16:25:58 +0800 > From: "M.M.Rashid (Rubel)" <mm...@gm...> > To: cx-...@li... > Subject: Re: [cx-oracle-users] cx-oracle-users Digest, Vol 142, Issue > 1 > Message-ID: > <CABs5CDFw5Z_6f2TpH2vkf8qStv+0AF=f= > vPc...@ma...> > Content-Type: text/plain; charset="utf-8" > > Dear All, > > Looking for some case studies on syncing two oracle databases/schemas using > Python. There are commercial tools out in the market but we prefer to do > something using cx_Oracle , Python, exp/imp...etc > > Thanks in advance > > Regards, > Rashid > > On Tue, Dec 3, 2019 at 8:16 PM < > cx-...@li...> wrote: > > > Send cx-oracle-users mailing list submissions to > > cx-...@li... > > > > To subscribe or unsubscribe via the World Wide Web, visit > > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > > or, via email, send a message with subject or body 'help' to > > cx-...@li... > > > > You can reach the person managing the list at > > cx-...@li... > > > > When replying, please edit your Subject line so it is more specific > > than "Re: Contents of cx-oracle-users digest..." > > > > > > Today's Topics: > > > > 1. cx_Oracle 7.3 (Anthony Tuininga) > > > > > > ---------------------------------------------------------------------- > > > > Message: 1 > > Date: Mon, 2 Dec 2019 18:09:14 -0700 > > From: Anthony Tuininga <ant...@gm...> > > To: cx-...@li..., DB...@py..., > > pyt...@py... > > Subject: [cx-oracle-users] cx_Oracle 7.3 > > Message-ID: > > < > > CAE...@ma...> > > Content-Type: text/plain; charset="utf-8" > > > > What is cx_Oracle? > > > > cx_Oracle is a Python extension module that enables access to Oracle > > Database for Python 3.x and 2.x and conforms to the Python database API > 2.0 > > specifications with a number of enhancements. > > > > > > Where do I get it? > > https://oracle.github.io/python-cx_Oracle > > > > The easiest method to install/upgrade cx_Oracle is via pip as in > > > > python -m pip install cx_Oracle --upgrade > > > > > > What's new? > > > > See my colleague's blog post for an overview: > > > > > https://blogs.oracle.com/opal/python-cx_oracle-73-for-oracle-database-is-on-pypi > > > > See the full release notes for all of the details: > > > > > https://cx-oracle.readthedocs.io/en/latest/release_notes.html#version-7-3-december-2019 > > > > Please provide any feedback via GitHub issues ( > > https://github.com/oracle/python-cx_Oracle/issues). > > -------------- next part -------------- > > An HTML attachment was scrubbed... > > > > ------------------------------ > > > > > > > > ------------------------------ > > > > Subject: Digest Footer > > > > _______________________________________________ > > cx-oracle-users mailing list > > cx-...@li... > > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > > > > > > ------------------------------ > > > > End of cx-oracle-users Digest, Vol 142, Issue 1 > > *********************************************** > > > > > -- > M. M. RASHID(Rubel) > Perth, Australia. > E-mail: mm...@gm... > Phone: +61 406996028 (Mobile) > -------------- next part -------------- > An HTML attachment was scrubbed... > > ------------------------------ > > > > ------------------------------ > > Subject: Digest Footer > > _______________________________________________ > cx-oracle-users mailing list > cx-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > > > ------------------------------ > > End of cx-oracle-users Digest, Vol 143, Issue 1 > *********************************************** > -- M. M. RASHID(Rubel) Perth, Australia. E-mail: mm...@gm... Phone: +61 406996028 (Mobile) |
|
From: Anthony T. <ant...@gm...> - 2020-02-10 17:51:13
|
Hi Rashid, I don't know exactly what you are looking for, but I wrote a number of tools some time ago to assist with the generation of patch scripts for Oracle Database. ExportObjects was used to generate a set of files containing the objects found within a particular schema or set of schemas. These could be stored in a source control system. GeneratePatch was used to generate the patch scripts I mentioned. You can find these tools here: https://github.com/anthony-tuininga/cx_OracleTools. The tools still work but I haven't done much with them in the past few years. Hopefully they are of some use to you! Anthony On Mon, Feb 10, 2020 at 1:27 AM M.M.Rashid (Rubel) <mm...@gm...> wrote: > Dear All, > > Looking for some case studies on syncing two oracle databases/schemas > using Python. There are commercial tools out in the market but we prefer to > do something using cx_Oracle , Python, exp/imp...etc > > Thanks in advance > > Regards, > Rashid > > On Tue, Dec 3, 2019 at 8:16 PM < > cx-...@li...> wrote: > >> Send cx-oracle-users mailing list submissions to >> cx-...@li... >> >> To subscribe or unsubscribe via the World Wide Web, visit >> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >> or, via email, send a message with subject or body 'help' to >> cx-...@li... >> >> You can reach the person managing the list at >> cx-...@li... >> >> When replying, please edit your Subject line so it is more specific >> than "Re: Contents of cx-oracle-users digest..." >> >> >> Today's Topics: >> >> 1. cx_Oracle 7.3 (Anthony Tuininga) >> >> >> ---------------------------------------------------------------------- >> >> Message: 1 >> Date: Mon, 2 Dec 2019 18:09:14 -0700 >> From: Anthony Tuininga <ant...@gm...> >> To: cx-...@li..., DB...@py..., >> pyt...@py... >> Subject: [cx-oracle-users] cx_Oracle 7.3 >> Message-ID: >> < >> CAE...@ma...> >> Content-Type: text/plain; charset="utf-8" >> >> What is cx_Oracle? >> >> cx_Oracle is a Python extension module that enables access to Oracle >> Database for Python 3.x and 2.x and conforms to the Python database API >> 2.0 >> specifications with a number of enhancements. >> >> >> Where do I get it? >> https://oracle.github.io/python-cx_Oracle >> >> The easiest method to install/upgrade cx_Oracle is via pip as in >> >> python -m pip install cx_Oracle --upgrade >> >> >> What's new? >> >> See my colleague's blog post for an overview: >> >> https://blogs.oracle.com/opal/python-cx_oracle-73-for-oracle-database-is-on-pypi >> >> See the full release notes for all of the details: >> >> https://cx-oracle.readthedocs.io/en/latest/release_notes.html#version-7-3-december-2019 >> >> Please provide any feedback via GitHub issues ( >> https://github.com/oracle/python-cx_Oracle/issues). >> -------------- next part -------------- >> An HTML attachment was scrubbed... >> >> ------------------------------ >> >> >> >> ------------------------------ >> >> Subject: Digest Footer >> >> _______________________________________________ >> cx-oracle-users mailing list >> cx-...@li... >> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >> >> >> ------------------------------ >> >> End of cx-oracle-users Digest, Vol 142, Issue 1 >> *********************************************** >> > > > -- > M. M. RASHID(Rubel) > Perth, Australia. > E-mail: mm...@gm... > Phone: +61 406996028 (Mobile) > _______________________________________________ > cx-oracle-users mailing list > cx-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > |
|
From: M.M.Rashid (Rubel) <mm...@gm...> - 2020-02-10 08:26:42
|
Dear All, Looking for some case studies on syncing two oracle databases/schemas using Python. There are commercial tools out in the market but we prefer to do something using cx_Oracle , Python, exp/imp...etc Thanks in advance Regards, Rashid On Tue, Dec 3, 2019 at 8:16 PM < cx-...@li...> wrote: > Send cx-oracle-users mailing list submissions to > cx-...@li... > > To subscribe or unsubscribe via the World Wide Web, visit > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > or, via email, send a message with subject or body 'help' to > cx-...@li... > > You can reach the person managing the list at > cx-...@li... > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of cx-oracle-users digest..." > > > Today's Topics: > > 1. cx_Oracle 7.3 (Anthony Tuininga) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Mon, 2 Dec 2019 18:09:14 -0700 > From: Anthony Tuininga <ant...@gm...> > To: cx-...@li..., DB...@py..., > pyt...@py... > Subject: [cx-oracle-users] cx_Oracle 7.3 > Message-ID: > < > CAE...@ma...> > Content-Type: text/plain; charset="utf-8" > > What is cx_Oracle? > > cx_Oracle is a Python extension module that enables access to Oracle > Database for Python 3.x and 2.x and conforms to the Python database API 2.0 > specifications with a number of enhancements. > > > Where do I get it? > https://oracle.github.io/python-cx_Oracle > > The easiest method to install/upgrade cx_Oracle is via pip as in > > python -m pip install cx_Oracle --upgrade > > > What's new? > > See my colleague's blog post for an overview: > > https://blogs.oracle.com/opal/python-cx_oracle-73-for-oracle-database-is-on-pypi > > See the full release notes for all of the details: > > https://cx-oracle.readthedocs.io/en/latest/release_notes.html#version-7-3-december-2019 > > Please provide any feedback via GitHub issues ( > https://github.com/oracle/python-cx_Oracle/issues). > -------------- next part -------------- > An HTML attachment was scrubbed... > > ------------------------------ > > > > ------------------------------ > > Subject: Digest Footer > > _______________________________________________ > cx-oracle-users mailing list > cx-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > > > ------------------------------ > > End of cx-oracle-users Digest, Vol 142, Issue 1 > *********************************************** > -- M. M. RASHID(Rubel) Perth, Australia. E-mail: mm...@gm... Phone: +61 406996028 (Mobile) |
|
From: Anthony T. <ant...@gm...> - 2019-12-03 01:09:34
|
What is cx_Oracle? cx_Oracle is a Python extension module that enables access to Oracle Database for Python 3.x and 2.x and conforms to the Python database API 2.0 specifications with a number of enhancements. Where do I get it? https://oracle.github.io/python-cx_Oracle The easiest method to install/upgrade cx_Oracle is via pip as in python -m pip install cx_Oracle --upgrade What's new? See my colleague's blog post for an overview: https://blogs.oracle.com/opal/python-cx_oracle-73-for-oracle-database-is-on-pypi See the full release notes for all of the details: https://cx-oracle.readthedocs.io/en/latest/release_notes.html#version-7-3-december-2019 Please provide any feedback via GitHub issues ( https://github.com/oracle/python-cx_Oracle/issues). |
|
From: Anthony T. <ant...@gm...> - 2019-09-30 17:25:28
|
Hi,
This is expected behaviour. The "CHAR" type fields all expect space-padded
values. cx_Oracle will bind as VARCHAR2 for string values (or NVARCHAR2 for
Python 2.7 unicode values), however. In that case, you need to specify the
right number of spaces for the comparison to be successful. If you use CHAR
(or NCHAR) specifically, Oracle automatically adds the necessary spaces. In
general, you should only use CHAR or NCHAR for fixed width values -- or you
will have to pad with the right number of spaces yourself or specifically
use the CHAR or NCHAR types.
Anthony
On Mon, Sep 30, 2019 at 3:40 AM kotofos <ib...@gm...> wrote:
> Hello,
>
> I have a question about char/nchar and binding parameters type.
>
> We have tables which have char and nchar PK columns. When filtering with
> bound parameters on these columns, it is required to put in exact value
> with padding in where clause. Though, when the same is done as text,
> without params filtering works as expected.
>
> Examples:
> CREATE TABLE DBTESTING.nchartable
> (
> id NCHAR(4) PRIMARY KEY NOT NULL
> );
> insert into nchartable values ('1');
>
> cur.execute("select * from nchartable where id = '1'") found
> cur.execute("select * from nchartable where id = :id", ['1 ']) found
> cur.execute("select * from nchartable where id = :id", ['1']) not found
>
> After debugging I found, that where clause fails because the parameter is
> nvarchar2. When I manually set the type to nchar all cases above works. See
> attached code.
> Is this behavior intended or it is a bug?
> How to correctly search on nchar column without adding padding in a query
> and preferably without specifying type manually?
>
> Checked on cx_oracle 7.2.2
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
|
|
From: kotofos <ib...@gm...> - 2019-09-30 09:39:55
|
Hello,
I have a question about char/nchar and binding parameters type.
We have tables which have char and nchar PK columns. When filtering with
bound parameters on these columns, it is required to put in exact value
with padding in where clause. Though, when the same is done as text,
without params filtering works as expected.
Examples:
CREATE TABLE DBTESTING.nchartable
(
id NCHAR(4) PRIMARY KEY NOT NULL
);
insert into nchartable values ('1');
cur.execute("select * from nchartable where id = '1'") found
cur.execute("select * from nchartable where id = :id", ['1 ']) found
cur.execute("select * from nchartable where id = :id", ['1']) not found
After debugging I found, that where clause fails because the parameter is
nvarchar2. When I manually set the type to nchar all cases above works. See
attached code.
Is this behavior intended or it is a bug?
How to correctly search on nchar column without adding padding in a query
and preferably without specifying type manually?
Checked on cx_oracle 7.2.2
|
|
From: Anthony T. <ant...@gm...> - 2019-08-13 03:52:17
|
What is cx_Oracle? cx_Oracle is a Python extension module that enables access to Oracle Database for Python 3.x and 2.x and conforms to the Python database API 2.0 specifications with a number of enhancements. Where do I get it? https://oracle.github.io/python-cx_Oracle The easiest method to install/upgrade cx_Oracle is via pip as in python -m pip install cx_Oracle --upgrade What's new? This release addresses a number of small issues. See the release notes for more information. https://cx-oracle.readthedocs.io/en/latest/release_notes.html#version-7-2-2-august-2019 Please provide any feedback via GitHub issues ( https://github.com/oracle/python-cx_Oracle/issues). |
|
From: Anthony T. <ant...@gm...> - 2019-07-25 20:43:42
|
What is cx_Oracle? cx_Oracle is a Python extension module that enables access to Oracle Database for Python 3.x and 2.x and conforms to the Python database API 2.0 specifications with a number of enhancements. Where do I get it? https://oracle.github.io/python-cx_Oracle The easiest method to install/upgrade cx_Oracle is via pip as in python -m pip install cx_Oracle --upgrade What's new? This release addresses one bug on Windows. See the release notes for more information. https://cx-oracle.readthedocs.io/en/latest/releasenotes.html#version-7-2-1-july-2019 Please provide any feedback via GitHub issues (https://github.com/oracle /python-cx_Oracle/issues). |
|
From: Anthony T. <ant...@gm...> - 2019-07-02 22:32:18
|
What is cx_Oracle? cx_Oracle is a Python extension module that enables access to Oracle Database for Python 3.x and 2.x and conforms to the Python database API 2.0 specifications with a number of enhancements. Where do I get it? https://oracle.github.io/python-cx_Oracle The easiest method to install/upgrade cx_Oracle is via pip as in python -m pip install cx_Oracle --upgrade What's new? This release focused on advanced queuing, adding support for RAW queues and bulk enqueue/dequeue. Support was also added for a preview of SODA bulk insert. A number of smaller enhancements and bug fixes were also made. See the full release notes for all of the details: https://cx-oracle.readthedocs.io/en/latest/releasenotes.html#version-7-2-july-2019 Please provide any feedback via GitHub issues ( https://github.com/oracle/python-cx_Oracle/issues). |
|
From: Anthony T. <ant...@gm...> - 2019-04-24 16:55:33
|
What is cx_Oracle? cx_Oracle is a Python extension module that enables access to Oracle Database for Python 3.x and 2.x and conforms to the Python database API 2.0 specifications with a number of enhancements. Where do I get it? https://oracle.github.io/python-cx_Oracle The easiest method to install/upgrade cx_Oracle is via pip as in python -m pip install cx_Oracle --upgrade What's new? This release addresses a couple of bugs. See the release notes for more information. https://cx-oracle.readthedocs.io/en/latest/releasenotes.html#version-7-1-3-april-2019 Please provide any feedback via GitHub issues (https://github.com/oracle /python-cx_Oracle/issues). |
|
From: Anthony T. <ant...@gm...> - 2019-03-13 01:09:11
|
What is cx_Oracle? cx_Oracle is a Python extension module that enables access to Oracle Database for Python 3.x and 2.x and conforms to the Python database API 2.0 specifications with a number of enhancements. Where do I get it? https://oracle.github.io/python-cx_Oracle The easiest method to install/upgrade cx_Oracle is via pip as in python -m pip install cx_Oracle --upgrade What's new? This release addresses a couple of bugs. See the release notes for more information. https://cx-oracle.readthedocs.io/en/latest/releasenotes.html#version-7-1-2-march-2019 Please provide any feedback via GitHub issues (https://github.com/oracle /python-cx_Oracle/issues). |
|
From: Anthony T. <ant...@gm...> - 2019-02-19 22:47:53
|
What is cx_Oracle? cx_Oracle is a Python extension module that enables access to Oracle Database for Python 3.x and 2.x and conforms to the Python database API 2.0 specifications with a number of enhancements. Where do I get it? https://oracle.github.io/python-cx_Oracle The easiest method to install/upgrade cx_Oracle is via pip as in python -m pip install cx_Oracle --upgrade What's new? This release addresses a couple of bugs. See the release notes for more information. https://cx-oracle.readthedocs.io/en/latest/releasenotes.html#version-7-1-1-february-2019 Please provide any feedback via GitHub issues (https://github.com/oracle /python-cx_Oracle/issues). |
|
From: Anthony T. <ant...@gm...> - 2019-02-05 00:13:04
|
What is cx_Oracle? cx_Oracle is a Python extension module that enables access to Oracle Database for Python 3.x and 2.x and conforms to the Python database API 2.0 specifications with a number of enhancements. Where do I get it? https://oracle.github.io/python-cx_Oracle The easiest method to install/upgrade cx_Oracle is via pip as in python -m pip install cx_Oracle --upgrade What's new? This release focused on session pools. Specifically, a session callback may now be specified when a pool is created. This allows an application to improve performance by reducing the number of round trips to the database needed in order to set session state. A number of smaller enhancements and bug fixes were also made. See the full release notes for all of the details: https://cx-oracle.readthedocs.io/en/latest/releasenotes.html#version-7-1-february-2019 Please provide any feedback via GitHub issues ( https://github.com/oracle/python-cx_Oracle/issues). |
|
From: Christopher J. <chr...@or...> - 2019-01-16 00:43:08
|
On 14/1/19 8:34 pm, Piotr Dobrogost wrote: > Hi all! > > How can I induce ORA-03114 in cx_Oracle for the purpose of testing application behavior? > > I tried blocking network traffic after the connection has been established but this resulted in cx_Oracle (I guess) waiting for a response from the > server and after a couple of minutes I gave up. Strangely it seems like there are no timeouts in this situation. > > I guess inducing ORA-03114 might require closing all connections (I'm using connection pool in SQLAlchemy) and then somehow preventing new ones from > establishing? > > Best regards, > Piotr Dobrogost > That's not such a common request... What are you trying to test? Are you using a session pool? Regarding timeouts, there are Oracle Net parameters you can put in a sqlnet.ora file (on the machine where cx_Oracle is), such as SQLNET.SEND_TIMEOUT, SQLNET.RECV_TIMEOUT and SQLNET.OUTBOUND_CONNECT_TIMEOUT e.g. https://docs.oracle.com/en/database/oracle/oracle-database/18/netrf/parameters-for-the-sqlnet-ora-file.html#GUID-0857C817-675F-4CF0-BFBB-C3667F119176 If you want to generate an error, does it have to be ORA-3114? To generate various connection failures you can kill the Oracle DB server process, or set the above parameters. Chris -- http://twitter.com/ghrd |
|
From: Piotr D. <public.2019@p.dobrogost.net> - 2019-01-14 09:35:37
|
Hi all! How can I induce ORA-03114 in cx_Oracle for the purpose of testing application behavior? I tried blocking network traffic after the connection has been established but this resulted in cx_Oracle (I guess) waiting for a response from the server and after a couple of minutes I gave up. Strangely it seems like there are no timeouts in this situation. I guess inducing ORA-03114 might require closing all connections (I'm using connection pool in SQLAlchemy) and then somehow preventing new ones from establishing? Best regards, Piotr Dobrogost |
|
From: Christopher J. <chr...@or...> - 2018-09-14 05:55:19
|
On 14/9/18 6:56 am, Anthony Tuininga wrote: > What is cx_Oracle? > > cx_Oracle is a Python extension module that enables access to Oracle Database for Python 3.x and 2.x and conforms to the Python database API 2.0 > specifications with a number of enhancements. > > > Where do I get it? > https://oracle.github.io/python-cx_Oracle > <https://urldefense.proofpoint.com/v2/url?u=https-3A__oracle.github.io_python-2Dcx-5FOracle&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=3MLDt4WnhSfM67xVZPcNb9rOr2YsOR-U1GJCZEWF4t0&m=rQ8ApN0OGDsvFa7AOalq7Q8t2O6W2VWjC0bsLqC9C-A&s=lsFlUdhPkK90KxNu1KEpwR7RCZe1l_1HkH8icvu8ZiM&e=> > > The easiest method to install/upgrade cx_Oracle is via pip as in > > python -m pip install cx_Oracle --upgrade > > > What's new? > > This release focused on support for Oracle Client 18 libraries, with support added for call timeouts and SODA (Simple Oracle Document Access). > > A number of smaller changes were also made to improve the experience of using cx_Oracle. These include re-enabling the pool pinging functionality > for Oracle 12.2 and higher to handle classes of connection errors such as resource profile limits; improved error messages when a feature requires a > particular version of Oracle Client libraries or Oracle Database; better handling of objects when the connection that created them is closed; better > handling of connections when the pool that created them is destroyed; etc. > > See the release notes for more information: https://cx-oracle.readthedocs.io/en/latest/releasenotes.html#version-7-0-september-2018 > <https://urldefense.proofpoint.com/v2/url?u=https-3A__cx-2Doracle.readthedocs.io_en_latest_releasenotes.html-23version-2D7-2D0-2Dseptember-2D2018&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=3MLDt4WnhSfM67xVZPcNb9rOr2YsOR-U1GJCZEWF4t0&m=rQ8ApN0OGDsvFa7AOalq7Q8t2O6W2VWjC0bsLqC9C-A&s=BR43ggt8E5eXBDxQmkS8qYkrfqIo-mtXu4hlgvyyNMw&e=> > > Please provide any feedback via GitHub issues (https://github.com/oracle/python-cx_Oracle/issues > <https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_oracle_python-2Dcx-5FOracle_issues&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=3MLDt4WnhSfM67xVZPcNb9rOr2YsOR-U1GJCZEWF4t0&m=rQ8ApN0OGDsvFa7AOalq7Q8t2O6W2VWjC0bsLqC9C-A&s=3sjEHsFB2-T3CZanTcUxtqA3vDAnJ4DGBORlhqXHn-k&e=>). I put together a brief blog post with some details on the new features in cx_Oracle 7: https://blogs.oracle.com/opal/python-cx_oracle-7-introduces-soda-document-storage Chris -- http://twitter.com/ghrd |
|
From: Anthony T. <ant...@gm...> - 2018-09-13 20:56:29
|
What is cx_Oracle? cx_Oracle is a Python extension module that enables access to Oracle Database for Python 3.x and 2.x and conforms to the Python database API 2.0 specifications with a number of enhancements. Where do I get it? https://oracle.github.io/python-cx_Oracle The easiest method to install/upgrade cx_Oracle is via pip as in python -m pip install cx_Oracle --upgrade What's new? This release focused on support for Oracle Client 18 libraries, with support added for call timeouts and SODA (Simple Oracle Document Access). A number of smaller changes were also made to improve the experience of using cx_Oracle. These include re-enabling the pool pinging functionality for Oracle 12.2 and higher to handle classes of connection errors such as resource profile limits; improved error messages when a feature requires a particular version of Oracle Client libraries or Oracle Database; better handling of objects when the connection that created them is closed; better handling of connections when the pool that created them is destroyed; etc. See the release notes for more information: https://cx-oracle.readthedocs.io/en/latest/releasenotes.html#version-7-0-september-2018 Please provide any feedback via GitHub issues ( https://github.com/oracle/python-cx_Oracle/issues). |
|
From: Anthony T. <ant...@gm...> - 2018-07-09 19:57:03
|
What is cx_Oracle? cx_Oracle is a Python extension module that enables access to Oracle Database for Python 3.x and 2.x and conforms to the Python database API 2.0 specifications with a number of enhancements. Where do I get it? https://oracle.github.io/python-cx_Oracle The easiest method to install/upgrade cx_Oracle is via pip as in python -m pip install cx_Oracle --upgrade What's new? This release addresses a couple of bugs. See the release notes for more information. https://cx-oracle.readthedocs.io/en/latest/releasenotes.html#version-6-4-1-july-2018 Please provide any feedback via GitHub issues ( https://github.com/oracle/python-cx_Oracle/issues). |
|
From: Anthony T. <ant...@gm...> - 2018-07-02 21:59:34
|
What is cx_Oracle? cx_Oracle is a Python extension module that enables access to Oracle Database for Python 3.x and 2.x and conforms to the Python database API 2.0 specifications with a number of enhancements. Where do I get it? https://oracle.github.io/python-cx_Oracle The easiest method to install/upgrade cx_Oracle is via pip as in python -m pip install cx_Oracle --upgrade What's new? This release adds support for grouping notifications to subscriptions and adds support for getting notifications when AQ messages are available to be dequeued. Support was also added for timed waits when acquiring sessions from a session pool and for setting the values of the timeout and maximum lifetime attributes of a pool when it is created. Cursors can now be used as context managers and a number of other enhancements and bug fixes were made. See the release notes for more information. http://cx-oracle.readthedocs.io/en/latest/releasenotes.html#version-6-4-july-2018 Please provide any feedback via GitHub issues ( https://github.com/oracle/python-cx_Oracle/issues). |
|
From: Christopher J. <chr...@or...> - 2018-05-01 01:28:46
|
Our next cx_Oracle 'Office Hours' (for 30 minutes!) will be on May 1, 2018 20:00 - 20:30 UTC. Hop on the webcast and ask Anthony Tuininga, Blaine
Carter and myself any cx_Oracle questions.
The ice-breaker theme this month is 'Batch Statement Execution with executeMany()' so we'll start with an informal chat about that, but feel free to
BYO topics and questions.
For details and a link to register for email reminders see our AskTOM Office Hours page
https://devgym.oracle.com/pls/apex/dg/office_hours/3701
(or http://tinyurl.com/pythonhours if you like to keep it short). Look for the big blue Register button if you want email reminders.
On the day, come to the AskTOM page and find the button to join the web cast (it'll be available 5 or so minutes before the start time). We'll be
using Zoom for the conference, so you'll be able to jump right on if your browser is configured. You can optionally dial in from a phone. No
pre-registration etc is needed - but do it so you get the email reminders.
Chris
--
http://twitter.com/ghrd
|
|
From: Christopher J. <chr...@or...> - 2018-04-27 22:12:33
|
Anthony has written a great article on using executemany() in cx_Oracle for efficient 'Array DML'. It is at: https://blogs.oracle.com/opal/efficient-and-scalable-batch-statement-execution-in-python-cx_oracle Chris -- http://twitter.com/ghrd |
31 messages has been excluded from this view by a project administrator.
