cx-oracle-users

Re: [cx-oracle-users] alter table

[<ama...@ub...>]

Caleb Groom wrote:
> Should cx-oracle be able to handle sending 'alter table' statements to
> Oracle?
>
> I'm replacing a SQL*Plus session that is truncating table partitions and
> it seems to have no effect.  I'm using the same username and password as
> the SQL*Plus session.  No exceptions are raised, no errors.

It seems to work without any problem.
I tried this:

 >>> from cx_Oracle import *
 >>> cnx = connect(user,password)
 >>> cur = cnx.cursor()
 >>> cur.execute("ALTER TABLE myTable ADD newCol NUMBER")
(ok)
 >>> cur.execute("ALTER TABLE myTable ADD newCol NUMBER")
 Traceback (most recent call last):
   File "<stdin>", line 1, in ?
 cx_Oracle.DatabaseError: ORA-01430: column being added already exists in
table

So I guess that the first ALTER TABLE did its job...
If something goes wrong, you get an exception!

What kind of ALTER did you try?

--
Amaury Forgeot d'Arc
Ubix Development
www.ubitrade.com

Re: [cx-oracle-users] alter table

[Caleb G. <ca...@NA...>]

ama...@ub... wrote:
> It seems to work without any problem.
> I tried this:
> 
>  >>> from cx_Oracle import *
>  >>> cnx = connect(user,password)
>  >>> cur = cnx.cursor()
>  >>> cur.execute("ALTER TABLE myTable ADD newCol NUMBER")
> (ok)
>  >>> cur.execute("ALTER TABLE myTable ADD newCol NUMBER")
>  Traceback (most recent call last):
>    File "<stdin>", line 1, in ?
>  cx_Oracle.DatabaseError: ORA-01430: column being added already exists in
> table
> 
> So I guess that the first ALTER TABLE did its job...
> If something goes wrong, you get an exception!
> 
> What kind of ALTER did you try?

Thanks for your example.  I'm doing the same thing, except my query is:

alter table mytable truncate partition Y2005_D150_S4

Re: [cx-oracle-users] alter table

[Caleb G. <ca...@NA...>]

*sigh*

Please disregard.  Works like a champ.  The failure was in another area. 
  Thanks for your reply.