title: Invalid identifier on database link when add new column in table
body: <p>I have 2 database</p>
  
  <ul>
  <li>DB1 with user a with ip address 192.168.10.5</li>
  <li>DB2 with user b with ip address 192.168.10.6</li>
  </ul>
  
  <p>in DB2, I have existing table called <code>tb_r_system</code></p>
  
  <p>I create database link in DB1 to get table <code>tb_r_system</code> in DB2</p>
  
  <pre><code>  CREATE DATABASE LINK test_db_link
      CONNECT TO user00 IDENTIFIED BY user00
      USING 'RED_SERVICE';
  </code></pre>
  
  <p>then I alter add new column in <code>tb_r_system</code> , <code>TEST_COLUMN</code>. after that when I try to select from DB1 with </p>
  
  <pre><code>select * from tb_r_system@test_db_link;
  </code></pre>
  
  <p>it show result with new column, <code>TEST COLUMN</code></p>
  
  <p>but when i try to get this new column in package it show error</p>
  
  <blockquote>
    <p><code>ORA00904 L Invalid identifier</code></p>
  </blockquote>
  
  <p>my package in DB1</p>
  
  <pre><code>CREATE OR REPLACE PACKAGE pkg_acatestw IS
  
    FUNCTION test_db_link(test IN VARCHAR2) 
      RETURN PLS_INTEGER;
  
    END pkg_acatestw;/
  
    CREATE OR REPLACE PACKAGE BODY pkg_acatestw IS
  
        FUNCTION test_db_link(test IN VARCHAR2) RETURN PLS_INTEGER IS
         tar INTEGER;
        BEGIN
  
          SELECT COUNT(test_column) -------------&gt; this line cause error invalid identifier
          INTO tar
          FROM tb_r_system@test_db_link dual;
  
          RETURN 1;
      EXCEPTION
       WHEN OTHERS THEN
          RETURN 1;
      END test_db_link;
  
  END pkg_acatestw;
  </code></pre>
  
  <p>I'd appreciate any help</p>