3 Replies Latest reply: Jan 17, 2008 1:20 PM by 618096 RSS

    User defined function in materialized view over db link

    618096
      I am working in Oracle 10g. Trying to create a materialized view to populate a reporting warehouse from a transactaional database (also oracle 10g).

      In SQL plus I can access a function in a package on the remote database but when I try to use the "working" sql statement in a materialized view I get an invalid identifier error.

      Basically my select statement is ...

      select
      ColA,
      ColB,
      PackageName.Function@db_link(parameters)
      from
      SourceTable@db_link .....

      The select statement works but when I use it within a create materialized view statement I get ora-00904: PackageName.Function: invalid identifier.

      Any help is appreciated.
      Tx,