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

[cx-oracle-users] Oracle Workspace Manager

[Colin W. <col...@op...>]

Hi,

I am wondering whether anyone has previously used cx_oracle to
successfully work with the Workspace Manager in order to load data into
versioned tables.

Thanks in advance,

Colin

Re: [cx-oracle-users] Problem with cx_Oracle 5.0.4 and Unicode support for Oracle 10g

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

On Wed, Sep 22, 2010 at 4:13 PM, Amaury Forgeot d'Arc
<ama...@gm...> wrote:
> Hi,
>
> 2010/9/22 Anthony Tuininga <ant...@gm...>:
>> Based on other bugs that I have seen and some
>> other comments made on and off the list I am thinking that Unicode
>> mode is not worth the trouble and I am thinking of ripping it out
>> completely
>
> Isn't the Unicode mode mandatory for python 3.x?

Yes, indeed at the moment. I am considering simply forcing the
encoding of the unicode objects to the encoding expected by the
setting of NLS_LANG -- that should work well enough and avoid the code
path that doesn't seem to work well on certain platforms. I believe
that bindnames() also segfaults in unicode mode. There was another
problem but that one was resolved in the latest patchset for 11.2.

Anthony

Re: [cx-oracle-users] Problem with cx_Oracle 5.0.4 and Unicode support for Oracle 10g

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

Hi,

2010/9/22 Anthony Tuininga <ant...@gm...>:
> Based on other bugs that I have seen and some
> other comments made on and off the list I am thinking that Unicode
> mode is not worth the trouble and I am thinking of ripping it out
> completely

Isn't the Unicode mode mandatory for python 3.x?

-- 
Amaury Forgeot d'Arc

Re: [cx-oracle-users] Problem with cx_Oracle 5.0.4 and Unicode support for Oracle 10g

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

Anthony ...

Thanks for the quick response.

Irritating (but not surprising) that Oracle is ignoring you -- Oracle
suffers from Not Invented Here syndrome.

In any case, thanks for all of the work putting together cx_Oracle.

- Craig -

On Wed, Sep 22, 2010 at 17:36, Anthony Tuininga
<ant...@gm...>wrote:

> Hi,
>
> I can see that problem myself in certain situations as well -- not
> sure what the problem is but I suspect a bug in Oracle on certain
> platforms. I have asked Oracle about it but have not received any
> information to date. Based on other bugs that I have seen and some
> other comments made on and off the list I am thinking that Unicode
> mode is not worth the trouble and I am thinking of ripping it out
> completely. In the meantime, so long as you can live without metadata
> in unicode the normal mode works fine with unicode data passed in to
> queries. If you want unicode returned, you can use a output type
> converter method -- see the samples for an example. Hope that helps.
>
> Anthony
>
> On Wed, Sep 22, 2010 at 2:58 PM, W. Craig Trader <cra...@gm...>
> wrote:
> > Additional information:
> >
> > When I look at the error context of the exception, the message is:
> >
> > in NumberVar_GetValue(): as string
> >
> > Which implies that the failure is in the call to OCINumberToText() at
> line
> > 535 of NumberVar.c.
> >
> > - Craig -
> >
> > On Wed, Sep 22, 2010 at 14:15, W. Craig Trader <cra...@gm...>
> > wrote:
> >>
> >> I'm trying to use cx_Oracle 5.0.4 on 64-bit RedHat EL 5.5 / CentOS 5.5)
> >> with Python 2.6 and Oracle 10g (client libraries 10.2.0).
> >>
> >> When I build cx_Oracle without Unicode support, it all works as
> expected.
> >> When I build cx_Oracle *with* Unicode support, attempting to use a query
> >> that returns a numeric value (such as):
> >>
> >> con = Connection( ... )
> >> cur = con.cursor()
> >> cur.execute( 'SELECT 1 FROM DUAL' )
> >> rows = cur.fetchall()
> >>
> >>  results in this exception:
> >>
> >> cx_Oracle.DatabaseError: OCI-22061: invalid format text [T
> >>
> >> I've tried the SourceForge RPMs and I've tried installing from the
> source
> >> tar, and the results are consistent -- without Unicode works, with
> Unicode
> >> fails.
> >>
> >> All help will be greatfully appreciated.
> >>
> >> - Craig -
>

Re: [cx-oracle-users] Problem with cx_Oracle 5.0.4 and Unicode support for Oracle 10g

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

Further information:

I checked the documentation for
OCINumberToText()<http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14250/oci18map003.htm#sthref4703>and
it referred me to
TO_NUMBER()<http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/functions191.htm>.
The call to OCINumberToText is passing in g_ShortNumberToStringFormatObj,
which is set to 'TM9'.  When I used sqlplus to run some tests, I discovered
that while Oracle is fine with SELECT TO_NUMBER ( '1' ) FROM DUAL, it
becomes most unhappy when you try SELECT TO_NUMBER( '1', 'TM9' ) FROM DUAL,
responding with ORA-01722: invalid number.  On the other hand, SELECT
TO_CHAR( '1', 'TM9' ) FROM DUAL works just fine.

It would appear that Oracle 10g does NOT like the 'TM9' conversion () for
numbers.

- Craig -

On Wed, Sep 22, 2010 at 16:58, W. Craig Trader <cra...@gm...>wrote:

> Additional information:
>
> When I look at the error context of the exception, the message is:
>
> in NumberVar_GetValue(): as string
>
> Which implies that the failure is in the call to OCINumberToText() at line
> 535 of NumberVar.c.
>
> - Craig -
>
>
> On Wed, Sep 22, 2010 at 14:15, W. Craig Trader <cra...@gm...>wrote:
>
>> I'm trying to use cx_Oracle 5.0.4 on 64-bit RedHat EL 5.5 / CentOS 5.5)
>> with Python 2.6 and Oracle 10g (client libraries 10.2.0).
>>
>> When I build cx_Oracle without Unicode support, it all works as expected.
>> When I build cx_Oracle *with* Unicode support, attempting to use a query
>> that returns a numeric value (such as):
>>
>> con = Connection( ... )
>> cur = con.cursor()
>> cur.execute( 'SELECT 1 FROM DUAL' )
>> rows = cur.fetchall()
>>
>>  results in this exception:
>>
>> cx_Oracle.DatabaseError: OCI-22061: invalid format text [T
>>
>> I've tried the SourceForge RPMs and I've tried installing from the source
>> tar, and the results are consistent -- without Unicode works, with Unicode
>> fails.
>>
>> All help will be greatfully appreciated.
>>
>> - Craig -
>>
>>
>

Re: [cx-oracle-users] Problem with cx_Oracle 5.0.4 and Unicode support for Oracle 10g

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

Hi,

I can see that problem myself in certain situations as well -- not
sure what the problem is but I suspect a bug in Oracle on certain
platforms. I have asked Oracle about it but have not received any
information to date. Based on other bugs that I have seen and some
other comments made on and off the list I am thinking that Unicode
mode is not worth the trouble and I am thinking of ripping it out
completely. In the meantime, so long as you can live without metadata
in unicode the normal mode works fine with unicode data passed in to
queries. If you want unicode returned, you can use a output type
converter method -- see the samples for an example. Hope that helps.

Anthony

On Wed, Sep 22, 2010 at 2:58 PM, W. Craig Trader <cra...@gm...> wrote:
> Additional information:
>
> When I look at the error context of the exception, the message is:
>
> in NumberVar_GetValue(): as string
>
> Which implies that the failure is in the call to OCINumberToText() at line
> 535 of NumberVar.c.
>
> - Craig -
>
> On Wed, Sep 22, 2010 at 14:15, W. Craig Trader <cra...@gm...>
> wrote:
>>
>> I'm trying to use cx_Oracle 5.0.4 on 64-bit RedHat EL 5.5 / CentOS 5.5)
>> with Python 2.6 and Oracle 10g (client libraries 10.2.0).
>>
>> When I build cx_Oracle without Unicode support, it all works as expected.
>> When I build cx_Oracle *with* Unicode support, attempting to use a query
>> that returns a numeric value (such as):
>>
>> con = Connection( ... )
>> cur = con.cursor()
>> cur.execute( 'SELECT 1 FROM DUAL' )
>> rows = cur.fetchall()
>>
>>  results in this exception:
>>
>> cx_Oracle.DatabaseError: OCI-22061: invalid format text [T
>>
>> I've tried the SourceForge RPMs and I've tried installing from the source
>> tar, and the results are consistent -- without Unicode works, with Unicode
>> fails.
>>
>> All help will be greatfully appreciated.
>>
>> - Craig -
>>
>
>
> ------------------------------------------------------------------------------
> Start uncovering the many advantages of virtual appliances
> and start using them to simplify application deployment and
> accelerate your shift to cloud computing.
> http://p.sf.net/sfu/novell-sfdev2dev
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>

Re: [cx-oracle-users] Problem with cx_Oracle 5.0.4 and Unicode support for Oracle 10g

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

Additional information:

When I look at the error context of the exception, the message is:

in NumberVar_GetValue(): as string

Which implies that the failure is in the call to OCINumberToText() at line
535 of NumberVar.c.

- Craig -

On Wed, Sep 22, 2010 at 14:15, W. Craig Trader <cra...@gm...>wrote:

> I'm trying to use cx_Oracle 5.0.4 on 64-bit RedHat EL 5.5 / CentOS 5.5)
> with Python 2.6 and Oracle 10g (client libraries 10.2.0).
>
> When I build cx_Oracle without Unicode support, it all works as expected.
> When I build cx_Oracle *with* Unicode support, attempting to use a query
> that returns a numeric value (such as):
>
> con = Connection( ... )
> cur = con.cursor()
> cur.execute( 'SELECT 1 FROM DUAL' )
> rows = cur.fetchall()
>
>  results in this exception:
>
> cx_Oracle.DatabaseError: OCI-22061: invalid format text [T
>
> I've tried the SourceForge RPMs and I've tried installing from the source
> tar, and the results are consistent -- without Unicode works, with Unicode
> fails.
>
> All help will be greatfully appreciated.
>
> - Craig -
>
>

[cx-oracle-users] Problem with cx_Oracle 5.0.4 and Unicode support for Oracle 10g

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

I'm trying to use cx_Oracle 5.0.4 on 64-bit RedHat EL 5.5 / CentOS 5.5) with
Python 2.6 and Oracle 10g (client libraries 10.2.0).

When I build cx_Oracle without Unicode support, it all works as expected.
When I build cx_Oracle *with* Unicode support, attempting to use a query
that returns a numeric value (such as):

con = Connection( ... )
cur = con.cursor()
cur.execute( 'SELECT 1 FROM DUAL' )
rows = cur.fetchall()

 results in this exception:

cx_Oracle.DatabaseError: OCI-22061: invalid format text [T

I've tried the SourceForge RPMs and I've tried installing from the source
tar, and the results are consistent -- without Unicode works, with Unicode
fails.

All help will be greatfully appreciated.

- Craig -

Re: [cx-oracle-users] BULK Insert ?

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

Hi,
2010/9/21 Robert <web...@gm...>:
> Given a result set, does cx_oracle provide a way to "bulk insert" the
> result set rather than what I'm doing below (one-by-one Inserts) ?
>
>
> ssresult_set = sscursor.fetchall()   # This is a pyodbc result set,
> same stucture as that of cx_oracle
>
> if len(ssresult_set) > 0:
>   try:
>      for row in ssresult_set:
>          oracursor2.execute('''insert into ........snip......''', row)

Of course! use executemany():

if len(ssresult_set) > 0:
    oracursor2.executemany('''insert into ........snip......''', ssresult_set)

-- 
Amaury Forgeot d'Arc

[cx-oracle-users] BULK Insert ?

[Robert <web...@gm...>]

Given a result set, does cx_oracle provide a way to "bulk insert" the
result set rather than what I'm doing below (one-by-one Inserts) ?


ssresult_set = sscursor.fetchall()   # This is a pyodbc result set,
same stucture as that of cx_oracle

if len(ssresult_set) > 0:
   try:
      for row in ssresult_set:
          oracursor2.execute('''insert into ........snip......''', row)

[cx-oracle-users] solve:hp-ux1131, python3, install cx_oracle successful, import fail, please close thread

[钻. <dia...@16...>]

	I am very sorry for my mindlessness, after read setup.py I find "on HP-UX Itanium with Oracle 10g you need to add the library "ttsh10",
update line 167 add ttsh10 in libs array(libs = ["clntsh", "ttsh10"]), and update TestEnv, replace word "raw_input(" to "input(", then import cx_Oracle successful,
and my code run well on hp-ux, thank you for your help

	I do not konw how to close the thread, so re-mail

Re: [cx-oracle-users] hp-ux1131, python3, install cx_oracle successful, import fail

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

Hi,

I think I understand your issue. Do you have an Oracle client
installed on that machine? Can you use SQL*Plus? Can you run ldd on
cx_Oracle.so and see if there are any missing libraries?

Anthony

2010/9/15 钻石星辰 <dia...@16...>:
> exalted friends:
>
>        Excuse me, my English is not good, wish warmhearted you could read my mail !_!
>
>        I am using python3.1.2 on hp-ux 11.31 U ia64，now want to install cx_Oracle5.0.4 for Oralce10g. On windows platform my code run just well, but it raise exception on hp-ux.
> when use "import cx_Oracle", it report: "Failed to load /usr/local/lib/python3.1/site-packages/cx_Oracle-5.0.4-py3.1-hp-ux-B.11.31-ia64.egg/cx_Oracle.so",
> but cx_Oracle.so is already in folder /usr/local/lib/python3.1/site-packages/cx_Oracle-5.0.4-py3.1-hp-ux-B.11.31-ia64.egg, and with right 755.
>
>    I snap all course(python3_cxoracle5.gif,it is not virus), wish it is useful, very thank you for you reading my mail, ^_^
>
> ------------------------------------------------------------------------------
> Start uncovering the many advantages of virtual appliances
> and start using them to simplify application deployment and
> accelerate your shift to cloud computing.
> http://p.sf.net/sfu/novell-sfdev2dev
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>

[cx-oracle-users] hp-ux1131, python3, install cx_oracle successful, import fail

[钻. <dia...@16...>]

exalted friends: 

	Excuse me, my English is not good, wish warmhearted you could read my mail !_!

	I am using python3.1.2 on hp-ux 11.31 U ia64，now want to install cx_Oracle5.0.4 for Oralce10g. On windows platform my code run just well, but it raise exception on hp-ux.
when use "import cx_Oracle", it report: "Failed to load /usr/local/lib/python3.1/site-packages/cx_Oracle-5.0.4-py3.1-hp-ux-B.11.31-ia64.egg/cx_Oracle.so", 
but cx_Oracle.so is already in folder /usr/local/lib/python3.1/site-packages/cx_Oracle-5.0.4-py3.1-hp-ux-B.11.31-ia64.egg, and with right 755.

    I snap all course(python3_cxoracle5.gif,it is not virus), wish it is useful, very thank you for you reading my mail, ^_^

Re: [cx-oracle-users] newbie question : sqlplus not working but can get cx_oracle to send sql queries

[hari j. <ha...@gm...>]

Thanks Everyone ,

I followed the instructions on stackoverflow posted by Mark Harrison.
The instructions called for putting everything manually into
/usr/include ( all the *.h files ) /usr/lib ( the *.so files ) and
/etc ( the tnsanames.ora).

ANd this then gets the instantclient version 11_1 working.

This brute force approach did get things working..It may be that the
sqlplus binary was not getting the libraries from my LD_LIBARRY_PATH
because putting the *.so containing directory at the start still gave
me the same error.


Thanks for your help
Hari


On Wed, Sep 8, 2010 at 11:19 PM, Anthony Tuininga
<ant...@gm...> wrote:
> On Wed, Sep 8, 2010 at 2:40 PM, hari jayaram <ha...@gm...> wrote:
>> I didnt send the follow up email to the list ..but here is the setup.
>>
>> I have the following set to the directory that has the *.so files
>>
>> export LD_LIBRARY_PATH="$LD_LIBRARY_PATH:/home/hari/instantclient/instantclient_11_1"
>> export PATH="$PATH:/home/hari/instantclient/instantclient_11_1"
>> export SQLPATH="/home/hari/instantclient/instantclient_11_1"
>> export ORACLE_HOME="/home/hari/instantclient/instantclient_11_1"
>
> I am using the instant client RPM so it lays things out a little
> differently. Specifically, I have folders like this
>
> /usr/lib/oracle/11.2/client/bin
> /usr/lib/oracle/11.2/client/lib
>
> It also adds the file
>
> /etc/ld/so.conf.d/oracle-instantclient11.2.conf
>
> which sets the library loader path automatically. What that tells me,
> though, is that you should NOT set ORACLE_HOME. Its also possible that
> you have another installation of Oracle somewhere in the PATH or
> LD_LIBRARY_PATH that is conflicting. Make sure the one you want is
> FIRST in the path -- from the above you are setting them as the LAST
> item which means anything already set there is going to cause
> problems. Take a look at those values and see what is in there
> already.
>
>> I was wondering if it is trivial to compile cx_oracle to run with the
>> 10_1 client libraries, so I can have a homogenoeous system.
>
> It should not be a problem. What problem are you seeing?
>
>> Thanks again..and hoping there is a quick fix
>
> I think so. Just look more carefully at your environment variables. :-)
>
> Anthony
>
> ------------------------------------------------------------------------------
> This SF.net Dev2Dev email is sponsored by:
>
> Show off your parallel programming skills.
> Enter the Intel(R) Threading Challenge 2010.
> http://p.sf.net/sfu/intel-thread-sfd
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>

Re: [cx-oracle-users] newbie question : sqlplus not working but can get cx_oracle to send sql queries

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

On Wed, Sep 8, 2010 at 2:40 PM, hari jayaram <ha...@gm...> wrote:
> I didnt send the follow up email to the list ..but here is the setup.
>
> I have the following set to the directory that has the *.so files
>
> export LD_LIBRARY_PATH="$LD_LIBRARY_PATH:/home/hari/instantclient/instantclient_11_1"
> export PATH="$PATH:/home/hari/instantclient/instantclient_11_1"
> export SQLPATH="/home/hari/instantclient/instantclient_11_1"
> export ORACLE_HOME="/home/hari/instantclient/instantclient_11_1"

I am using the instant client RPM so it lays things out a little
differently. Specifically, I have folders like this

/usr/lib/oracle/11.2/client/bin
/usr/lib/oracle/11.2/client/lib

It also adds the file

/etc/ld/so.conf.d/oracle-instantclient11.2.conf

which sets the library loader path automatically. What that tells me,
though, is that you should NOT set ORACLE_HOME. Its also possible that
you have another installation of Oracle somewhere in the PATH or
LD_LIBRARY_PATH that is conflicting. Make sure the one you want is
FIRST in the path -- from the above you are setting them as the LAST
item which means anything already set there is going to cause
problems. Take a look at those values and see what is in there
already.

> I was wondering if it is trivial to compile cx_oracle to run with the
> 10_1 client libraries, so I can have a homogenoeous system.

It should not be a problem. What problem are you seeing?

> Thanks again..and hoping there is a quick fix

I think so. Just look more carefully at your environment variables. :-)

Anthony

Re: [cx-oracle-users] newbie question : sqlplus not working but can get cx_oracle to send sql queries

[hari j. <ha...@gm...>]

I didnt send the follow up email to the list ..but here is the setup.

I have the following set to the directory that has the *.so files

export LD_LIBRARY_PATH="$LD_LIBRARY_PATH:/home/hari/instantclient/instantclient_11_1"
export PATH="$PATH:/home/hari/instantclient/instantclient_11_1"
export SQLPATH="/home/hari/instantclient/instantclient_11_1"
export ORACLE_HOME="/home/hari/instantclient/instantclient_11_1"

That directory has
~/instantclient/instantclient_11_1$ ls -1
adrci
BASIC_README
genezi
glogin.sql
libclntsh.so.11.1
libnnz11.so
libocci.so.11.1
libociei.so
libocijdbc11.so
libsqlplusic.so
libsqlplus.so
ojdbc5.jar
ojdbc6.jar
sdk
sqlplus
SQLPLUS_README


To compile and install cx_office . I had also symlinked
libclntsh.so.11.1 to  libclntsh.so in the same directory and set the
ORACLE_HOME

I could then sudo setup.py build and , sudo -E setup.py install the
cx_oracle module.

The module works just fine


ON This setup :
:~/instantclient/instantclient_11_1$ ./sqlplus
Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory


It is quite weird. Sometimes it gives the above error and other times
it Segmentation faults
I unset ORACLE_HOME and removed the symlink from  libclntsh.so.11.1 to
 libclntsh.so and I get the same behavior, segfaults or Error 6 with
SP2-0750.

On the same setup with all the environment variables setup to point to
11_1, I can still run the 10_1 version of sql*plus

So this is indeed strange behavior.

I was wondering if it is trivial to compile cx_oracle to run with the
10_1 client libraries, so I can have a homogenoeous system.

Thanks again..and hoping there is a quick fix

Hari

On Wed, Sep 8, 2010 at 4:21 PM, Robert <web...@gm...> wrote:
> This has nothing to do with cx_oracle.
> but if I were you I would also have echo'd those env variables and
> show to the people you're asking for help.
>
>
> On Wed, Sep 8, 2010 at 1:01 PM, hari jayaram <ha...@gm...> wrote:
>> harijar@ubuntuinux64bit:~/instantclient/instantclient_11_1$ ./sqlplus
>> Error 6 initializing SQL*Plus
>> Message file sp1<lang>.msb not found
>> SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
>>
>
> ------------------------------------------------------------------------------
> This SF.net Dev2Dev email is sponsored by:
>
> Show off your parallel programming skills.
> Enter the Intel(R) Threading Challenge 2010.
> http://p.sf.net/sfu/intel-thread-sfd
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>

Re: [cx-oracle-users] newbie question : sqlplus not working but can get cx_oracle to send sql queries

[Robert <web...@gm...>]

This has nothing to do with cx_oracle.
but if I were you I would also have echo'd those env variables and
show to the people you're asking for help.


On Wed, Sep 8, 2010 at 1:01 PM, hari jayaram <ha...@gm...> wrote:
> harijar@ubuntuinux64bit:~/instantclient/instantclient_11_1$ ./sqlplus
> Error 6 initializing SQL*Plus
> Message file sp1<lang>.msb not found
> SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
>

Re: [cx-oracle-users] newbie question : sqlplus not working but can get cx_oracle to send sql queries

[Mark H. <mh...@pi...>]

On 9/8/10 10:01 AM, hari jayaram wrote:
> My question pertains to getting oracle sqlplus to work with the same setup.
> Since its a 64 bit system I do not have Oracle 10g -Express edition
> installed on it. The only thing oracle I have is the 11_1
> instantclient.

Here's a setup that might work:

http://stackoverflow.com/questions/764871/installing-oracle-instantclient-on-linux-without-setting-environment-variables


>

Re: [cx-oracle-users] newbie question : sqlplus not working but can get cx_oracle to send sql queries

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

Hi,

You're welcome for the module. I'm happy to see others making as good
use of it as I already am. :-)

I am not at my Linux box at the moment but I believe you should not
need to set ORACLE_HOME at all when using the instant client. You also
need to set LD_LIBRARY_PATH to the path where the libraries are
actually found. From your description below it looks like you were
setting it to the base directory. Then again, I am using the RPM
package to install the instant client so it may be set up differently.
Rather than bother the mailing list with this, though, please send a
listing of what you have to me personally and I'll look at it tonight
if I get a chance. Also, please list all of the different versions of
Oracle that you have installed on your machine and their locations and
versions. It is most definitely possible to have both SQL*Plus and
cx_Oracle working on the same machine!

Anthony

On Wed, Sep 8, 2010 at 11:01 AM, hari jayaram <ha...@gm...> wrote:
> Hi ,
> First of thanks to Anthony and cxtools/computronix for this excellent
> module. I am using it successfully on windows, connection to a Oracle
> 10g database from 32 bit windows XP running python 2.6.
>
> However I wanted to switch my development environment to Ubuntu Lucid
> 10.04 running in 64 bit mode.
>
> After some effort I could get the cx_Oracle version 5.0.4 to install
> with the oracle 11.1 , 32 bit , i386  instantclient libraries.
> My scripts all work just fine despite the hybrid mode i.e 64 bit
> kernel, python and 32 bit instantclient libraries.
>
> My question pertains to getting oracle sqlplus to work with the same setup.
> Since its a 64 bit system I do not have Oracle 10g -Express edition
> installed on it. The only thing oracle I have is the 11_1
> instantclient.
>
> When I launch sqlplus I get the following error:
>
> harijar@ubuntuinux64bit:~/instantclient/instantclient_11_1$ ./sqlplus
> Error 6 initializing SQL*Plus
> Message file sp1<lang>.msb not found
> SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
>
>
> I do have the ORACLE_HOME and LD_LIBRARY_PATH and SQLPATH and PATH
> pointing to the instantclient/instantclient_11_1 directory.
>
>
> I know this is a cx_Oracle mailing list , but I was hoping that
> someone here knows how to solve this problem.
>
> So my question is how can I have my cake ( cx_oracle with
> instantclient 11_1) and eat it too , i.e use sqlplus that comes with
> version 11_1 on my 64 bit linux box.
> Initially on this same machine , I could get the sqlplus that came
> with instantclient 10_1 to work just fine. But I could not compile
> cx_Oracle to work with 10.1 instantclient libraries . So I switched to
> 11_1
>
> Thanks in advance
>
> Hari
>
> ------------------------------------------------------------------------------
> This SF.net Dev2Dev email is sponsored by:
>
> Show off your parallel programming skills.
> Enter the Intel(R) Threading Challenge 2010.
> http://p.sf.net/sfu/intel-thread-sfd
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>

[cx-oracle-users] newbie question : sqlplus not working but can get cx_oracle to send sql queries

[hari j. <ha...@gm...>]

Hi ,
First of thanks to Anthony and cxtools/computronix for this excellent
module. I am using it successfully on windows, connection to a Oracle
10g database from 32 bit windows XP running python 2.6.

However I wanted to switch my development environment to Ubuntu Lucid
10.04 running in 64 bit mode.

After some effort I could get the cx_Oracle version 5.0.4 to install
with the oracle 11.1 , 32 bit , i386  instantclient libraries.
My scripts all work just fine despite the hybrid mode i.e 64 bit
kernel, python and 32 bit instantclient libraries.

My question pertains to getting oracle sqlplus to work with the same setup.
Since its a 64 bit system I do not have Oracle 10g -Express edition
installed on it. The only thing oracle I have is the 11_1
instantclient.

When I launch sqlplus I get the following error:

harijar@ubuntuinux64bit:~/instantclient/instantclient_11_1$ ./sqlplus
Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory


I do have the ORACLE_HOME and LD_LIBRARY_PATH and SQLPATH and PATH
pointing to the instantclient/instantclient_11_1 directory.


I know this is a cx_Oracle mailing list , but I was hoping that
someone here knows how to solve this problem.

So my question is how can I have my cake ( cx_oracle with
instantclient 11_1) and eat it too , i.e use sqlplus that comes with
version 11_1 on my 64 bit linux box.
Initially on this same machine , I could get the sqlplus that came
with instantclient 10_1 to work just fine. But I could not compile
cx_Oracle to work with 10.1 instantclient libraries . So I switched to
11_1

Thanks in advance

Hari

Re: [cx-oracle-users] DDL prepared problem

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

On Fri, Sep 3, 2010 at 8:39 PM, sky2roy sky2roy <sk...@gm...> wrote:
> cursor.execute() is simple.  and can i change the sql and replace text.

I'm not sure what you mean by changing the SQL and replacing text. You
can call cursor.execute() with different SQL each time without any
problem. If you pass the same SQL then internally less work is done
the second and any subsequent time. If that doesn't explain things,
please ask again.

> but . i just want to know why cx_oracle is not support this? or  my code has
> an error?

This is supported. I was just curious why you were doing what you were
doing since it seemed counterproductive. :-) The error is a rather
generic one that Oracle raises when the parameters do not match the
placeholders. Sometimes they can be difficult to see as Oracle doesn't
bother telling you __which__ placeholder it is having difficulty with!
If you want me to show you exactly the error you are having, send me
everything needed to replicate the code in my own environment and I'll
take a look.

> my problme is cleared.  using cursor.execute ..

Excellent. If you need further help, however, let me know.

Anthony

Re: [cx-oracle-users] DDL prepared problem

[sky2roy s. <sk...@gm...>]

sorry above code has error

code
========================
parameters["std_id"] = "10000"
sql  = " create table copy_student as select * from student where std_id =

%s "
cursor.execute(sql   % parameters["std_id"])
========================

2010/9/4 sky2roy sky2roy <sk...@gm...>

> cursor.execute() is simple.  and can i change the sql and replace text.
>
> but . i just want to know why cx_oracle is not support this? or  my code
> has an error?
>
> other language dao support this...
>
> my problme is cleared.  using cursor.execute ..
>
> thanks.
>
>
> code
> ========================
>  parameters["std_id"] = "10000"
> sql  = " create table copy_student as select * from student where std_id =
> %s "
> cursor.execute(%s  % parameters["std_id"])
> ========================
>
>
>
>
>
> 2010/9/3 Anthony Tuininga <ant...@gm...>
>
> Just curious: why are you using cursor.prepare()? Why not simply use
>> cursor.execute()?
>>
>> On Fri, Sep 3, 2010 at 3:28 AM, sky2roy sky2roy <sk...@gm...>
>> wrote:
>> > hi.
>> >
>> > I am  working with python 2.4 , cx_Oracle-5.0.3
>> >
>> > i am trying to execute ddl sql. but it has an error.
>> >
>> > like this sql.  " create table copy_student as select * from student
>> where
>> > std_id = ?"
>> > not exactly this sql ..... just focus on prepared DDL
>> >
>> > there is sample code and error message.
>> >
>> > sample code
>> > ========================
>> > parameters = {}
>> > parameters["std_id"] = "10000"
>> > sql  = " create table copy_student as select * from student where std_id
>> =
>> > :std_id "
>> > cursor.prepare(sql)
>> > cursor.execute(None, parameters)
>> > ========================
>> >
>> > error message
>> > ================
>> >
>> > DatabaseError: ORA-01036: illegal variable name/number
>> >
>> > =================
>> >
>> > i think prepared DDL sql is not bined. so this is bugs or not suppoert
>> sql?
>> >
>> >
>> >
>> >
>> ------------------------------------------------------------------------------
>> > This SF.net Dev2Dev email is sponsored by:
>> >
>> > Show off your parallel programming skills.
>> > Enter the Intel(R) Threading Challenge 2010.
>> > http://p.sf.net/sfu/intel-thread-sfd
>> > _______________________________________________
>> > cx-oracle-users mailing list
>> > cx-...@li...
>> > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>> >
>> >
>>
>>
>> ------------------------------------------------------------------------------
>> This SF.net Dev2Dev email is sponsored by:
>>
>> Show off your parallel programming skills.
>> Enter the Intel(R) Threading Challenge 2010.
>> http://p.sf.net/sfu/intel-thread-sfd
>> _______________________________________________
>> cx-oracle-users mailing list
>> cx-...@li...
>>  https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>>
>
>

Re: [cx-oracle-users] DDL prepared problem

[sky2roy s. <sk...@gm...>]

cursor.execute() is simple.  and can i change the sql and replace text.

but . i just want to know why cx_oracle is not support this? or  my code has
an error?

other language dao support this...

my problme is cleared.  using cursor.execute ..

thanks.


code
========================
parameters["std_id"] = "10000"
sql  = " create table copy_student as select * from student where std_id =
%s "
cursor.execute(%s  % parameters["std_id"])
========================





2010/9/3 Anthony Tuininga <ant...@gm...>

> Just curious: why are you using cursor.prepare()? Why not simply use
> cursor.execute()?
>
> On Fri, Sep 3, 2010 at 3:28 AM, sky2roy sky2roy <sk...@gm...> wrote:
> > hi.
> >
> > I am  working with python 2.4 , cx_Oracle-5.0.3
> >
> > i am trying to execute ddl sql. but it has an error.
> >
> > like this sql.  " create table copy_student as select * from student
> where
> > std_id = ?"
> > not exactly this sql ..... just focus on prepared DDL
> >
> > there is sample code and error message.
> >
> > sample code
> > ========================
> > parameters = {}
> > parameters["std_id"] = "10000"
> > sql  = " create table copy_student as select * from student where std_id
> =
> > :std_id "
> > cursor.prepare(sql)
> > cursor.execute(None, parameters)
> > ========================
> >
> > error message
> > ================
> >
> > DatabaseError: ORA-01036: illegal variable name/number
> >
> > =================
> >
> > i think prepared DDL sql is not bined. so this is bugs or not suppoert
> sql?
> >
> >
> >
> >
> ------------------------------------------------------------------------------
> > This SF.net Dev2Dev email is sponsored by:
> >
> > Show off your parallel programming skills.
> > Enter the Intel(R) Threading Challenge 2010.
> > http://p.sf.net/sfu/intel-thread-sfd
> > _______________________________________________
> > cx-oracle-users mailing list
> > cx-...@li...
> > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
> >
> >
>
>
> ------------------------------------------------------------------------------
> This SF.net Dev2Dev email is sponsored by:
>
> Show off your parallel programming skills.
> Enter the Intel(R) Threading Challenge 2010.
> http://p.sf.net/sfu/intel-thread-sfd
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
>  https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>

Re: [cx-oracle-users] DDL prepared problem

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

Just curious: why are you using cursor.prepare()? Why not simply use
cursor.execute()?

On Fri, Sep 3, 2010 at 3:28 AM, sky2roy sky2roy <sk...@gm...> wrote:
> hi.
>
> I am  working with python 2.4 , cx_Oracle-5.0.3
>
> i am trying to execute ddl sql. but it has an error.
>
> like this sql.  " create table copy_student as select * from student where
> std_id = ?"
> not exactly this sql ..... just focus on prepared DDL
>
> there is sample code and error message.
>
> sample code
> ========================
> parameters = {}
> parameters["std_id"] = "10000"
> sql  = " create table copy_student as select * from student where std_id =
> :std_id "
> cursor.prepare(sql)
> cursor.execute(None, parameters)
> ========================
>
> error message
> ================
>
> DatabaseError: ORA-01036: illegal variable name/number
>
> =================
>
> i think prepared DDL sql is not bined. so this is bugs or not suppoert sql?
>
>
>
> ------------------------------------------------------------------------------
> This SF.net Dev2Dev email is sponsored by:
>
> Show off your parallel programming skills.
> Enter the Intel(R) Threading Challenge 2010.
> http://p.sf.net/sfu/intel-thread-sfd
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>

[cx-oracle-users] DDL prepared problem

[sky2roy s. <sk...@gm...>]

hi.

I am  working with python 2.4 , cx_Oracle-5.0.3

i am trying to execute ddl sql. but it has an error.

like this sql.  " create table copy_student as select * from student where
std_id = ?"
not exactly this sql ..... just focus on prepared DDL

there is sample code and error message.

sample code
========================
parameters = {}
parameters["std_id"] = "10000"
sql  = " create table copy_student as select * from student where std_id =
:std_id "
cursor.prepare(sql)
cursor.execute(None, parameters)
========================

error message
================

DatabaseError: ORA-01036: illegal variable name/number

=================

i think prepared DDL sql is not bined. so this is bugs or not suppoert sql?