title: How to call function using dblink in oracle?
body: <p>Is it possible to call a function using DBLINK in oracle? I am calling the function like this and getting the error - ORA-00904: "MC"."GET_REFTYPES": invalid identifier</p>
  
  <pre><code>select column_value from table(mc.Get_REFTYPES@READ_MAIN_MCNAV(param1, param2, param3)));
  </code></pre>
  
  <p>function code </p>
  
  <pre><code>CREATE OR REPLACE FUNCTION "MC"."Get_REFTYPES"(
    param1 IN VARCHAR, 
    param2  IN NUMBER, 
    param3  IN DATE DEFAULT SYSDATE
    )
    RETURN RefType_T PIPELINED IS
  
    CURSOR cur_st (
      cur_param1 VARCHAR, 
      cur_param2  NUMBER,
      cur_param3  DATE
      ) IS
              select 
                TypeID
              FROM ......
            WHERE......... ;
  
    t_st Types_T;  -- Table variable to store return values       
  
   BEGIN
  
      OPEN cur_st(param1, param2 , param3 );
      FETCH cur_st BULK COLLECT INTO t_st;
      CLOSE cur_st;
  
      FOR i IN 1..t_st.COUNT LOOP
              PIPE ROW(t_st(i));
      END LOOP;
      RETURN;
  END;
  </code></pre>
  
  <p>Thanks!</p>