driving_site and local function call

From: steph <stephan0h_at_yahoo.de>
Date: Thu, 19 Jun 2008 09:57:29 -0700 (PDT)
Message-ID: <544ed7dd-b119-40a3-8f91-f6977a71e367@a9g2000prl.googlegroups.com>

oracle 10G R2:

I've got this query accessing a lot of remote data via database link. Therefore hint DRIVING_SITE is used to make the query happen on the remote server. Now I've done a change, I call a local package function, which makes the hint being ignored.

The query looks something like this

select /*+DRIVING_SITE(table1) */

         <col1>, ...
        , local_package.myfunc()

  from table1_at_remotedb
    inner join table2_at_remotedb on <join condition>    ...

When I comment the function call everything works as excpected, but when the function call is uncommented the query is happening locally. Is there any reason why the DRIVING_SITE-hint get's ignored the moment i call the local function? Bug or feature?

Thanks,
Stephan Received on Thu Jun 19 2008 - 11:57:29 CDT