Mark, try with cs=force ... does it work then?
Raj
--- "Bobak, Mark" <Mark.Bobak_at_il.proquest.com> wrote:
> So, a while ago, I posted a problem I was having where a predicate was
> not getting pushed into a view when the view's SQL was the union of two
> SQL statements, each of which utilized an analytical function. I ended
> up opening a TAR w/ Oracle. They actually owned up to the problem, and
> two days ago, I actually got a one-off patch against 9.2.0.5 for 64-bit
> Solaris. Well, first thing I tried was running my test case, and, sure
> enough, it worked. It seems my test case wasn't robust enough, though!
> My test case had the following SQL to demonstrate the problem:
> select * from xan_view where doc_id = 38943105;
> and with the patch applied, this did the right thing. However, in the
> real world, we use little things called BIND VARIABLES.
>
> If you re-write the above query and execute:
>
> variable b1 number;
> exec :b1:=38943105;
> select * from xan_view where doc_id = :b1;
>
> IT FAILS!!! ARGH! I mean, I never considered that the fix would only
> address the case where a literal is specified! So, it took two weeks to
> get the patch, and I'm right back where I started from!!!
>
> So, that's my frustration of the week.
>
> -Mark
Best Regards
Raj
select mandatory_disclaimer from company_requirements;
Do you Yahoo!?
Vote for the stars of Yahoo!'s next ad campaign!
http://advision.webevents.yahoo.com/yahoo/votelifeengine/
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Sun Jul 18 2004 - 08:41:12 CDT
