title: UTL_RECOMP.RECOMP_SERIAL must be declared
body: <p>First off I'd like to specify that I am trying to do this upgrade remotely. I am receiving this error:</p>
  
  <blockquote>
    <p>2015-04-24:11:59:42 [Error] myDB - Failed to Recompile 'DBTYPE'
    Database Objects: ExcSQL Failed: Oracle Error Encountered: ORA-06550:
    line 1, column 7: PLS-00201: identifier 'UTL_RECOMP.RECOMP_SERIAL'
    must be declared ORA-06550: line 1, column 7: PL/SQL: Statement
    ignored (6550) SQL Text: begin utl_recomp.recomp_serial('DBTYPE');
    end;</p>
    
    <p>2015-04-24:11:59:42 [Error] WorksObjects Execution Failed: DBTYPE -
    Process JAR Files Failed: Failed to Recompile 'DBTYPE' Database
    Objects:ExcSQL Failed: Oracle Error Encountered: ORA-06550: line 1,
    column 7: PLS-00201: identifier 'UTL_RECOMP.RECOMP_SERIAL' must be
    declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored (6550)
    SQL Text: begin utl_recomp.recomp_serial('DBTYPE'); end;</p>
    
    <p>2015-04-24:11:59:42 [Error] UPGD FAILED! : myDB - Upgrade Error -
    Worker Thread Process Error - DBTYPE - Process JAR Files Failed:
    Failed to Recompile 'DBTYPE' Database Objects:ExcSQL Failed: Oracle
    Error Encountered: ORA-06550: line 1, column 7: PLS-00201: identifier
    'UTL_RECOMP.RECOMP_SERIAL' must be declared ORA-06550: line 1, column
    7: PL/SQL: Statement ignored (6550) SQL Text: begin
    utl_recomp.recomp_serial('DBTYPE'); end;</p>
  </blockquote>
  
  <p>when I try to do a recompile on invalid objects. The only thing I can find on the internet is that when recompiling, that I should be logged in as a sysdba, which I am currently doing.</p>
  
  <pre><code>"Data Source = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = " + MyHostName + ")(PORT = 1521))(CONNECT_DATA =" +
  "(SERVICE_NAME = " + mySID + ")));DBA Privilege = SYSDBA;" +
  "User Id = " + MyID + ";Password = " + MyPW;
  </code></pre>
  
  <p>My connection is working correctly cause I can run 3/4 of the upgrade process till I hit this point where I try and recompile this specific schema.</p>
  
  <pre><code>Conn = GetConn( MyID, MyPW );
  if (DevelopSrvr)
  {
     ExcSQL(Conn, "alter session set plsql_debug=true");
  }
  ExcSQL(Conn, "begin utl_recomp.recomp_serial('" + schema + "'); end;");
  </code></pre>
  
  <p>This program runs fine locally and I have checked the stack trace and all the variables are returning the expected values.  Is there something I'm missing? Thanks in advance</p>