Re: driving_site and local function call

From: Shakespeare <whatsin_at_xs4all.nl>
Date: Thu, 19 Jun 2008 19:29:36 +0200
Message-ID: <485a9780$0$14343$e4fe514c@news.xs4all.nl>

"steph" <stephan0h_at_yahoo.de> schreef in bericht news:544ed7dd-b119-40a3-8f91-f6977a71e367_at_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

Feature, or must. The function can not be calculated at the 'DRIVING-SITE' .

Shakespeare Received on Thu Jun 19 2008 - 12:29:36 CDT

Original text of this message