read the note about "case sensitivity" in http://www.sqlalchemy.org/docs/reference/dialects/oracle.html?highlight=oracle#identifier-casing
celord wrote: > Hello guys, I have the table on an oracle db: > > SQL> desc MANPUSHMAIL.PUSHMAIL; > Nombre ¿Nulo? Tipo > ----------------------------------------- -------- > ---------------------------- > TELEFONO NOT NULL VARCHAR2(12) > FECHA DATE > CORREO VARCHAR2(40) > ESTADO NUMBER(1) > FECHA_EJECUCION DATE > FECHA_EJECUTADO DATE > RESPUESTA VARCHAR2(500) > > I can insert data succesfully via sqlplus like this: > > insert into MANPUSHMAIL.PUSHMAIL values > ('55552222',sysdate,'t...@domain.con','','','',''); > > but using this script http://www.pastebin.org/100014 via sqlalchemy I > get this: > > sqlalchemy.exc.DatabaseError: (DatabaseError) ORA-00942: table or view > does not exist > 'INSERT INTO "MANPUSHMAIL.PUSHMAIL" ("FECHA", "CORREO") VALUES > (:FECHA, :CORREO) RETURNING "MANPUSHMAIL.PUSHMAIL"."TELEFONO" > INTO :ret_0' {'CORREO': None, 'FECHA': None, 'ret_0': > <cx_Oracle.STRING with value None>} > > I do not know if the error could be here: 'INSERT INTO > "MANPUSHMAIL.PUSHMAIL", because when I try to do the insert with the > table name between quotes I get the same error: > > insert into "MANPUSHMAIL.PUSHMAIL" values > ('55553333',sysdate,'te...@domain.com','','','','') > ORA-00942: table or view does not exist > > I am using sqlalchemy version: 0.6beta1 , Python 2.6 on a Solaris 10 > box, and Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 > > Thanks a lot!!! > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To post to this group, send email to sqlalch...@googlegroups.com. > To unsubscribe from this group, send email to > sqlalchemy+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/sqlalchemy?hl=en. > > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.