title: Pl SQL Oracle PLS-00103: Encountered the symbol "CREATE"
body: <p>this code takes input for zipcode, city, and state and then inserts that into the table created Address. Prior to inserting data it will check if the zipcode is already in the table, if so calling procedure(error) to display an error code. </p>
  
  <p>Im getting an error code pls-00103: encountered the symbol "CREATE" when trying to execute the code. Here is my code so far. Thanks for any help in advance.</p>
  
  <pre><code>drop table address;
  
  create table address(zipcode NUMBER, city varchar2(30), state varchar2(20));
  
  create or replace procedure error as
  begin
    dbms_output.put_line('Error Zip Code already found in table');
  end error;
  
  declare
   zzip number;
   ccity varchar2(30);
   sstate varchar2(30);
  
  create or replace procedure location(p_zipcode NUMBER,
                                       p_city varchar2,
                                       p_state varchar2) is
  zip address.zipcode%type;
  cit address.city%type;
  st address.state%type;
  
  begin
    select count(*) from address into zip where zipcode = zip;
    if any_rows_found then 
      error;
    else
    Insert into address values(zip, cit, st);
    end if;
  end location;
  
  begin
    select &amp;zipcode into zzip from dual;
    select &amp;city into ccity from dual;
    select &amp;state into sstate from dual;
    procedure location(zzip, ccity, sstate);
  end;
  /
  </code></pre>