Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SELECT CASE WHEN errors when using OraOLEDB and Static ADO RS
<olippold_at_hotmail.com> wrote in message
news:1134662535.009609.290610_at_g43g2000cwa.googlegroups.com...
> I've actually now found the problem. When I traced the query, it was
> stripping various spaces out so I got:
>
> SELECT startdate, (CASE WHEN groupno = 0 THEN1 ELSE2 END) AS
> groupno
> FROM ware01
> WHERE pbi = '133460125008' AND dateclassed = 20051005
> ORDER BY startdate DESC
>
> It was doing the same sort of thing with subqueries, though in those
> situations, every single space was disappearing from the subquery. I
> noticed on the Oracle forums, other people have been having the same
> sort of problems
>
(http://forums.oracle.com/forums/thread.jspa?forumID=148&messageID=623256&th
readID=222860).
>
>
> I have now installed the latest OLE DB Driver (9.2.7) and this problem
> is resolved, though I'm somewhat surprised they released such a poor
> driver in the first place!
>
> Thanks for all your input.
> Oliver
Oliver, thanks for posting that. I have been running into a similar problem with subqueries. Was unaware of the updated OLEDB driver.
-- Randy Harris tech at promail dot comReceived on Thu Dec 15 2005 - 12:48:21 CST