title: Regarding Oracle Stored Procedure not compiling because table does not currently exist
body: <p>All,</p>
  
  <p>I have the following Package Description:</p>
  
  <pre><code>CREATE OR REPLACE PACKAGE ashish.PKG_Customer AUTHID CURRENT_USER AS
    TYPE cursorType IS REF CURSOR;
  
    PROCEDURE CreateCustomerTable;
    PROCEDURE SelectCustomers(o_ResultSet OUT cursorType);    
  END PKG_Customer;
  </code></pre>
  
  <p>and here is the package body:</p>
  
  <pre><code>CREATE OR REPLACE PACKAGE BODY ashish.PKG_Customer AS
  
    PROCEDURE CreateCustomerTable AS
      sQuery VARCHAR2(1000);
    BEGIN
      sQuery := 'CREATE TABLE tblCustomer2(
                 CustomerID INTEGER PRIMARY KEY,
                 FirstName VARCHAR2(50),
                 LastName VARCHAR2(50),
                 City VARCHAR2(200), 
                 State_Province VARCHAR2(100),
                 PostalCode VARCHAR2(25)
                )';
      EXECUTE IMMEDIATE sQuery;
    END CreateCustomerTable;
  
    PROCEDURE SelectCustomers(o_ResultSet OUT cursorType) AS
    BEGIN
      OPEN o_ResultSet FOR
        SELECT CustomerID,
               FirstName,
               LastName,
               City,
               State_Province,
               PostalCode
          FROM tblCustomer;
    END SelectCustomers;
  END PKG_Customer;
  </code></pre>
  
  <p>The issue I am facing is that my package will not compile because the table does not currently exist. Surely I should be able to create stored procedures in advance for tables that currently don't exist in Oracle right? Am I doing something wrong here?</p>
  
  <p>The server version is Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit.</p>
  
  <p>Thanks!<br>
  -Ashish</p>