Re: Character set mismatch

hheien_at_hotmail.com wrote:
> Hi,
>
> At the moment I am working towards an Oracle server through Microsoft
> SQL Server Reporting Services and I've been stuck with an "ORA-12704:
> character set mismatch" error for a while now. What I'm trying to do is
> to run a query using multi value parameters from Reporting Services to
> the Oracle server. This have worked fine until recently towards an
> Oracle version 9 database, but now I'm trying to make it work with
> Oracle version 8.1.7 and this is when I get the character set mismatch
> problems.
>
> The following query illustrates the problems I'm having:
>
> select *
> from table x
> where x.date between :startDate and :endDate and
> x.someRow in (:multiValueParameterList)
>
> The actual query is larger than the one above, but I have located the
> problem to occur when I try to use multi value parameters in my query.
> I have no problems with the queries as long as I use single value
> parameters.
>
> I would greatly appreciate if someone could help me out with this
> problem.
> --
> Hans Inge Heien

Assuming :multiVAlueParameterList is what I think it is ... 'val1, val2, val3, val4' ... you can't do it that way.

Go to Morgan's Library at www.psoug.org
Click on Conditions
Scroll down to Complex IN Demo.

I doubt a Microsoft product will support this syntax.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)