Questions about cx-oracle
Read more about cx-oracle
python (65.2k questions)
javascript (44.3k questions)
reactjs (22.7k questions)
java (20.8k questions)
c# (17.4k questions)
html (16.3k questions)
r (13.7k questions)
android (13k questions)
The possible "cx_Oracle.DatabaseError: ORA-01722: invalid number" reason of retrieve data from oracle by cx_oracle
I have one basic SQL :
select * from my_schema.table
when I run this in Dbeaver, can return data without problem, but when I use python cx_Oracle， will runs into
cx_Oracle.DatabaseError: ORA-01722: ...
Ro Ma
Votes: 0
Answers: 0
cx_oracle: Issues moving large volume of data from one table to another
I am trying to move 20 million records using from one oracle database to another using python cx_Oracle libraries. Unfortunately I cannot use the oracle cli utility tool because some minor transformat...
nolio
Votes: 0
Answers: 0
sqlAlchemy ORM DDL (cx_Oracle.DatabaseError) ORA-00904: : invalid identifier
I've prepared test case based on sqlAlchemy documentation:
https://docs.sqlalchemy.org/en/14/orm/tutorial.html#declare-a-mapping
installation versions:
cx-Oracle==8.2.1
psycopg2-binary==2.9.1
SQLAlche...
Mateusz Konopelski
Votes: 0
Answers: 0
How do you mass insert data from one table to another using cx_oracle when one of the fields is of type sdo_geomentry
I am trying to do in python mass insert of data from one table to another where one of the fields is an oracle SDO_GEOMETRY(2001,4283,MDSYS.SDO_POINT_TYPE(X,Y ,NULL),NULL,NULL) using the cx_oracle lib...
Janet
Votes: 0
Answers: 0