cx-oracle-users Mailing List for cx_Oracle
Brought to you by:
atuining
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
|
| S | M | T | W | T | F | S |
|---|---|---|---|---|---|---|
|
|
|
|
|
|
|
1
|
|
2
|
3
(4) |
4
(1) |
5
|
6
(3) |
7
(1) |
8
|
|
9
|
10
(2) |
11
|
12
|
13
|
14
|
15
|
|
16
|
17
|
18
(5) |
19
|
20
(1) |
21
|
22
|
|
23
|
24
|
25
|
26
|
27
|
28
(1) |
29
|
|
30
|
|
|
|
|
|
|
|
From: Anthony T. <ant...@gm...> - 2006-04-28 14:52:21
|
Apologies for the delay in getting back to you on this. I finally
confirmed the problem and your solution. NumberVar_GetValue() also had
problems as you suspected and I've fixed them as well. I've also added
a test case to the test suite to test for this particular situation.
Thank you for notifying me of the problem and providing a solution.
On 4/20/06, Uwe Hoffmann <qu...@ti...> wrote:
>
> Hi ,
> i think that there is a serious problem within cx_Oracle when dealing
> with large numbers (not python longs) for example 6088343244 on
> platforms where sizeof(long) !=3D sizeof(int)
>
> The attached fix solves the problem for me (Solaris) but maybe there are
> other similar problems (NumberVar_GetValue)
>
> regards
> Uwe
>
>
> *** cx_Oracle-4.1.2/NumberVar.c 2006-04-20 12:17:28.000000000 +0200
> --- cx_Oracle-4.1.2_org/NumberVar.c 2004-11-18 16:55:56.000000000 +01=
00
> ***************
> *** 146,152 ****
> {
> PyObject *textValue;
> double doubleValue;
> ! long integerValue;
> sword status;
>
> // make sure a number is being bound
> --- 146,152 ----
> {
> PyObject *textValue;
> double doubleValue;
> ! int integerValue;
> sword status;
>
> // make sure a number is being bound
> ***************
> *** 160,166 ****
> if (PyInt_Check(value)) {
> integerValue =3D PyInt_AS_LONG(value);
> status =3D OCINumberFromInt(var->environment->errorHandle,
> &integerValue,
> ! sizeof(long), OCI_NUMBER_SIGNED, &var->data[pos]);
> if (var->returnType =3D=3D gc_NumberAsUnknown)
> var->returnType =3D gc_NumberAsInteger;
> } else if (PyFloat_Check(value)) {
> --- 160,166 ----
> if (PyInt_Check(value)) {
> integerValue =3D PyInt_AS_LONG(value);
> status =3D OCINumberFromInt(var->environment->errorHandle,
> &integerValue,
> ! sizeof(int), OCI_NUMBER_SIGNED, &var->data[pos]);
> if (var->returnType =3D=3D gc_NumberAsUnknown)
> var->returnType =3D gc_NumberAsInteger;
> } else if (PyFloat_Check(value)) {
>
>
>
> -------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job ea=
sier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronim=
o
> http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D120709&bid=3D263057&dat=
=3D121642
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
|
|
From: Uwe H. <qu...@ti...> - 2006-04-20 10:29:06
|
Hi ,
i think that there is a serious problem within cx_Oracle when dealing
with large numbers (not python longs) for example 6088343244 on
platforms where sizeof(long) != sizeof(int)
The attached fix solves the problem for me (Solaris) but maybe there are
other similar problems (NumberVar_GetValue)
regards
Uwe
*** cx_Oracle-4.1.2/NumberVar.c 2006-04-20 12:17:28.000000000 +0200
--- cx_Oracle-4.1.2_org/NumberVar.c 2004-11-18 16:55:56.000000000 +0100
***************
*** 146,152 ****
{
PyObject *textValue;
double doubleValue;
! long integerValue;
sword status;
// make sure a number is being bound
--- 146,152 ----
{
PyObject *textValue;
double doubleValue;
! int integerValue;
sword status;
// make sure a number is being bound
***************
*** 160,166 ****
if (PyInt_Check(value)) {
integerValue = PyInt_AS_LONG(value);
status = OCINumberFromInt(var->environment->errorHandle,
&integerValue,
! sizeof(long), OCI_NUMBER_SIGNED, &var->data[pos]);
if (var->returnType == gc_NumberAsUnknown)
var->returnType = gc_NumberAsInteger;
} else if (PyFloat_Check(value)) {
--- 160,166 ----
if (PyInt_Check(value)) {
integerValue = PyInt_AS_LONG(value);
status = OCINumberFromInt(var->environment->errorHandle,
&integerValue,
! sizeof(int), OCI_NUMBER_SIGNED, &var->data[pos]);
if (var->returnType == gc_NumberAsUnknown)
var->returnType = gc_NumberAsInteger;
} else if (PyFloat_Check(value)) {
|
|
From: Tom H. <tom...@sc...> - 2006-04-18 15:59:24
|
Hi Anthony,
Thanks for the tip. And thanks to others for their feedback as well. I
went with this idea as it suited me best in this case, but the other
comments gave be ideas for other approaches as well.
Thanks, Tom
On Tue, 2006-04-18 at 09:35 -0600, Anthony Tuininga wrote:
> If you want to do this you should be able to do it as follows. Note
> that this will reduce performance quite dramatically but if you are
> only dealing with a handful of rows the additional clarity might be
> worthwhile.
>
> class Cursor(cx_Oracle.Cursor):
>
> def __TransformToDict(self, row):
> return dict([(info[0], value) for info, value in
> zip(cursor.description, row)])
>
> def fetchone(self):
> row = super(Cursor, self).fetchone()
> return self.__TransformToDict(row)
>
> etc. (for fetchall() and fetchmany())
>
> Note that this code has not actually been tested but it should give
> you an idea of how to go about doing this if you have a mind to do so.
> :-)
>
> On 4/18/06, Tom Haddon <tom...@sc...> wrote:
> > Hi Folks,
> >
> > I was wondering if anyone knows if there's a way to grab the results of
> > an Oracle query into a tuple of dictionaries (one for each row with the
> > key as the column name and the value as the value of the column)?
> >
> > In mysql I do this as below:
> >
> > ----------------
> >
> > import MySQLdb
> > from MySQLdb.cursors import DictCursor
> > cursortype = DictCursor
> >
> > ...
> >
> > curs = conn.cursor(cursortype)
> > result = curs.execute("%s" % (sql, ))
> > return curs.fetchall()
> >
> > -------------------
> >
> > And in Postgres I do it like this:
> >
> > -----------------
> >
> > import pg
> >
> > ...
> >
> > result = conn.query("%s" % (sql, ))
> > return result.dictresult()
> >
> > ------------------
> >
> > I can't seem to see if there are any cursor types as with MySQLdb
> > module, or a dictresult query return method as with the pg module.
> >
> > Basically this then allows me to reference the data as follows:
> >
> > for row in TupleOfDicts():
> > print "%s %s" % (row['column1'], row['column2'])
> >
> > Any help appreciated.
> >
> > Thanks, Tom
> > --
> > Tom Haddon
> > Systems Engineer
> >
> > 198 High Holborn
> > London, WC1V 7BD
> >
> > T +44 (0) 20 7959 0630
> > www.scansafe.com
> >
> > ScanSafe - Pure Internet
> >
> >
> > -------------------------------------------------------
> > This SF.Net email is sponsored by xPML, a groundbreaking scripting language
> > that extends applications into web and mobile media. Attend the live webcast
> > and join the prime developer group breaking into this new coding territory!
> > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
> > _______________________________________________
> > cx-oracle-users mailing list
> > cx-...@li...
> > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
> >
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by xPML, a groundbreaking scripting language
> that extends applications into web and mobile media. Attend the live webcast
> and join the prime developer group breaking into this new coding territory!
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
--
Tom Haddon
Systems Engineer
198 High Holborn
London, WC1V 7BD
T +44 (0) 20 7959 0630
www.scansafe.com
ScanSafe - Pure Internet
|
|
From: Hancock, D. \(DHANCOCK\) <DHA...@ar...> - 2006-04-18 15:42:16
|
I think that the module dtuple.py (written by Greg Stein) will do what =
you want (it's very flexible in how you can refer to the query results). =
Actually, I'm not 100% sure that you'll get the tuple of dictionaries, =
but that would be a very simple wrapper.
=20
http://www.lyra.org/greg/python/dtuple.py
=20
Cheers!
--
David Hancock
________________________________
From: cx-...@li... on behalf of Tom =
Haddon
Sent: Tue 4/18/2006 11:23 AM
To: cx-...@li...
Subject: [cx-oracle-users] Tuple of Dictionaries query results
Hi Folks,
I was wondering if anyone knows if there's a way to grab the results of
an Oracle query into a tuple of dictionaries (one for each row with the
key as the column name and the value as the value of the column)?
In mysql I do this as below:
----------------
import MySQLdb
from MySQLdb.cursors import DictCursor
cursortype =3D DictCursor
...
curs =3D conn.cursor(cursortype)
result =3D curs.execute("%s" % (sql, ))
return curs.fetchall()
-------------------
And in Postgres I do it like this:
-----------------
import pg
...
result =3D conn.query("%s" % (sql, ))
return result.dictresult()
------------------
I can't seem to see if there are any cursor types as with MySQLdb
module, or a dictresult query return method as with the pg module.
Basically this then allows me to reference the data as follows:
for row in TupleOfDicts():
print "%s %s" % (row['column1'], row['column2'])
Any help appreciated.
Thanks, Tom
--
Tom Haddon
Systems Engineer
198 High Holborn
London, WC1V 7BD
T +44 (0) 20 7959 0630
www.scansafe.com
ScanSafe - Pure Internet
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting =
language
that extends applications into web and mobile media. Attend the live =
webcast
and join the prime developer group breaking into this new coding =
territory!
http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D110944&bid=3D241720&dat=3D=
121642
_______________________________________________
cx-oracle-users mailing list
cx-...@li...
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
|
|
From: <wa...@li...> - 2006-04-18 15:42:03
|
Anthony Tuininga wrote: > If you want to do this you should be able to do it as follows. Note > that this will reduce performance quite dramatically but if you are > only dealing with a handful of rows the additional clarity might be > worthwhile. > > class Cursor(cx_Oracle.Cursor): > > def __TransformToDict(self, row): > return dict([(info[0], value) for info, value in > zip(cursor.description, row)]) > > def fetchone(self): > row = super(Cursor, self).fetchone() > return self.__TransformToDict(row) > > etc. (for fetchall() and fetchmany()) Or you could use ll-orasql (http://www.livinglogic.de/Python/orasql/) which does exactly that (and makes the fields available as attributes too). Bye, Walter Dörwald |
|
From: Anthony T. <ant...@gm...> - 2006-04-18 15:35:41
|
If you want to do this you should be able to do it as follows. Note
that this will reduce performance quite dramatically but if you are
only dealing with a handful of rows the additional clarity might be
worthwhile.
class Cursor(cx_Oracle.Cursor):
def __TransformToDict(self, row):
return dict([(info[0], value) for info, value in
zip(cursor.description, row)])
def fetchone(self):
row =3D super(Cursor, self).fetchone()
return self.__TransformToDict(row)
etc. (for fetchall() and fetchmany())
Note that this code has not actually been tested but it should give
you an idea of how to go about doing this if you have a mind to do so.
:-)
On 4/18/06, Tom Haddon <tom...@sc...> wrote:
> Hi Folks,
>
> I was wondering if anyone knows if there's a way to grab the results of
> an Oracle query into a tuple of dictionaries (one for each row with the
> key as the column name and the value as the value of the column)?
>
> In mysql I do this as below:
>
> ----------------
>
> import MySQLdb
> from MySQLdb.cursors import DictCursor
> cursortype =3D DictCursor
>
> ...
>
> curs =3D conn.cursor(cursortype)
> result =3D curs.execute("%s" % (sql, ))
> return curs.fetchall()
>
> -------------------
>
> And in Postgres I do it like this:
>
> -----------------
>
> import pg
>
> ...
>
> result =3D conn.query("%s" % (sql, ))
> return result.dictresult()
>
> ------------------
>
> I can't seem to see if there are any cursor types as with MySQLdb
> module, or a dictresult query return method as with the pg module.
>
> Basically this then allows me to reference the data as follows:
>
> for row in TupleOfDicts():
> print "%s %s" % (row['column1'], row['column2'])
>
> Any help appreciated.
>
> Thanks, Tom
> --
> Tom Haddon
> Systems Engineer
>
> 198 High Holborn
> London, WC1V 7BD
>
> T +44 (0) 20 7959 0630
> www.scansafe.com
>
> ScanSafe - Pure Internet
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by xPML, a groundbreaking scripting langua=
ge
> that extends applications into web and mobile media. Attend the live webc=
ast
> and join the prime developer group breaking into this new coding territor=
y!
> http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D110944&bid=3D241720&dat=
=3D121642
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
|
|
From: Tom H. <tom...@sc...> - 2006-04-18 15:25:23
|
Hi Folks,
I was wondering if anyone knows if there's a way to grab the results of
an Oracle query into a tuple of dictionaries (one for each row with the
key as the column name and the value as the value of the column)?
In mysql I do this as below:
----------------
import MySQLdb
from MySQLdb.cursors import DictCursor
cursortype = DictCursor
...
curs = conn.cursor(cursortype)
result = curs.execute("%s" % (sql, ))
return curs.fetchall()
-------------------
And in Postgres I do it like this:
-----------------
import pg
...
result = conn.query("%s" % (sql, ))
return result.dictresult()
------------------
I can't seem to see if there are any cursor types as with MySQLdb
module, or a dictresult query return method as with the pg module.
Basically this then allows me to reference the data as follows:
for row in TupleOfDicts():
print "%s %s" % (row['column1'], row['column2'])
Any help appreciated.
Thanks, Tom
--
Tom Haddon
Systems Engineer
198 High Holborn
London, WC1V 7BD
T +44 (0) 20 7959 0630
www.scansafe.com
ScanSafe - Pure Internet
|
|
From: Anthony T. <ant...@gm...> - 2006-04-10 18:23:18
|
See the test suite for an example of how to call a stored procedure
with an out cursor that you can then fetch from. Specifically, look at
the file called "CursorVar.py". If you need more specific pointers,
please let me know.
On 4/10/06, Lear, Russell <Rus...@xe...> wrote:
> Hi all,
>
> I'm a (mostly) happy user of cx_Oracle, but I've found one hole that I'd
> like to find a solution to.
>
> I'm running I have a stored procedure looking like
>
> PROCEDURE RestartableJobs(c_djob OUT djob_cursor) IS
> BEGIN
>
> OPEN c_djob FOR 'SELECT distinct job_id from jobtable
> where status < cnStatusRejected and exists (select null from
> activejobs where activejobs.job_id =3D jobtable.job_id)';
> NULL;
>
> END RestartableJobs;
>
> How do I call this thing? (or do I?) Clearly, in this case I could
> pass in the sql myself, but duplicating existing PL/SQL code isn't too
> attractive.
>
> >>> import cx_Oracle as cxo
> >>> connection =3D cxo.connect('scott/tiger')
> >>> cur =3D connection.cursor()
> >>> r =3D cur.callproc('rlpkg.RestartableJobs')
> Traceback (most recent call last):
> File "<stdin>", line 1, in ?
> cx_Oracle.DatabaseError: ORA-06550: line 1, column 7:
> PLS-00306: wrong number or types of arguments in call to
> 'RESTARTABLEJOBS'
> ORA-06550: line 1, column 7:
> PL/SQL: Statement ignored
>
> But I can't figure out what to pass in to it. Any hints? For what it's
> worth, I'm on WinXP, using Oracle 9i, with cx_Oracle 4.1.2.
>
> Thanks,
> Russell.
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by xPML, a groundbreaking scripting langua=
ge
> that extends applications into web and mobile media. Attend the live webc=
ast
> and join the prime developer group breaking into this new coding territor=
y!
> http://sel.as-us.falkag.net/sel?cmdlnk&kid=110944&bid$1720&dat=121642
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
|
|
From: Lear, R. <Rus...@xe...> - 2006-04-10 17:50:12
|
Hi all,
I'm a (mostly) happy user of cx_Oracle, but I've found one hole that I'd
like to find a solution to.
I'm running I have a stored procedure looking like=20
PROCEDURE RestartableJobs(c_djob OUT djob_cursor) IS =20
BEGIN
=09
OPEN c_djob FOR 'SELECT distinct job_id from jobtable=20
where status < cnStatusRejected and exists (select null from
activejobs where activejobs.job_id =3D jobtable.job_id)';
NULL;=09
END RestartableJobs;=09
How do I call this thing? (or do I?) Clearly, in this case I could
pass in the sql myself, but duplicating existing PL/SQL code isn't too
attractive.
>>> import cx_Oracle as cxo
>>> connection =3D cxo.connect('scott/tiger')
>>> cur =3D connection.cursor()
>>> r =3D cur.callproc('rlpkg.RestartableJobs')
Traceback (most recent call last):
File "<stdin>", line 1, in ?
cx_Oracle.DatabaseError: ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to
'RESTARTABLEJOBS'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
But I can't figure out what to pass in to it. Any hints? For what it's
worth, I'm on WinXP, using Oracle 9i, with cx_Oracle 4.1.2.
Thanks,
Russell.
|
|
From: Nicola P. <nic...@it...> - 2006-04-07 14:38:48
|
Thank you for your support.
Suggestion to link lib32 instead of lib solved my compilation problem.
Now I'm starting learning cx_oracle usage.
Regards
Nicola Piazza
Nicola
Piazza/Italy/IBM
To
04/06/2006 11:54 cx-...@li....n
AM et
cc
Subject
build on aix - unresolved symbols
.OCI...
Hi all,
I'm trying to compile cx_Oracle-4.1 on Aix, with oracle 9.2. I've modified
......./....../lib/python2.3/config/Makefile to use xlc as compiler.
I've exported my ORACLE_HOME variable, then I've run a python setup.py
bdist, in order to create a binary version (I haven't compilers
everywhere).
Compilation seems ok, while I've got a problem during link phase:
# python setup.py bdist
running bdist
running bdist_dumb
running build
running build_ext
building 'cx_Oracle' extension
creating build
creating build/temp.aix-5.2-2.3
xlc -DNDEBUG -O -qmaxmem=-1 -qcpluscmt -DAIX_GENUINE_CPLUSCPLUS
-D_LARGE_FILES -I/ora01/ora9.2/rdbms/demo -I/ora01/ora9.
2/rdbms/public -I/ora01/ora9.2/network/public
-I/opt/freeware/include/python2.3 -c cx_Oracle.c -o build/temp.aix-5.2-2.3
/cx_Oracle.o -DBUILD_TIME="April 06, 2006 11:49:23"
creating build/lib.aix-5.2-2.3
/opt/freeware/lib/python2.3/config/ld_so_aix xlc
-bI:/opt/freeware/lib/python2.3/config/python.exp build/temp.aix-5.2-2.
3/cx_Oracle.o -L/ora01/ora9.2/lib -lclntsh -o build/lib.aix-5.2-2.3
/cx_Oracle.so -s
ld: 0711-317 ERROR: Undefined symbol: .OCIAttrGet
ld: 0711-317 ERROR: Undefined symbol: .OCIStmtFetch
ld: 0711-317 ERROR: Undefined symbol: .OCIStmtPrepare2
ld: 0711-317 ERROR: Undefined symbol: .OCIParamGet
ld: 0711-317 ERROR: Undefined symbol: .OCIDescriptorFree
ld: 0711-317 ERROR: Undefined symbol: .OCIStmtExecute
ld: 0711-317 ERROR: Undefined symbol: .OCIStmtGetBindInfo
ld: 0711-317 ERROR: Undefined symbol: .OCIDefineByPos
ld: 0711-317 ERROR: Undefined symbol: .OCILobCreateTemporary
ld: 0711-317 ERROR: Undefined symbol: .OCILobTrim
ld: 0711-317 ERROR: Undefined symbol: .OCILobWrite
ld: 0711-317 ERROR: Undefined symbol: .OCILobFreeTemporary
ld: 0711-317 ERROR: Undefined symbol: .OCIDescriptorAlloc
ld: 0711-317 ERROR: Undefined symbol: .OCILobRead
ld: 0711-317 ERROR: Undefined symbol: .OCILobGetLength
ld: 0711-317 ERROR: Undefined symbol: .OCIDateTimeGetDate
ld: 0711-317 ERROR: Undefined symbol: .OCIDateTimeGetTime
ld: 0711-317 ERROR: Undefined symbol: .OCIDateTimeConstruct
ld: 0711-317 ERROR: Undefined symbol: .OCIDateTimeCheck
ld: 0711-317 ERROR: Undefined symbol: .OCIDateCheck
ld: 0711-317 ERROR: Undefined symbol: .OCINumberToInt
ld: 0711-317 ERROR: Undefined symbol: .OCINumberToText
ld: 0711-317 ERROR: Undefined symbol: .OCINumberToReal
ld: 0711-317 ERROR: Undefined symbol: .OCINumberFromText
ld: 0711-317 ERROR: Undefined symbol: .OCINumberFromReal
ld: 0711-317 ERROR: Undefined symbol: .OCINumberFromInt
ld: 0711-317 ERROR: Undefined symbol: .OCIBindByName
ld: 0711-317 ERROR: Undefined symbol: .OCIBindByPos
ld: 0711-317 ERROR: Undefined symbol: .OCIHandleAlloc
ld: 0711-317 ERROR: Undefined symbol: .OCIServerAttach
ld: 0711-317 ERROR: Undefined symbol: .OCIAttrSet
ld: 0711-317 ERROR: Undefined symbol: .OCISessionBegin
ld: 0711-317 ERROR: Undefined symbol: .OCISessionGet
ld: 0711-317 ERROR: Undefined symbol: .OCIUserCallbackGet
ld: 0711-317 ERROR: Undefined symbol: .OCIUserCallbackRegister
ld: 0711-317 ERROR: Undefined symbol: .OCIBreak
ld: 0711-317 ERROR: Undefined symbol: .OCITransRollback
ld: 0711-317 ERROR: Undefined symbol: .OCITransPrepare
ld: 0711-317 ERROR: Undefined symbol: .OCITransStart
ld: 0711-317 ERROR: Undefined symbol: .OCITransCommit
ld: 0711-317 ERROR: Undefined symbol: .OCISessionEnd
ld: 0711-317 ERROR: Undefined symbol: .OCIHandleFree
ld: 0711-317 ERROR: Undefined symbol: .OCISessionRelease
ld: 0711-317 ERROR: Undefined symbol: .OCIServerDetach
ld: 0711-317 ERROR: Undefined symbol: .OCISessionPoolDestroy
ld: 0711-317 ERROR: Undefined symbol: .OCISessionPoolCreate
ld: 0711-317 ERROR: Undefined symbol: .OCIEnvCreate
ld: 0711-317 ERROR: Undefined symbol: .OCINlsNumericInfoGet
ld: 0711-317 ERROR: Undefined symbol: .OCIErrorGet
ld: 0711-317 ERROR: Undefined symbol: .OCIStmtRelease
ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more
information.
installing to build/bdist.aix-5.2/dumb
running install
running install_lib
creating build/bdist.aix-5.2
creating build/bdist.aix-5.2/dumb
creating build/bdist.aix-5.2/dumb/opt
creating build/bdist.aix-5.2/dumb/opt/freeware
creating build/bdist.aix-5.2/dumb/opt/freeware/lib
creating build/bdist.aix-5.2/dumb/opt/freeware/lib/python2.3
creating build/bdist.aix-5.2/dumb/opt/freeware/lib/python2.3/site-packages
tar -cf /tmp/python/source/cx_Oracle-4.1/dist/cx_Oracle-4.1.aix-5.2.tar .
gzip -f9 /tmp/python/source/cx_Oracle-4.1/dist/cx_Oracle-4.1.aix-5.2.tar
removing 'build/bdist.aix-5.2/dumb' (and everything under it)
Any suggestion ?
I've used nm in $ORACLE_HOME/lib to verify who exports these symbols and
found them in libjmisc.so and in hsdb_ora.so.
Compiler and linker seems ok, since I've correctly compiled PyDB2 module.
Thank you for your support.
|
|
From: Hubert B H. <hhi...@un...> - 2006-04-06 19:14:30
|
I would to catch the warning that comes back from Oracle that tells the
user that their password will expire soon. Via JDBC and Java (just as
example) it looks something like this:
this.conn = DriverManager.getConnection (url, u, p);
SQLWarning sqlw = this.conn.getWarnings();
if (sqlw != null ) {
System.out.println("verifyPassword warning for " + u + ":
" + sqlw.getMessage());
if (sqlw.getErrorCode() == 28002) {
/*
* This is the password expiration warning that
will be passed back to the user
*/
<do some work here >
This doesn't come back as an exception from Oracle, and I can't figure out
how to see the warning from cx_Oracle. Catching cx_Oracle.Warning doesn't
get catch this warning. Is there a way to catch this warning?
Thanks!
Hubert Hickman
|
|
From: inkbottle <ink...@gm...> - 2006-04-06 14:02:12
|
Your ORACLE_HOME is pointing to 64-bit Oracle libraries, but you are building 32-bit so cx_Oracle cannot load the 64-bit Oracle libraries. You'll want to use $ORACLE_HOME/lib32 to build 32-bit. This will require that you edit the setup.py script to replace all the lib references to lib32. Also I believe you will want to build with xlc_r instead of xlc. I wouldn't muck with the Makefiles except as a last resort, but rather the setup.py script, which only vaguely works out of the box on AIX. I don't know what pyDB2 has to do with this, but then I have never built with python earlier than 2.4. Nicola Piazza wrote: > Hi all, > I'm trying to compile cx_Oracle-4.1 on Aix, with oracle 9.2. I've modified > ......./....../lib/python2.3/config/Makefile to use xlc as compiler. > I've exported my ORACLE_HOME variable, then I've run a python setup.py > bdist, in order to create a binary version (I haven't compilers > everywhere). > > Compilation seems ok, while I've got a problem during link phase: > > # python setup.py bdist > running bdist > running bdist_dumb > running build > running build_ext > building 'cx_Oracle' extension > creating build > creating build/temp.aix-5.2-2.3 > xlc -DNDEBUG -O -qmaxmem=-1 -qcpluscmt -DAIX_GENUINE_CPLUSCPLUS > -D_LARGE_FILES -I/ora01/ora9.2/rdbms/demo -I/ora01/ora9. > 2/rdbms/public -I/ora01/ora9.2/network/public > -I/opt/freeware/include/python2.3 -c cx_Oracle.c -o build/temp.aix-5.2-2.3 > /cx_Oracle.o -DBUILD_TIME="April 06, 2006 11:49:23" > creating build/lib.aix-5.2-2.3 > /opt/freeware/lib/python2.3/config/ld_so_aix xlc > -bI:/opt/freeware/lib/python2.3/config/python.exp build/temp.aix-5.2-2. > 3/cx_Oracle.o -L/ora01/ora9.2/lib -lclntsh -o build/lib.aix-5.2-2.3 > /cx_Oracle.so -s > ld: 0711-317 ERROR: Undefined symbol: .OCIAttrGet > ld: 0711-317 ERROR: Undefined symbol: .OCIStmtFetch > ld: 0711-317 ERROR: Undefined symbol: .OCIStmtPrepare2 > ld: 0711-317 ERROR: Undefined symbol: .OCIParamGet > ld: 0711-317 ERROR: Undefined symbol: .OCIDescriptorFree > ld: 0711-317 ERROR: Undefined symbol: .OCIStmtExecute > ld: 0711-317 ERROR: Undefined symbol: .OCIStmtGetBindInfo > ld: 0711-317 ERROR: Undefined symbol: .OCIDefineByPos > ld: 0711-317 ERROR: Undefined symbol: .OCILobCreateTemporary > ld: 0711-317 ERROR: Undefined symbol: .OCILobTrim > ld: 0711-317 ERROR: Undefined symbol: .OCILobWrite > ld: 0711-317 ERROR: Undefined symbol: .OCILobFreeTemporary > ld: 0711-317 ERROR: Undefined symbol: .OCIDescriptorAlloc > ld: 0711-317 ERROR: Undefined symbol: .OCILobRead > ld: 0711-317 ERROR: Undefined symbol: .OCILobGetLength > ld: 0711-317 ERROR: Undefined symbol: .OCIDateTimeGetDate > ld: 0711-317 ERROR: Undefined symbol: .OCIDateTimeGetTime > ld: 0711-317 ERROR: Undefined symbol: .OCIDateTimeConstruct > ld: 0711-317 ERROR: Undefined symbol: .OCIDateTimeCheck > ld: 0711-317 ERROR: Undefined symbol: .OCIDateCheck > ld: 0711-317 ERROR: Undefined symbol: .OCINumberToInt > ld: 0711-317 ERROR: Undefined symbol: .OCINumberToText > ld: 0711-317 ERROR: Undefined symbol: .OCINumberToReal > ld: 0711-317 ERROR: Undefined symbol: .OCINumberFromText > ld: 0711-317 ERROR: Undefined symbol: .OCINumberFromReal > ld: 0711-317 ERROR: Undefined symbol: .OCINumberFromInt > ld: 0711-317 ERROR: Undefined symbol: .OCIBindByName > ld: 0711-317 ERROR: Undefined symbol: .OCIBindByPos > ld: 0711-317 ERROR: Undefined symbol: .OCIHandleAlloc > ld: 0711-317 ERROR: Undefined symbol: .OCIServerAttach > ld: 0711-317 ERROR: Undefined symbol: .OCIAttrSet > ld: 0711-317 ERROR: Undefined symbol: .OCISessionBegin > ld: 0711-317 ERROR: Undefined symbol: .OCISessionGet > ld: 0711-317 ERROR: Undefined symbol: .OCIUserCallbackGet > ld: 0711-317 ERROR: Undefined symbol: .OCIUserCallbackRegister > ld: 0711-317 ERROR: Undefined symbol: .OCIBreak > ld: 0711-317 ERROR: Undefined symbol: .OCITransRollback > ld: 0711-317 ERROR: Undefined symbol: .OCITransPrepare > ld: 0711-317 ERROR: Undefined symbol: .OCITransStart > ld: 0711-317 ERROR: Undefined symbol: .OCITransCommit > ld: 0711-317 ERROR: Undefined symbol: .OCISessionEnd > ld: 0711-317 ERROR: Undefined symbol: .OCIHandleFree > ld: 0711-317 ERROR: Undefined symbol: .OCISessionRelease > ld: 0711-317 ERROR: Undefined symbol: .OCIServerDetach > ld: 0711-317 ERROR: Undefined symbol: .OCISessionPoolDestroy > ld: 0711-317 ERROR: Undefined symbol: .OCISessionPoolCreate > ld: 0711-317 ERROR: Undefined symbol: .OCIEnvCreate > ld: 0711-317 ERROR: Undefined symbol: .OCINlsNumericInfoGet > ld: 0711-317 ERROR: Undefined symbol: .OCIErrorGet > ld: 0711-317 ERROR: Undefined symbol: .OCIStmtRelease > ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more > information. > installing to build/bdist.aix-5.2/dumb > running install > running install_lib > creating build/bdist.aix-5.2 > creating build/bdist.aix-5.2/dumb > creating build/bdist.aix-5.2/dumb/opt > creating build/bdist.aix-5.2/dumb/opt/freeware > creating build/bdist.aix-5.2/dumb/opt/freeware/lib > creating build/bdist.aix-5.2/dumb/opt/freeware/lib/python2.3 > creating build/bdist.aix-5.2/dumb/opt/freeware/lib/python2.3/site-packages > tar -cf /tmp/python/source/cx_Oracle-4.1/dist/cx_Oracle-4.1.aix-5.2.tar . > gzip -f9 /tmp/python/source/cx_Oracle-4.1/dist/cx_Oracle-4.1.aix-5.2.tar > removing 'build/bdist.aix-5.2/dumb' (and everything under it) > > Any suggestion ? > I've used nm in $ORACLE_HOME/lib to verify who exports these symbols and > found them in libjmisc.so and in hsdb_ora.so. > > Compiler and linker seems ok, since I've correctly compiled PyDB2 module. > Thank you for your support. > > > > ------------------------------------------------------- > This SF.Net email is sponsored by xPML, a groundbreaking scripting language > that extends applications into web and mobile media. Attend the live webcast > and join the prime developer group breaking into this new coding territory! > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 > _______________________________________________ > cx-oracle-users mailing list > cx-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > > |
|
From: Nicola P. <nic...@it...> - 2006-04-06 09:54:14
|
Hi all, I'm trying to compile cx_Oracle-4.1 on Aix, with oracle 9.2. I've modified ......./....../lib/python2.3/config/Makefile to use xlc as compiler. I've exported my ORACLE_HOME variable, then I've run a python setup.py bdist, in order to create a binary version (I haven't compilers everywhere). Compilation seems ok, while I've got a problem during link phase: # python setup.py bdist running bdist running bdist_dumb running build running build_ext building 'cx_Oracle' extension creating build creating build/temp.aix-5.2-2.3 xlc -DNDEBUG -O -qmaxmem=-1 -qcpluscmt -DAIX_GENUINE_CPLUSCPLUS -D_LARGE_FILES -I/ora01/ora9.2/rdbms/demo -I/ora01/ora9. 2/rdbms/public -I/ora01/ora9.2/network/public -I/opt/freeware/include/python2.3 -c cx_Oracle.c -o build/temp.aix-5.2-2.3 /cx_Oracle.o -DBUILD_TIME="April 06, 2006 11:49:23" creating build/lib.aix-5.2-2.3 /opt/freeware/lib/python2.3/config/ld_so_aix xlc -bI:/opt/freeware/lib/python2.3/config/python.exp build/temp.aix-5.2-2. 3/cx_Oracle.o -L/ora01/ora9.2/lib -lclntsh -o build/lib.aix-5.2-2.3 /cx_Oracle.so -s ld: 0711-317 ERROR: Undefined symbol: .OCIAttrGet ld: 0711-317 ERROR: Undefined symbol: .OCIStmtFetch ld: 0711-317 ERROR: Undefined symbol: .OCIStmtPrepare2 ld: 0711-317 ERROR: Undefined symbol: .OCIParamGet ld: 0711-317 ERROR: Undefined symbol: .OCIDescriptorFree ld: 0711-317 ERROR: Undefined symbol: .OCIStmtExecute ld: 0711-317 ERROR: Undefined symbol: .OCIStmtGetBindInfo ld: 0711-317 ERROR: Undefined symbol: .OCIDefineByPos ld: 0711-317 ERROR: Undefined symbol: .OCILobCreateTemporary ld: 0711-317 ERROR: Undefined symbol: .OCILobTrim ld: 0711-317 ERROR: Undefined symbol: .OCILobWrite ld: 0711-317 ERROR: Undefined symbol: .OCILobFreeTemporary ld: 0711-317 ERROR: Undefined symbol: .OCIDescriptorAlloc ld: 0711-317 ERROR: Undefined symbol: .OCILobRead ld: 0711-317 ERROR: Undefined symbol: .OCILobGetLength ld: 0711-317 ERROR: Undefined symbol: .OCIDateTimeGetDate ld: 0711-317 ERROR: Undefined symbol: .OCIDateTimeGetTime ld: 0711-317 ERROR: Undefined symbol: .OCIDateTimeConstruct ld: 0711-317 ERROR: Undefined symbol: .OCIDateTimeCheck ld: 0711-317 ERROR: Undefined symbol: .OCIDateCheck ld: 0711-317 ERROR: Undefined symbol: .OCINumberToInt ld: 0711-317 ERROR: Undefined symbol: .OCINumberToText ld: 0711-317 ERROR: Undefined symbol: .OCINumberToReal ld: 0711-317 ERROR: Undefined symbol: .OCINumberFromText ld: 0711-317 ERROR: Undefined symbol: .OCINumberFromReal ld: 0711-317 ERROR: Undefined symbol: .OCINumberFromInt ld: 0711-317 ERROR: Undefined symbol: .OCIBindByName ld: 0711-317 ERROR: Undefined symbol: .OCIBindByPos ld: 0711-317 ERROR: Undefined symbol: .OCIHandleAlloc ld: 0711-317 ERROR: Undefined symbol: .OCIServerAttach ld: 0711-317 ERROR: Undefined symbol: .OCIAttrSet ld: 0711-317 ERROR: Undefined symbol: .OCISessionBegin ld: 0711-317 ERROR: Undefined symbol: .OCISessionGet ld: 0711-317 ERROR: Undefined symbol: .OCIUserCallbackGet ld: 0711-317 ERROR: Undefined symbol: .OCIUserCallbackRegister ld: 0711-317 ERROR: Undefined symbol: .OCIBreak ld: 0711-317 ERROR: Undefined symbol: .OCITransRollback ld: 0711-317 ERROR: Undefined symbol: .OCITransPrepare ld: 0711-317 ERROR: Undefined symbol: .OCITransStart ld: 0711-317 ERROR: Undefined symbol: .OCITransCommit ld: 0711-317 ERROR: Undefined symbol: .OCISessionEnd ld: 0711-317 ERROR: Undefined symbol: .OCIHandleFree ld: 0711-317 ERROR: Undefined symbol: .OCISessionRelease ld: 0711-317 ERROR: Undefined symbol: .OCIServerDetach ld: 0711-317 ERROR: Undefined symbol: .OCISessionPoolDestroy ld: 0711-317 ERROR: Undefined symbol: .OCISessionPoolCreate ld: 0711-317 ERROR: Undefined symbol: .OCIEnvCreate ld: 0711-317 ERROR: Undefined symbol: .OCINlsNumericInfoGet ld: 0711-317 ERROR: Undefined symbol: .OCIErrorGet ld: 0711-317 ERROR: Undefined symbol: .OCIStmtRelease ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more information. installing to build/bdist.aix-5.2/dumb running install running install_lib creating build/bdist.aix-5.2 creating build/bdist.aix-5.2/dumb creating build/bdist.aix-5.2/dumb/opt creating build/bdist.aix-5.2/dumb/opt/freeware creating build/bdist.aix-5.2/dumb/opt/freeware/lib creating build/bdist.aix-5.2/dumb/opt/freeware/lib/python2.3 creating build/bdist.aix-5.2/dumb/opt/freeware/lib/python2.3/site-packages tar -cf /tmp/python/source/cx_Oracle-4.1/dist/cx_Oracle-4.1.aix-5.2.tar . gzip -f9 /tmp/python/source/cx_Oracle-4.1/dist/cx_Oracle-4.1.aix-5.2.tar removing 'build/bdist.aix-5.2/dumb' (and everything under it) Any suggestion ? I've used nm in $ORACLE_HOME/lib to verify who exports these symbols and found them in libjmisc.so and in hsdb_ora.so. Compiler and linker seems ok, since I've correctly compiled PyDB2 module. Thank you for your support. |
|
From: Lars I. <la...@ib...> - 2006-04-04 11:45:18
|
Following up to myself for the sake of the archives, since I got my problems resolved. I had what looked like a deadlock problem and a SEGV. As it turned out, the deadlock wasn't a real deadlock, but the system was thashing wildly due to a memory leak, which I could eventually track down to Python issue: [ 1089632 ] _DummyThread() objects not freed from threading._active map: https://sourceforge.net/tracker/?func=detail&atid=105470&aid=1089632&group_id=5470 (I am starting my threads from C). >> Another user has noticed an intermittent segfault due to faulty module >> initialization. I have fixed the problem but that code is unreleased >> as of yet. I can give you the source or binary for that if you want to >> try that. > > That would be good, and source would be best. I'd like to compile > against the Oracle version I have installed. > > I couldn't reproduce the problem with 4.1.2 yet, but that doesn't mean > much - my current tests hasn't run nearly long enough yet. The SEGV has disappeared with the 4.2 prerelease that Anthony sent me. Thanks a lot. - Lars |
|
From: Steve S. <ssw...@ve...> - 2006-04-03 22:51:22
|
One way to get it as dynamic as you want would be to create a stored =20
procedure in the database that accepts the table, column, and value, =20
then generates the SQL as a string and runs it via EXECUTE IMMEDIATE.
Of course, you could just as easily construct the SQL string in =20
Python and run via execute()...
Also, if your trigger is just generating IDs, you could just make use =20=
of the nextval property of a sequence object and generate the ID as =20
part of the insert, or as a separate select before the insert.
Just my $0.02...
On Apr 3, 2006, at 5:53 PM, kellie hobbs wrote:
> That was what I was trying to get at.. oh well.
>
> Thanks.
>
> Kellie
>
> --- Anthony Tuininga <ant...@gm...> wrote:
>
>> You require a string like the one in the example. You cannot pass the
>> table name and columns to update as bind variables, if that is what
>> you are trying to get at. :-)
>>
>> On 4/3/06, kellie hobbs <kel...@ya...> wrote:
>>> Hello,
>>>
>>> Thanks for your help so far. Now can you tell me how to pass the
>> table
>>> name and columns to be updated to the execute statement?
>>>
>>> Thanks again.
>>>
>>> Kellie Hobbs
>>>
>>> --- Anthony Tuininga <ant...@gm...> wrote:
>>>
>>>> Sure. Its quite straightforward but not covered by the DB API.
>>>>
>>>> # this creates the bind variable for use by Oracle
>>>> idVar =3D cursor.var(cx_Oracle.NUMBER)
>>>>
>>>> # execute the statement exactly as you normally would,
>>>> # binding the variable you just created above
>>>> cursor.execute("""
>>>> insert into SomeTable (
>>>> SomeOtherColumn
>>>> ) values (
>>>> :someValue
>>>> ) returning Id
>>>> into :id""",
>>>> id =3D idVar,
>>>> someValue =3D "SomeValue")
>>>>
>>>> # get the value after the statement is executed
>>>> id =3D idVar.getvalue()
>>>>
>>>> Hope that explains things.
>>>>
>>>> On 3/22/06, kellie hobbs <kel...@ya...> wrote:
>>>>> Hello,
>>>>>
>>>>> I am trying to get back the id of a record after inserting it
>> into
>>>> the
>>>>> table. My Oracle database has a trigger that automatically
>> creates
>>>> the
>>>>> id on insert. The PL/SQL statement that works for me is:
>>>>> SQL> declare id int;
>>>>> 2 begin
>>>>> 3 insert into table (field) values ('foo') returning tableid
>>>> into
>>>>> id;
>>>>> 4 dbms_output.put_line(id);
>>>>> 5 end;
>>>>> 6 /
>>>>>
>>>>> How can I run this through cx_oracle and get the id stored in a
>>>>> variable so I can use it?
>>>>>
>>>>> Many thanks.
>>>>>
>>>>> Kellie Hobbs, UC Berkeley
>>>>>
>>
>>
>> -------------------------------------------------------
>> This SF.Net email is sponsored by xPML, a groundbreaking scripting
>> language
>> that extends applications into web and mobile media. Attend the live
>> webcast
>> and join the prime developer group breaking into this new coding
>> territory!
>> http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=110944&bid$1720&dat=12164=
2
>> _______________________________________________
>> cx-oracle-users mailing list
>> cx-...@li...
>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>>
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by xPML, a groundbreaking scripting =20
> language
> that extends applications into web and mobile media. Attend the =20
> live webcast
> and join the prime developer group breaking into this new coding =20
> territory!
> http://sel.as-us.falkag.net/sel?=20
> cmd=3Dlnk&kid=3D110944&bid=3D241720&dat=3D121642
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
-------------------------------
Steve Swartzlander
ssw...@ve...
|
|
From: kellie h. <kel...@ya...> - 2006-04-03 21:53:43
|
That was what I was trying to get at.. oh well.
Thanks.
Kellie
--- Anthony Tuininga <ant...@gm...> wrote:
> You require a string like the one in the example. You cannot pass the
> table name and columns to update as bind variables, if that is what
> you are trying to get at. :-)
>
> On 4/3/06, kellie hobbs <kel...@ya...> wrote:
> > Hello,
> >
> > Thanks for your help so far. Now can you tell me how to pass the
> table
> > name and columns to be updated to the execute statement?
> >
> > Thanks again.
> >
> > Kellie Hobbs
> >
> > --- Anthony Tuininga <ant...@gm...> wrote:
> >
> > > Sure. Its quite straightforward but not covered by the DB API.
> > >
> > > # this creates the bind variable for use by Oracle
> > > idVar = cursor.var(cx_Oracle.NUMBER)
> > >
> > > # execute the statement exactly as you normally would,
> > > # binding the variable you just created above
> > > cursor.execute("""
> > > insert into SomeTable (
> > > SomeOtherColumn
> > > ) values (
> > > :someValue
> > > ) returning Id
> > > into :id""",
> > > id = idVar,
> > > someValue = "SomeValue")
> > >
> > > # get the value after the statement is executed
> > > id = idVar.getvalue()
> > >
> > > Hope that explains things.
> > >
> > > On 3/22/06, kellie hobbs <kel...@ya...> wrote:
> > > > Hello,
> > > >
> > > > I am trying to get back the id of a record after inserting it
> into
> > > the
> > > > table. My Oracle database has a trigger that automatically
> creates
> > > the
> > > > id on insert. The PL/SQL statement that works for me is:
> > > > SQL> declare id int;
> > > > 2 begin
> > > > 3 insert into table (field) values ('foo') returning tableid
> > > into
> > > > id;
> > > > 4 dbms_output.put_line(id);
> > > > 5 end;
> > > > 6 /
> > > >
> > > > How can I run this through cx_oracle and get the id stored in a
> > > > variable so I can use it?
> > > >
> > > > Many thanks.
> > > >
> > > > Kellie Hobbs, UC Berkeley
> > > >
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by xPML, a groundbreaking scripting
> language
> that extends applications into web and mobile media. Attend the live
> webcast
> and join the prime developer group breaking into this new coding
> territory!
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
|
|
From: Anthony T. <ant...@gm...> - 2006-04-03 21:43:49
|
You require a string like the one in the example. You cannot pass the
table name and columns to update as bind variables, if that is what
you are trying to get at. :-)
On 4/3/06, kellie hobbs <kel...@ya...> wrote:
> Hello,
>
> Thanks for your help so far. Now can you tell me how to pass the table
> name and columns to be updated to the execute statement?
>
> Thanks again.
>
> Kellie Hobbs
>
> --- Anthony Tuininga <ant...@gm...> wrote:
>
> > Sure. Its quite straightforward but not covered by the DB API.
> >
> > # this creates the bind variable for use by Oracle
> > idVar =3D cursor.var(cx_Oracle.NUMBER)
> >
> > # execute the statement exactly as you normally would,
> > # binding the variable you just created above
> > cursor.execute("""
> > insert into SomeTable (
> > SomeOtherColumn
> > ) values (
> > :someValue
> > ) returning Id
> > into :id""",
> > id =3D idVar,
> > someValue =3D "SomeValue")
> >
> > # get the value after the statement is executed
> > id =3D idVar.getvalue()
> >
> > Hope that explains things.
> >
> > On 3/22/06, kellie hobbs <kel...@ya...> wrote:
> > > Hello,
> > >
> > > I am trying to get back the id of a record after inserting it into
> > the
> > > table. My Oracle database has a trigger that automatically creates
> > the
> > > id on insert. The PL/SQL statement that works for me is:
> > > SQL> declare id int;
> > > 2 begin
> > > 3 insert into table (field) values ('foo') returning tableid
> > into
> > > id;
> > > 4 dbms_output.put_line(id);
> > > 5 end;
> > > 6 /
> > >
> > > How can I run this through cx_oracle and get the id stored in a
> > > variable so I can use it?
> > >
> > > Many thanks.
> > >
> > > Kellie Hobbs, UC Berkeley
> > >
|
|
From: kellie h. <kel...@ya...> - 2006-04-03 21:07:31
|
Hello,
Thanks for your help so far. Now can you tell me how to pass the table
name and columns to be updated to the execute statement?
Thanks again.
Kellie Hobbs
--- Anthony Tuininga <ant...@gm...> wrote:
> Sure. Its quite straightforward but not covered by the DB API.
>
> # this creates the bind variable for use by Oracle
> idVar = cursor.var(cx_Oracle.NUMBER)
>
> # execute the statement exactly as you normally would,
> # binding the variable you just created above
> cursor.execute("""
> insert into SomeTable (
> SomeOtherColumn
> ) values (
> :someValue
> ) returning Id
> into :id""",
> id = idVar,
> someValue = "SomeValue")
>
> # get the value after the statement is executed
> id = idVar.getvalue()
>
> Hope that explains things.
>
> On 3/22/06, kellie hobbs <kel...@ya...> wrote:
> > Hello,
> >
> > I am trying to get back the id of a record after inserting it into
> the
> > table. My Oracle database has a trigger that automatically creates
> the
> > id on insert. The PL/SQL statement that works for me is:
> > SQL> declare id int;
> > 2 begin
> > 3 insert into table (field) values ('foo') returning tableid
> into
> > id;
> > 4 dbms_output.put_line(id);
> > 5 end;
> > 6 /
> >
> > How can I run this through cx_oracle and get the id stored in a
> > variable so I can use it?
> >
> > Many thanks.
> >
> > Kellie Hobbs, UC Berkeley
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Tired of spam? Yahoo! Mail has the best spam protection around
> > http://mail.yahoo.com
> >
> >
> > -------------------------------------------------------
> > This SF.Net email is sponsored by xPML, a groundbreaking scripting
> language
> > that extends applications into web and mobile media. Attend the
> live webcast
> > and join the prime developer group breaking into this new coding
> territory!
> >
>
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
> > _______________________________________________
> > cx-oracle-users mailing list
> > cx-...@li...
> > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
> >
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by xPML, a groundbreaking scripting
> language
> that extends applications into web and mobile media. Attend the live
> webcast
> and join the prime developer group breaking into this new coding
> territory!
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
|