On 2020-10-18 06:35:03 -, Mladen Gogala via Python-list wrote:
> On Sat, 17 Oct 2020 21:23:40 -0600, Jason Friedman wrote:
> >> I'm looking to insert values into an oracle table (my_table) using the
> >> query below. The insert query works when the PROJECT is not NULL/empty
> >> (""). However w
On Sat, 17 Oct 2020 21:23:40 -0600, Jason Friedman wrote:
>> I'm looking to insert values into an oracle table (my_table) using the
>> query below. The insert query works when the PROJECT is not NULL/empty
>> (""). However when PROJECT is an empty string(''), the query creates a
>> new duplicate
>
> I'm looking to insert values into an oracle table (my_table) using the
> query below. The insert query works when the PROJECT is not NULL/empty
> (""). However when PROJECT is an empty string(''), the query creates a new
> duplicate row every time the code is executed (with project value
> popu
Hi there,
I'm looking to insert values into an oracle table (my_table) using the query
below. The insert query works when the PROJECT is not NULL/empty (""). However
when PROJECT is an empty string(''), the query creates a new duplicate row
every time the code is executed (with project value po
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'
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
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
create or replace TYPE NUMARRAY
-- Simple VArray of numbers
is VARRAY(3) OF NUMBER;
/
create or
It seems that when I attempt to download blob or clob data using fetchmany, it
can not keep track of the LOB variable in subsequent fetch. The problem is over
if I fetch one row at a time but it is not optimal. Can anyone give me an idea
how to efficiently fetch columns with clob or blob data fr
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
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
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 problem.
I then ran Dependency Walk
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 datab
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 = "S
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 para
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 my_table
WHERE field_3
s 0x6BD8.
Unloaded "OCI.DLL" at address 0x1000.
LoadLibraryExA("C:\JSTData\Python27\lib\site-packages\cx_Oracle.pyd",
0x, LOAD_WITH_ALTERED_SEARCH_PATH) returned NULL. Error: The
specified procedure could not be found (127).
Why is cx_Oracle not found after it has
On Tue, Jan 4, 2011 at 12:57 PM, Mauricio Martinez Garcia
wrote:
>
> Hi, i need help with the next error:
>
> "ERR_PYTHON:Oracle-Error-Message: ORA-01036: illegal variable name/number",
> i used the cx_Oracle module, and the error not is only Oracle Error.
>
> The
Hi, i need help with the next error:
"ERR_PYTHON:Oracle-Error-Message: ORA-01036: illegal variable
name/number", i used the cx_Oracle module, and the error not is only
Oracle Error.
The error its for that python don't translate the query, with the
variables ":VARIABLE&q
;
> In one of my program file I had to use the module "cx_Oracle".For that
> I have installed the module in my windows machine and done the
> programming. But the finished program does not run in Solaris machine,
> may be because "cx_Oracle" was not installed ther
Hi,
>From last months I am using Python for making small but useful tools
for my team members. I am doing my development in windows machine and
running the program in Solaris machine where Python 2.6.2 is
installed.
In one of my program file I had to use the module "cx_Oracle".Fo
including libttsh11 fixed the problem. Thank you!
Now I can get on with fixing everything that Python 3 broke... err changed.
:)
--
Cliff
On Sat, Aug 28, 2010 at 11:20 AM, Alexander Gattin wrote:
> Hello,
>
> On Sat, Aug 28, 2010 at 09:27:05AM -0400, Cliff
> Martin wrote:
> > Yes, our entire
Hello,
On Sat, Aug 28, 2010 at 09:27:05AM -0400, Cliff
Martin wrote:
> Yes, our entire toolchain is 64 bit - a mix of
> stuff I have downloaded and built and some
> packages from HP (in the form of depot files)
> GCC was downloaded from HP, for example.
I see. I bootstrapped from bundled cc, henc
ug 28, 2010 at 9:11 AM, Alexander Gattin wrote:
> Hello,
>
> On Thu, Aug 26, 2010 at 08:08:42PM -0700, Cliff
> Martin wrote:
> > I have just gotten done building Python 3.1.2 on
> > HPUX 11.31 Itanium (IA64) using gcc 4.4.3, and
> > have tried building cx_Oracle to
Hello,
On Thu, Aug 26, 2010 at 08:08:42PM -0700, Cliff
Martin wrote:
> I have just gotten done building Python 3.1.2 on
> HPUX 11.31 Itanium (IA64) using gcc 4.4.3, and
> have tried building cx_Oracle to go with it. The
> build succeeds, but test and importing does not.
> I have
I have just gotten done building Python 3.1.2 on HPUX 11.31 Itanium
(IA64) using gcc 4.4.3, and have tried building cx_Oracle to go with
it. The build succeeds, but test and importing does not. I have tried
building Python with threads and without. The only exotic thing I do
with the configure for
LL to your PATH variable.
No, isn't that only if I have an actual Oracle client installed (not
the instant client)?
Whether you use the instant client or an actual Oracle client is not
the issue. You may or may not need LD_LIBRARY_PATH either way.
When you import cx_Oracle on Linux, it lo
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:/
Hi,
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 included step-by-step (literally) description of my last try,
with so much detail I could, to help clarify things.
I can build wi
Hi Jim,
Jim Qiu wrote:
I make installed python 2.7 from source, and also installed the RPM
version of cx_Oracle for python 2.7.
But ldd tells me :
#ldd cx_Oracle.so
libpython2.7.so.1.0 => not found
I find out that only libpython2.7.a generated when I install
python
Hi Jim,
Jim Qiu wrote:
[...]
I find out that only libpython2.7.a generated when I install
python2.7, who can tell me what I need to do ? I want a
libpython2.7.so.1.0 generated when
I've didn't read your complete mail... In addition to the steps I've
described in my other mail, you need to
> I make installed python 2.7 from source, and also installed the RPM version
> of cx_Oracle for python 2.7.
>
> But ldd tells me :
> #ldd cx_Oracle.so
> libpython2.7.so.1.0 => not found
>
> I find out that only libpython2.7.a generated when I instal
Hi all,
I make installed python 2.7 from source, and also installed the RPM version
of cx_Oracle for python 2.7.
But ldd tells me :
#ldd cx_Oracle.so
libpython2.7.so.1.0 => not found
I find out that only libpython2.7.a generated when I install python2.7, who
can tell
On Mon, 19 Jul 2010 09:12:20 -0700, li wang wrote:
> It's quite weird when I import cx_Oracle in python interactive shell, it
> works perfectly.
> but when I import cx_Oracle in a *,py script, handled by
> mod_python.publisher, it keep reportint :
>
> ImportError: libclnt
It's quite weird when I import cx_Oracle in python interactive shell,
it works perfectly.
but when I import cx_Oracle in a *,py script, handled by
mod_python.publisher, it keep reportint :
ImportError: libclntsh.so.10.1: cannot open shared object file: No
such file or directory
Can I anyone
On Nov 19, 6:57 pm, Neil Hodgson
wrote:
> André:
>
> > Apparently the error is caused by cx_Oracle not being able to find the
> > Oracle client DLLs (oci.dll and others). The client home path and the
> > client home path bin directory are in the PATH System Variable
André:
> Apparently the error is caused by cx_Oracle not being able to find the
> Oracle client DLLs (oci.dll and others). The client home path and the
> client home path bin directory are in the PATH System Variable and
> oci.dll is there.
Open the cx_Oracle extension with Depen
Hello,
I'm trying to get Python 3.1 and cx_Oracle 5.02
(cx_Oracle-5.0.2-10g.win32-py3.0.msi) to connect to an Oracle
11.1.0.7.0 database via OraClient10g 10.2.0.3.0 with Pydev
1.5.1.1258496115 in Eclipse 20090920-1017 on Windows XP SP 3 v2002.
The import cx_Oracle line appears as an unres
Hi,
I am trying to use cx_Oracle and SQLAlchemy with Oracle 11gR1 (11.1)
on Windows Vista 64 bit.
When I import cx_Oracle, I get this error:
>>> import cx_Oracle
Traceback (most recent call last):
File "", line 1, in
ImportError: DLL load failed: %1 is not a valid Win32 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_Ora
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 script from command line runs
On 28 Lip, 20:02, Vincent Vega wrote:
> Hi,
>
> I call function in Oracle database use cx_Oracle.
> In standard I define:
>
> db = cx_Oracle.connect(username, password, tnsentry)
> cursor = db.cursor()
>
> I create variable 'y' (result function
Hi,
I call function in Oracle database use cx_Oracle.
In standard I define:
db = cx_Oracle.connect(username, password, tnsentry)
cursor = db.cursor()
I create variable 'y' (result function 'fun_name') and call function
'fun_name':
y = cursor.var(c
On Jul 16, 12:18 pm, Vincent wrote:
> hi, all:
>
> i am using cx_oracle now.
>
> i write code as below:
>
> def __getfields_by_tbname(self,tbname):
> cursor = self.ora_db.cursor()
> print tbname
> sql = 'select * from %s where rownu
hi, all:
i am using cx_oracle now.
i write code as below:
def __getfields_by_tbname(self,tbname):
cursor = self.ora_db.cursor()
print tbname
sql = 'select * from %s where rownum <=2' % tbname
print sql
cursor = cursor.execute(sql)
Hello everyone,
1. I installed Oracle client on my linux x86_64 machine.
2. Set oracle home and LD_LIBRARY_PATH
3. Installed cx_oracle using rpm for python 2.5
-> It's installed and the following file exists:
/usr/local/lib/python2.5/site-packages/cx_Oracle.so
-> When I run python
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
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
--
http://mail.python.org
En Tue, 03 Mar 2009 15:23:38 -0200, Loredana
escribió:
I try this code and it works:
curs.execute(sqlstr)
for rows in curs:
for col in rows:
try:
print col.read()
except:
print col
onother q
; >> Lory
>
> > Hi all,
> > I success to read one row with the following code:
>
> > curs.execute(sqlstr)
> > name_of_columns = []
> > for fieldDesc in curs.description:
> > name_of_columns.append(fieldDe
except:
print "except. ",rows_
but if I try with fetchmany() it doesn't work
any ideas?
cx_Oracle implements DBAPI 2.0, then you should follow the general
guidelines in the specification:
http://www.python.org/dev/peps/pep-0249/
LOBs are an extension to
On Mar 3, 1:01 pm, Loredana wrote:
> Hi,
>
> I need to read CLOB field type (it is long text)
>
> if I use this code:
>
> curs.execute(sqlstr)
> rows['name_of_columns'] = name_of_columns
> rows['data'] = curs.fetchall()
>
> it returns me this values:
>
> test = {'na
Hi,
I need to read CLOB field type (it is long text)
if I use this code:
curs.execute(sqlstr)
rows['name_of_columns'] = name_of_columns
rows['data'] = curs.fetchall()
it returns me this values:
test = {'name_of_columns': ['FILENAME', 'CRONTIME', 'SHORT_TAIL',
'L
On Feb 24, 2009, at 4:34 PM, Brandon Taylor wrote:
Here's my setup: OS X (10.5.6 - Intel), Oracle Instant Clinet 10_2,
Python 2.6.1, Django trunk
OS X is an important detail here.
In my .bash_profile, I have ORACLE_HOME and LD_LIBRARY_PATH specified
as:
ORACLE_HOME="$HOME/Library/Oracle/inst
quot;$HOME/Library/Oracle/instantclient_10_2"
export ORACLE_HOME
LD_LIBRARY_PATH=$ORACLE_HOME
export LD_LIBRARY_PATH
When I try to compile cx_Oracle-4.4.1 or 5.0.1, I get an error stating
that it cannot find an Oracle installation. setup.py will error here:
# try to determine
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
Hello everyone,
I'm Brandon Taylor, senior web developer with the University of Texas
at Austin. We're using Python 2.6.1 and having a lot of difficulty
getting the cx_Oracle-5.0 library to install on one of our MacBooks
running OS X 10.5.6.
We can get cx_Oracle to compile, but aft
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:
>
va
executable which seemed to execute the SQL query without hitch. My
Java isn't great but from what I could make out it seems that the
query is broken down from:
select (obj.function(value)) from table where id=blah
to:
select value from table where id=blah
obj.function(value)
So make two quer
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 acc
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")
>
>
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
confirmations?
Could you not increase the buffer size ?
I think you can do this with cx_Oracle.
cheers
James
--
--
-- "Problems are solved by method"
--
http://mail.python.org/mailman/listinfo/python-list
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 too
small ORA-06512: at line 1
Looking at cursor.descrip
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
>T
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", "credi
On Aug 25, 1:53 pm, Cousin Stanley <[EMAIL PROTECTED]> wrote:
> >
>
> > def generate_output():
> > print ''
>
> > generate_output()
>
> Raja
>
> You might try adding a Content-type header followed by
> a blank line to your generate_output() function
>
> de
>
>
> def generate_output():
> print ''
>
> generate_output()
Raja
You might try adding a Content-type header followed by
a blank line to your generate_output() function
def generate_output() :
print 'Content-type: text/html'
print
Raja <[EMAIL PROTECTED]> writes:
> The code is working fine on the command line but when executing it
> on the browser i get the famouse "Premature end of script headers"
> error.
Look at the server's error log to see what the real error message is.
You are probably missing an environment variabl
Hi,
I am trying to write a cgi program which would be executed on
browser with Apache server installed.
The program would make a connection to a database using cx_Oracle
module and display results on page.
The code is working fine on the command line but when executing it on
the browser i
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
>
er I'm not sure if I'm constructing my
> python code correctly to interact with Oracle.
>
> I've been basing the code below on what I found in this thread
> http://www.thescripts.com/forum/thread33728.html .
>
> Zach-
>
> import cx_Oracle
>
> connect
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
nstructing my python
code correctly to interact with Oracle.
I've been basing the code below on what I found in this thread
http://www.thescripts.com/forum/thread33728.html .
Zach-
import cx_Oracle
connection = cx_Oracle.connect("user/[EMAIL PROTECTED]")
## PROCEDURE rptmgr.rep_util
On Jan 2, 2:01 pm, [EMAIL PROTECTED] wrote:
> Hello,
>
> Does anyone have experience using cx_Oracle to call a stored procedure
> that inserts to a clob field? We have done this successfully via
> straight SQL, but we are at a loss on how to do the same insert using
> a sto
Hello,
Does anyone have experience using cx_Oracle to call a stored procedure
that inserts to a clob field? We have done this successfully via
straight SQL, but we are at a loss on how to do the same insert using
a stored procedure call. Any assistance would be much appreciated.
Thanks.
Jason
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
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_array_string is table of varchar2(200);
and
WIN1252". A similar key was missing on the
> other box. I added HKEY_LOCAL_SYSTEM\SOFTWARE\ORACLE\NLS_LANG with
> the same value and now it works.
You could use environment variable NLS_LANG to set it at run time
with:
os.environ["NLS_LANG"] = "AMERICAN_AMERICA.WE8MSWIN
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 "é
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 i
Hi!
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
characters, e.g. the code example below outputs "é 0xe9" (which is
the correct
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
Hi,
I want to get an access to an oracle database.
For that I found the module cx_oracle
(http://www.python.net/crew/atuining/cx_Oracle/) and
I have installed the version 'Windows Installer (Oracle 10g, Python 2.5)'.
Now I tried to run the script in the r
Doug Phillips wrote:
>> It also works the other way around, at least on the non-empty
>> set of systems that contains my workstation. export simply
>> marks the variable name for automatic export to the
>> environment of subsequent commands. The value at that time
>> doesn't matter. What matter
> It also works the other way around, at least on the non-empty
> set of systems that contains my workstation. export simply
> marks the variable name for automatic export to the
> environment of subsequent commands. The value at that time
> doesn't matter. What matters is the value that the na
On Thu, 2007-05-24 at 16:15 +, Dennis Lee Bieber wrote:
> On Thu, 24 May 2007 09:07:07 -0500, Carl K <[EMAIL PROTECTED]>
> declaimed the following in comp.lang.python:
>
> > Getting closer, thanks Bill and Diez.
> >
> > $ export ORACLE_HOME
> > $ ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/prod
Dennis Lee Bieber wrote:
> On Thu, 24 May 2007 09:07:07 -0500, Carl K <[EMAIL PROTECTED]>
> declaimed the following in comp.lang.python:
>
>> Getting closer, thanks Bill and Diez.
>>
>> $ export ORACLE_HOME
>> $ ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/client
>
> Don't those
Dennis Lee Bieber wrote:
> On Thu, 24 May 2007 09:07:07 -0500, Carl K <[EMAIL PROTECTED]>
> declaimed the following in comp.lang.python:
>
>> Getting closer, thanks Bill and Diez.
>>
>> $ export ORACLE_HOME
>> $ ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/client
>
> Don't those
1 - 100 of 190 matches
Mail list logo
