On Mon, Nov 13, 2017 at 2:50 PM, venu v wrote:
> Thanks Mike. The sql is being created at runtime and i am not even creating
> the sql.
> Any inputs on how we can change it?.
if you are using the String(), Unicode(), or NVARCHAR2() constructs,
give it a length:
cast(expr, Unicode(50))
>
> App
Thanks Mike. The sql is being created at runtime and i am not even creating
the sql.
Any inputs on how we can change it?.
Appreciate your response.
Thanks.
On Friday, 10 November 2017 21:11:46 UTC-8, Mike Bayer wrote:
>
> those NVARCHAR2's probably need a length:
>
> CAST(expr AS NVARCHAR2(20
those NVARCHAR2's probably need a length:
CAST(expr AS NVARCHAR2(20))
On Fri, Nov 10, 2017 at 7:01 PM, venu v wrote:
> Hi,
>
> I have sql alchemy , cx_Oracle installed , Python 2.7 installed on my
> windows machine.
>
> Trying to run a sql using SQL Alchemy and it fails with the below error:
>
Hi,
I have sql alchemy , cx_Oracle installed , Python 2.7 installed on my
windows machine.
Trying to run a sql using SQL Alchemy and it fails with the below error:
"sqlalchemy.exc.DatabaseError: (cx_Oracle.DatabaseError) ORA-00906: missing
left parenthesis"
This is the SQL i have:
('SELECT
