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

From: <nigel.cl.thomas_at_googlemail.com>
Date: Thu, 26 Jun 2008 16:01:23 +0100
Message-ID: <53258cd50806260801w5acdcb03s7b06b82f8fa25674@mail.gmail.com>

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 Nigel

Received on Thu Jun 26 2008 - 10:01:23 CDT

Original text of this message