On Oct 9, 2007, at 2:10 AM, Moo wrote:
> sqlalchemy.exceptions.DatabaseError: (DatabaseError)
> ORA-01036: 変数の名前/数
> が無効です。
> 'SELECT emp_empno, emp_ename, emp_job, emp_mgr, emp_hiredate,
> emp_sal, emp_comm, emp_deptno \nFROM (SELECT emp.empno AS emp_empno,
> emp.ename AS emp_ename, emp.job AS emp_job, emp.mgr AS emp_mgr,
> emp.hiredate AS emp_hiredate, emp.sal AS emp_sal, emp.comm AS
> emp_comm, emp.deptno AS emp_deptno, ROW_NUMBER() OVER (ORDER BY
> emp.rowid) AS ora_rn \nFROM emp \nWHERE emp.ename = :emp_ename ORDER
> BY emp.rowid) \nWHERE ora_rn>0 AND ora_rn<=1' {'emp_ename': 'SMITH'}
> ----------------------------------------------------------------------
>
> 'ORA-01036' means 'illegal variable name/number'. I think this SELECT
> statement is correct... that's strange.
>
> By the way, I'm using Oracle Instant Client 10g(10.2.0.3.0) and Oracle
> Database 9i(9.2.0.6.0). I set 'NLS_LANG=JAPANESE_JAPAN.JA16SJIS'
> (Japanese Shift-JIS) on client before running the code. Of course,
> table/column names are straight ASCII.
>
I cant really identify what the problem is there. turning on SQL
logging might show more about the issue and also id see if it works
without setting NLS_LANG.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
