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,
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-lReceived on Fri Nov 22 2013 - 10:41:14 CET