VARCHAR(None, CHAR)

From: Jose Soares <jose.soares_at_sferacarta.com>
Date: Fri, 22 Nov 2013 10:41:14 +0100
Message-ID: <528F26BA.8010307_at_sferacarta.com>



Hi all,

I have a query generated by sqlalchemy like this:

SELECT fattura_master.tipo_documento AS fattura_master_tipo_documento, fattura_master.sezionale || '/' || CAST(fattura_master.anno AS VARCHAR(None CHAR)) || '/' || CAST(fattura_master.numero AS VARCHAR(None CHAR)) AS pk
FROM fattura_master;

which generate the following error:

DatabaseError: (DatabaseError) ORA-00910: specified length too long for its datatype

I can't understand the syntax: VARCHAR(None CHAR). I suppose the error is generated by it. Isn't it?

j

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Nov 22 2013 - 10:41:14 CET

Original text of this message