Python

Python RSS

What's wrong with this query?

•

Join Date: May 2009

Posts: 1

Reputation: tombatista is an unknown quantity at this point

Solved Threads: 0

tombatista tombatista is offline

Offline

Newbie Poster

What's wrong with this query?

May 31st, 2009

 Help with Code Tags 
 Python Syntax (Toggle Plain Text) 
Test = '''
SELECT      /*+ INDEX (s_evt_act acc_temp_teste) */ todo_cd tipoemail, 
            name subject,  email_sndr_addr remetente, 
            evt_stat_cd status, 
            to_char(trunc(created), 'yyyy-mm-dd') data, 
            COUNT(1) quantidade
FROM        sblprod.s_evt_act
WHERE       created >= TO_DATE(:DATAI, 'yyyy-mm-dd hh24:mi:ss')
AND         created <= TO_DATE(:DATAF, 'yyyy-mm-dd hh24:mi:ss')
AND         todo_cd IN ('Email - Entrada','Redução de Preço','Fax - Entrada','Email - Saída')
GROUP BY    todo_cd, name, email_sndr_addr, evt_stat_cd, to_char(trunc(created), 'yyyy-mm-dd');'''
Test = '''
SELECT      /*+ INDEX (s_evt_act acc_temp_teste) */ todo_cd tipoemail, 
            name subject,  email_sndr_addr remetente, 
            evt_stat_cd status, 
            to_char(trunc(created), 'yyyy-mm-dd') data, 
            COUNT(1) quantidade
FROM        sblprod.s_evt_act
WHERE       created >= TO_DATE(:DATAI, 'yyyy-mm-dd hh24:mi:ss')
AND         created <= TO_DATE(:DATAF, 'yyyy-mm-dd hh24:mi:ss')
AND         todo_cd IN ('Email - Entrada','Redução de Preço','Fax - Entrada','Email - Saída')
GROUP BY    todo_cd, name, email_sndr_addr, evt_stat_cd, to_char(trunc(created), 'yyyy-mm-dd');'''

I need to run this query in Oracle and perform an insert into a table of postgre database. Queries work with minors, but this generates an error:

Traceback (most recent call last):
File "C:\Monitoramentos\carga\s_evt_act_carga.py", line 62, in <module>
curSiebel.execute(Oracle,{'DATAI': atualini, 'DATAF': atualfim})
cx_Oracle.DatabaseError: ORA-00911: invalid character

•

Join Date: Jun 2008

Posts: 122

Reputation: slate is an unknown quantity at this point

Solved Threads: 30

slate

Offline

Junior Poster

Re: What's wrong with this query?

Jun 1st, 2009

This is not a python issue.
However...
This oracle error comes out, when in some expression an implicit or explicit conversion fails on some line and field value.

Most likely your

Help with Code Tags

Python Syntax (Toggle Plain Text)