Re: 10G and RULE
From: Gerard H. Pille <ghp_at_skynet.be>
Date: Sun, 21 Mar 2010 19:28:13 +0100
Message-ID: <4ba6653b$0$2877$ba620e4c_at_news.skynet.be>
Nicolas Bronke wrote:
> With Oracle 10g the RULE command will not be supported.
> So far as good, we removed all RULE statements inside Queries and views.
> Mostly it works fine, but in some cases the queries does not work
> correcly. No rows are returned. If I put the RULE back in this query
> everything works fine.
> This happens with 20g2.0.3 and 10g2.0.4
>
> Does someone else has seen this and does exist a patch for this behaviour?
>
> Regards
> Nicolas
Date: Sun, 21 Mar 2010 19:28:13 +0100
Message-ID: <4ba6653b$0$2877$ba620e4c_at_news.skynet.be>
Nicolas Bronke wrote:
> With Oracle 10g the RULE command will not be supported.
> So far as good, we removed all RULE statements inside Queries and views.
> Mostly it works fine, but in some cases the queries does not work
> correcly. No rows are returned. If I put the RULE back in this query
> everything works fine.
> This happens with 20g2.0.3 and 10g2.0.4
>
> Does someone else has seen this and does exist a patch for this behaviour?
>
> Regards
> Nicolas
The patch being to let the rule hint be. Report the bug to Oracle, if you are able to reproduce it with the emp and dept tables. Received on Sun Mar 21 2010 - 13:28:13 CDT