I did your solution. I created a varray like this: TYPE LIST_IDS IS TABLE OF
INT INDEX BY BINARY_INTEGER, but when I try to use in a sql statement SELECT
appears an oracle error cannot access row in nested table. I use oracle 11g and
I read that you can use a varray declare in plsql to sql state
I did your solution. I created a varray like this: TYPE LIST_IDS IS TABLE OF
INT INDEX BY BINARY_INTEGER, but when I try to use in a sql statement SELECT
appears an oracle error cannot access row in nested table. I use oracle 11g and
I read that you can use a varray declare in plsql to sql state
On Fri, Jan 9, 2015 at 12:24 PM, Dom wrote:
> Hi
>
> I'm trying to return a simple array of numbers from a package using cx_oracle
> (5.1.2). I believe this is possible. I've not been able to find anything that
> suggest it isn't
I'm afraid I don't have an answer for you, but you would probably
In Dom
writes:
> create or replace PACKAGE SIMPLEPACKAGE
> AS
> FUNCTION DoSomethingSimple(
> cust_id INTEGER)
> RETURN numarray;
> FUNCTION DoSomethingSimpler(
> cust_id INTEGER)
> RETURN INTEGER;
> END SIMPLEPACKAGE;
> /
> Any ideas what I'm doing wrong?
Is RETURN IN
On Tue, Nov 26, 2013 at 7:22 AM, Ruben van den Berg
wrote:
> I haven't the slightest clue why version 11 just - wouldn't - run but due to
> backward compatibility it seems a stressful weekend got a happy ending anyway.
Doesn't make particular sense to me either, but I don't know anything
about O
>
> On Sun, 11/24/13, MRAB wrote:
>
>
>
> Subject: Re: cx_Oracle throws: ImportError: DLL load failed: This
> application has failed to start ...
>
> To: python-list@python.org
>
> Date: Sunday, November 24, 2013, 7:17 PM
>
>
>
> On 24/11/201
On Sun, 11/24/13, MRAB wrote:
Subject: Re: cx_Oracle throws: ImportError: DLL load failed: This application
has failed to start ...
To: python-list@python.org
Date: Sunday, November 24, 2013, 7:17 PM
On 24/11/2013 17:12, Ruben van den
Berg
On 24/11/2013 17:12, Ruben van den Berg wrote:
I'm on Windows XP SP3, Python 2.7.1. On running
import cx_Oracle
I got the error
ImportError: DLL load failed: This application has failed to start because the
application configuration is incorrect. Reinstalling the application may fix
this pro
On Mon, Nov 25, 2013 at 4:12 AM, Ruben van den Berg
wrote:
> ImportError: DLL load failed: This application has failed to start because
> the application configuration is incorrect. Reinstalling the application may
> fix this problem.
>
> I then ran Dependency Walker on cx_Oracle.pyd. Its first
Il giorno martedì 16 ottobre 2012 19:23:22 UTC+2, Hans Mulder ha scritto:
> On 16/10/12 15:41:58, Beppe wrote:
>
> > Hi all,
>
> > I don't know if it is the correct place to set this question, however,
>
> > I'm using cx_Oracle to query an Oracle database.
>
> > I've a problem to use the IN cla
On 16/10/12 15:41:58, Beppe wrote:
> Hi all,
> I don't know if it is the correct place to set this question, however,
> I'm using cx_Oracle to query an Oracle database.
> I've a problem to use the IN clause with a variable.
> My statement is
>
> sql = "SELECT field1,field2,field3
> FROM m
On Tue, Oct 16, 2012 at 7:41 AM, Beppe wrote:
> Hi all,
> I don't know if it is the correct place to set this question, however,
The best place to ask questions about cx_Oracle would be the
cx-oracle-users mailing list.
> what is wrong?
> suggestions?
With the bind parameter you're only passing
tormod wrote:
On Aug 12, 12:30 pm, Alexander Gattin wrote:
Does Windows have anything like LD_LIBRARY_PATH/SHLIB_PATH?
Yes and no. Windows uses PATH both for finding execuables and for
finding DLLs. So if there's a DLL Windows cannot find, you need to
add the folder containing that DLL to y
On Aug 12, 12:30 pm, Alexander Gattin wrote:
> Does Windows have anything like
> LD_LIBRARY_PATH/SHLIB_PATH?
No, isn't that only if I have an actual Oracle client installed (not
the instant client)?
But great tip, wasn't exactly the solution, but your question
triggered me to check the Windows e
Hello,
On Wed, Aug 11, 2010 at 02:29:24PM -0700, tormod wrote:
> I've tried countless times to build & install cx_Oracle on Python
> 3.1.2, and failed every time, so I'd like to ask someone for help.
...
> I've opened the cx_Oracle.pyd with Dependency Walker (http://
> www.dependencywalker.com/) a
On Sep 15, 9:45 am, Squid wrote:
> It's time for another round of "stump-the-geek". (thats what we call
> it in my office)
>
> If actual code is needed I can provide but lets start off small for
> this one...
>
> I've got a Python script that uses cx_Oracle to access an Oracle DB.
> running the sc
cwurld wrote:
Hi,
I am having some trouble getting cx_Oracle to work. When I try to
import cx_Oracle, I get the following error message:
ImportError: DLL load failed: %1 is not a valid Win32 application.
I am using Python 2.6 on WIndows. Oracle Client 10g.
Any ideas?
Thanks
Hmm some time a
On Feb 12, 9:31 am, redbaron wrote:
> > ImportError: dlopen(/Library/Frameworks/Python.framework/Versions/2.6/
> > lib/python2.6/site-packages/cx_Oracle.so, 2): Symbol not found:
> > ___divdi3
>
> You didn't link cx_Oracle.so all libs which it use. run "ldd -r
> cx_Oracle.so" and you'll have an id
> ImportError: dlopen(/Library/Frameworks/Python.framework/Versions/2.6/
> lib/python2.6/site-packages/cx_Oracle.so, 2): Symbol not found:
> ___divdi3
You didn't link cx_Oracle.so all libs which it use. run "ldd -r
cx_Oracle.so" and you'll have an idea about all missing symbols. The
names of misse
On Dec 18 2008, 10:34 am, huw_at1 wrote:
> On Dec 16, 12:17 pm, huw_at1 wrote:
>
>
>
> > On Dec 15, 12:59 pm, "ron.re...@gmail.com"
> > wrote:
>
> > > On Dec 15, 2:44 am, huw_at1 wrote:
>
> > > > On Dec 11, 5:34 pm, "ron.re...@gmail.com" wrote:
>
> > > > > On Dec 10, 9:48 am, huw_at1 wrote:
>
On Dec 16, 12:17 pm, huw_at1 wrote:
> On Dec 15, 12:59 pm, "ron.re...@gmail.com"
> wrote:
>
>
>
> > On Dec 15, 2:44 am, huw_at1 wrote:
>
> > > On Dec 11, 5:34 pm, "ron.re...@gmail.com" wrote:
>
> > > > On Dec 10, 9:48 am, huw_at1 wrote:
>
> > > > > Hey all. When usingcx_Oracleto run a procedur
On Dec 15, 12:59 pm, "ron.re...@gmail.com"
wrote:
> On Dec 15, 2:44 am, huw_at1 wrote:
>
>
>
> > On Dec 11, 5:34 pm, "ron.re...@gmail.com" wrote:
>
> > > On Dec 10, 9:48 am, huw_at1 wrote:
>
> > > > Hey all. When usingcx_Oracleto run a procedure like:
>
> > > > cursor.execute("select (obj.funct
On Dec 15, 12:59 pm, "ron.re...@gmail.com"
wrote:
> On Dec 15, 2:44 am, huw_at1 wrote:
>
>
>
> > On Dec 11, 5:34 pm, "ron.re...@gmail.com" wrote:
>
> > > On Dec 10, 9:48 am, huw_at1 wrote:
>
> > > > Hey all. When usingcx_Oracleto run a procedure like:
>
> > > > cursor.execute("select (obj.funct
On Dec 15, 2:44 am, huw_at1 wrote:
> On Dec 11, 5:34 pm, "ron.re...@gmail.com" wrote:
>
>
>
>
>
> > On Dec 10, 9:48 am, huw_at1 wrote:
>
> > > Hey all. When usingcx_Oracleto run a procedure like:
>
> > > cursor.execute("select (obj.function(value)) from table where
> > > id=blah")
>
> > > I am g
huw_at1 writes:
>> > ORA-06502: PL/SQL: numeric or value error: character string buffer too
>> > small ORA-06512: at line 1
>>
>> This error is a problem with the PL/SQL, not cx_Oracle. You need to
>> debug obj.function to see what kind of data is being accessed and then
>> a data analysis of th
On Dec 11, 5:34 pm, "ron.re...@gmail.com" wrote:
> On Dec 10, 9:48 am, huw_at1 wrote:
>
>
>
> > Hey all. When using cx_Oracle to run a procedure like:
>
> > cursor.execute("select (obj.function(value)) from table where
> > id=blah")
>
> > I am getting the following error:
>
> > ORA-06502: PL/SQL:
On Dec 10, 9:48 am, huw_at1 <[EMAIL PROTECTED]> wrote:
> Hey all. When using cx_Oracle to run a procedure like:
>
> cursor.execute("select (obj.function(value)) from table where
> id=blah")
>
> I am getting the following error:
>
> ORA-06502: PL/SQL: numeric or value error: character string buffer
On Thu, Dec 11, 2008 at 2:48 AM, huw_at1 <[EMAIL PROTECTED]> wrote:
> Any tips - i have never seen this error before but am guessing that
> the value being returned is too big for the buffer size set for the
> cursor. the procedure fetches data from a LOB.
>
> Any suggestions/confirmations?
Could
gaius hammond Wrote:
>Hi all,
>
>
>I am having a very strange problem with cx_Oracle, has anyone
>seen this kind of behavior before:
>
>
>
>ActivePython 2.5.2.2 (ActiveState Software Inc.) based on
>Python 2.5.2 (r252:60911, Mar 27 2008, 18:53:24) [C] on sunos5
>Type "help", "copyright", "credits"
Thanks Jerry and Diez. The first two replies I found answered my noob
question.
"Jerry Hill" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> On Wed, Mar 19, 2008 at 11:03 AM, Poppy <[EMAIL PROTECTED]>
> wrote:
>> I've been working on the code below and and executes silently, no
>
Poppy wrote:
> I've been working on the code below and and executes silently, no
> complaints, however the end result should be a record in my table and it's
> not added. The procedure works with the passed credentials using SQLPlus
> or SQL Developer clients. However I'm not sure if I'm construct
On Wed, Mar 19, 2008 at 11:03 AM, Poppy <[EMAIL PROTECTED]> wrote:
> I've been working on the code below and and executes silently, no
> complaints, however the end result should be a record in my table and it's
> not added. The procedure works with the passed credentials using SQLPlus or
> SQL
On 3 Gru, 19:07, Ian Clark <[EMAIL PROTECTED]> wrote:
> [EMAIL PROTECTED] wrote:
> > Hello,
>
> > I'm trying to pass array as an argument into PL/SQL procedure.
> > According to cursor manual (http://cx-oracle.sourceforge.net/html/
> > cursorobj.html) arrayvar() should be use to do it. I've created
On 3 Gru, 19:07, Ian Clark <[EMAIL PROTECTED]> wrote:
> [EMAIL PROTECTED] wrote:
> > Hello,
>
> > I'm trying to pass array as an argument into PL/SQL procedure.
> > According to cursor manual (http://cx-oracle.sourceforge.net/html/
> > cursorobj.html) arrayvar() should be use to do it. I've created
[EMAIL PROTECTED] wrote:
> Hello,
>
> I'm trying to pass array as an argument into PL/SQL procedure.
> According to cursor manual (http://cx-oracle.sourceforge.net/html/
> cursorobj.html) arrayvar() should be use to do it. I've created my
> array type in PL/SQL:
>
> CREATE OR REPLACE TYPE cx_arra
On Nov 14, 2:03 pm, Benjamin Hell <[EMAIL PROTECTED]> wrote:
> It's solved: Because of a local full Oracle DB installation the
> "working" box had the registry key
> HKEY_LOCAL_SYSTEM\SOFTWARE\ORACLE\KEY_OraBD10g_home1\NLS_LANG set to
> "AMERICAN_AMERICA.WE8MSWIN1252". A similar key was missing on
Benjamin Hell wrote:
> On a computer with cx_Oracle version 4.1 (Python 2.4.3, Oracle 10g)
> I can get query results consisting of strings including non-ASCII
> characters, e.g. the code example below outputs "é 0xe9" (which is
> the correct ISO-8859-1 hex code for "é"). On a newer installation
> w
En Tue, 13 Nov 2007 13:37:16 -0300, Benjamin Hell <[EMAIL PROTECTED]>
escribió:
> I have a problem with the cx_Oracle module (Oracle database access):
>
> On a computer with cx_Oracle version 4.1 (Python 2.4.3, Oracle 10g)
> I can get query results consisting of strings including non-ASCII
> cha
Hi Lukas,
you will need a working oracle OCI client middleware before
cx_oracle can talk to your database. The easiest nowadays
is the so-called instant client, which must be available
from the otn.oracle.com site (downloads might require a
free registration). Try to get sql*plus working (the stan
loo ping,
> But it's not what I call a 'clean' solution and I suppose that it must
> exist another way to force the client DB to use UTF8, or another
> solution to get my data.
I share your feeling. I asked a similiar question ~1 year ago; and:
your solution is the only one.
The oracle-libs get
Sorry I have no direct answer for you, but suspect you should
post to the cx_Oracle group. Check the sourceforge project page.
It is also conveniently mirrored at news.gmane.org.
--
http://mail.python.org/mailman/listinfo/python-list
Richard Schulman:
>> cursor.execute("""select mean_eng_txt from mean
>> where mean_id=:arg_1""",arg_1)
Uwe Hoffman:
>cursor.execute("""select mean_eng_txt from mean
>where mean_id=:arg_1""",{"arg_1":arg_1})
R.S.'s error message:
>> Traceback (most recent call
> cursor.execute("""select mean_eng_txt from mean
> where mean_id=:arg_1""",{"arg_1"=arg_1})
Needs quotes of course.
Diez
--
http://mail.python.org/mailman/listinfo/python-list
Richard Schulman schrieb:
> I'm having trouble getting started using Python's cx_Oracle binding to
> Oracle XE. In forthcoming programs, I need to set variables within sql
> statements based on values read in from flat files. But I don't seem
> to be able to get even the following stripped-down tes
Richard Schulman schrieb:
>
> cursor.execute("""select mean_eng_txt from mean
> where mean_id=:arg_1""",arg_1)
cursor.execute("""select mean_eng_txt from mean
where mean_id=:arg_1""",{"arg_1":arg_1})
> Traceback (most recent call last):
>File "oracle_te
Gerhard,
thanks, that
import os
os.environ["NLS_LANG"] = "German_Germany.UTF8"
import cx_Oracle
con = cx_Oracle.connect("me/[EMAIL PROTECTED]")
really helped. At least now the query returns something encoded
differently. I dared not to believe that there is no "direct encoding
change api" withou
Harald Armin Massa wrote:
> Dietz,
>
> thank you for your answer.
>
>>It's called NLS (national language support),
>>and it is like a locale-setting in python/C. I'm too lazy to google right
>
> Sad thing: I allready googled that and had to learn: you CAN definitely
> change some parameters, tha
Dietz,
thank you for your answer.
> It's called NLS (national language support),
>and it is like a locale-setting in python/C. I'm too lazy to google right
Sad thing: I allready googled that and had to learn: you CAN definitely
change some parameters, that is sort order and language for error
me
Harald Armin Massa wrote:
> Hello,
>
> I am looking for a method to convince cx_Oracle and oracle to encode
> it's replies in UTF8.
>
> For the moment I have to...
>
> cn=cx_Oracle.connect("user","password", "database")
> cs=cn.Cursor()
>
> cs.execute("select column1, column2, column3 from ta
On Mon, 2006-02-13 at 13:50, Carsten Haese wrote:
> By using parametrized queries, you don't have to worry about any of the
> supplied values requiring special treatment due to any quotation marks
> or apostrophes that might they might contain.
Add grammar corrections to taste.
-Carsten
--
htt
On Mon, 2006-02-13 at 13:18, MooMaster wrote:
> Lol, that was a copy paste error into the post on my part...but the
> problem has been fixed. Turns out that there was a string.replace call
> somewhere else in the code that replaced all single quotes with empty
> strings, which thus caused the singe
Lol, that was a copy paste error into the post on my part...but the
problem has been fixed. Turns out that there was a string.replace call
somewhere else in the code that replaced all single quotes with empty
strings, which thus caused the singe quotes to disappear! Whoops!
Thanks for the look, th
Looks like a space is missing before VALUES keyword ?
--
http://mail.python.org/mailman/listinfo/python-list
[EMAIL PROTECTED] wrote:
>I downloaded cx_Oracle from
>http://www.cxtools.net/default.aspx?nav=cxorlb and selected the windows
>installer for Oracle 8i, Python 2.4
>
>>From the readme.txt file:
>BINARY INSTALL:
>Place the file cx_Oracle.pyd or cx_Oracle.so anywhere on your Python
>path.
>
>So I tr
Thanks!
On 11/9/05, Gerhard Häring <[EMAIL PROTECTED]> wrote:
> infidel wrote:
> > I have a stored procedure that has a single output parameter. Why do I
> > have to pass it a string big enough to hold the value it is to receive?
> > Why can't I pass an empty string or None?
> > [...]
> > Am I mi
Gerhard Häring wrote:
> You have to use variable objects to the callproc() that will hold the
> output values. This is an example using three VARCHAR output parameters.
Oh boy, one never stops learning... I still thing a single in-out-value
is crying for a function - but in case of several parame
infidel wrote:
> I have a stored procedure that has a single output parameter. Why do I
> have to pass it a string big enough to hold the value it is to receive?
> Why can't I pass an empty string or None?
> [...]
> Am I missing something obvious here?
You have to use variable objects to the call
infidel wrote:
> I have a stored procedure that has a single output parameter. Why do I
> have to pass it a string big enough to hold the value it is to receive?
> Why can't I pass an empty string or None?
>
>
import cx_Oracle as oracle
connection = oracle.connect('usr/[EMAIL PROTECTED]
> Apart from that: what harm does the connection to the smpt do? If it
> works - keep it that way.
I worry about being banned from the server.
--
damjan
--
http://mail.python.org/mailman/listinfo/python-list
Damjan wrote:
> This is a simplification of the program
>
> c = db.cursor()
> while 1:
> c.execute('select ')
> smtp = SMTP(MAIL_HOST, 25, 'localhost')
> for address, subject, body in c:
> smtp.sendmail()
> smtp.quit()
> time.sleep(60)
>
> now if the select doe
> > I don't understand your problem - if your select doesn't return
> > anything, the fetch* methods on the cursor will tell you if there is any
> > data to expect at all. Additionally there is teh rowcount-property that
> > holds the number of rows the last execute* yielded.
>
> This is a simplif
>> Is there a way to see if the SELECT in cx_Oracle didn't return anything?
>> I want to optimize the situation when the number of selected rows is
>> zero. Is select count(*) the only option, seems inefficient?
>
> I don't understand your problem - if your select doesn't return
> anything, the fe
Damjan wrote:
> Is there a way to see if the SELECT in cx_Oracle didn't return anything?
> I want to optimize the situation when the number of selected rows is zero.
> Is select count(*) the only option, seems inefficient?
I don't understand your problem - if your select doesn't return
anything,
jmdeschamps wrote:
Hello
Having cx_Oracle (an Oracle database connector for Python) used it
here where I teach for the last couple of years, and finding it so
easy to use (and install) I was taken aback when I got an error
message telling me it could not load the DLL (complete message below)
Third
64 matches
Mail list logo
