additionally don't shove a schema/owner name into your table's name field. Use the "schema" kw arg for that.
On Mar 2, 2010, at 4:23 PM, celord wrote: > Thanks Michael, I have changed all UPERCASE to lowercase > http://www.pastebin.org/100149, the output has changed a bit but the > table name is still quoted and the insert does not work > > sqlalchemy.exc.DatabaseError: (DatabaseError) ORA-00942: table or view > does not exist > 'INSERT INTO "manpushmail.pushmail" (telefono, fecha, correo) VALUES > (:telefono, :fecha, :correo)' {'correo': 'cgar...@ice.co.cr', 'fecha': > ' ', 'telefono': '87445511'} > > On 2 mar, 12:39, "Michael Bayer" <mike...@zzzcomputing.com> wrote: >> read the note about "case sensitivity" in >> >> http://www.sqlalchemy.org/docs/reference/dialects/oracle.html?highlig... >> >> 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 scripthttp://www.pastebin.org/100014via 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. > -- 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.
