title: PL/SQL: Error when creating sequence
body: <p>I'm <em>quite</em> new to PL/SQL, and am using Oracle SQL Developer to write a procedure which uses a sequence to generate a primary key for some existing data, to write into another DB.</p>
  
  <p>The code in question is under NDA.. Essentially I have the following:</p>
  
  <pre><code>create or replace
  PROCEDURE Generate_Data
  (
     output IN VARCHAR2
  ) 
  AS
  
  -- Variables here --
  
  CURSOR myCursor IS
  SELECT data1, data2 
  FROM table;
  
  CREATE SEQUENCE mySequence      &lt;-- error on this line
  START WITH 0
  INCREMENT BY 1;
  
  BEGIN
  LOOP
      -- snip --
  </code></pre>
  
  <p>It raises the error PLS-00103, saying it encountered the symbol CREATE when expecting on of the following: begin, function, package, pragma, procedure, ...</p>
  
  <p>I've been following the example at: 
  <a href="http://www.techonthenet.com/oracle/sequences.php" rel="noreferrer">http://www.techonthenet.com/oracle/sequences.php</a></p>