title: ERROR: The symbol "(" was substituted for "VARCHAR2" to continue
body: <p>I am trying to compile this package body:</p>
  
  <pre><code>CREATE OR REPLACE PACKAGE BODY package_1 AS
  PROCEDURE procedure_1 (P_HOST IN VARCHAR2, P_USER IN VARCHAR2, P_NAME IN VARCHAR2)
  IS
  BEGIN
  SELECT HOSTNAME, USERS, PS_NAME 
  INTO P_HOST, P_USER, P_NAME
  FROM PS_COLLECT
  WHERE NOT EXISTS
  ( 
      SELECT HOSTNAME, USERS, PS_NAME
      FROM PS_MASTER
      WHERE PS_MASTER.HOSTNAME = PS_COLLECT.HOSTNAME 
      AND PS_MASTER.USERS = PS_COLLECT.USERS 
      AND PS_MASTER.PS_NAME = PS_COLLECT.PS_NAME
   );
  END procedure_1;
  END package_1;
  </code></pre>
  
  <p>But I am getting this error</p>
  
  <pre><code>The symbol "(" was substituted for "VARCHAR2" to continue.
  </code></pre>
  
  <p>I am a newbie int PL/SQL..please help :)</p>