Fwd: Problem with SQL coming from SQL Server into Oracle DB

2008/6/26 Sandra Becker <sbecker6925_at_gmail.com>:

> Something I forgot to mention earlier is that SSRS always puts an "N" in
> front of each value in the "IN" clause and we have to strip that out before
> we run it from sqlplus.
>

That could be your problem. N'string' uses the national language char set and collation - so a simple index on the column might not be used; are you seeing an implicit cast of your column to NCHAR or NVARCHAR?

See SQL Ref Guide: Literals
<http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/sql_elements003.htm#i42617>

Regards Nigel

--
http://www.freelists.org/webpage/oracle-l