Re: ORA-02070: database xxxx does not support some function in this context

Hi Neil,

I think that I had the same problem a while ago with an update. The update/select worked fine in Oracle 7 and failed in Oracle 8. The problem was the view "product_component_version" in the select. OTS had no solution for this problem!
Here's my "dirty" solution that works fine if you don't have to insert/update too many rows.

declare
  v varchar2(64);
begin
  select version
    into v
    from product_component_version
   where product like 'Oracle%';
  update databases_at_remote
  set versie = v

     ,oracle_home = '${ORACLE_HOME}'
  where database = '${SID}';
end;

Good luck!
  Jos

Neil Barton <nbarton_at_dpapplications.com> schreef in berichtnieuws N1V15.11801$6d7.642423_at_news-west.usenetserver.com...
> Has anyone run into this error message (ORA-02070: database xxxx does not
> support some function in this context. ) when performing an insert
> statement, while selecting data from a remote database. The local
 (target)
> database is running 8.1.6.0.0 and the remote (source) database is running
> 8.0.4.4.0
>
> Query works fine if run as a simple "select" statement.
>
> Any ideas would be appreciated.
>
>
>
>
>
>
Received on Thu Jun 15 2000 - 00:00:00 CDT