Fwd: Problem with SQL coming from SQL Server into Oracle DB
Date: Thu, 26 Jun 2008 16:01:23 +0100
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
Regards NigelReceived on Thu Jun 26 2008 - 10:01:23 CDT