title: Warning: Procedure created with compilation errors in oracle
body: <p>CREATE TABLE:</p>
  
  <pre><code>create table customer (Name varchar2(10), Address varchar(40), Contact number);
  </code></pre>
  
  <p>CREATE PROCEDURE FOR INSERT:</p>
  
  <pre><code>CREATE OR REPLACE PROCEDURE SP_CUSTOMER (
  p_name customer.Name%TYPE,
  p_address customer.Address%TYPE,
  p_contact customer.Contact%TYPE)
  IS
  BEGIN
  INSERT INTO customer ("Name", "Address", "Contact")
  VALUES (p_name, p_address, p_contact);
  COMMIT;
  END;
  /
  </code></pre>
  
  <p>ERROR:
  IT SHOWS: Warning: Procedure created with compilation errors.</p>
  
  <pre><code>CREATE PROCEDURE FOR SELECT:
  
  CREATE OR REPLACE PROCEDURE SP_SELECT_CUSTOMER (
  p_name customer.Name%TYPE,
  p_address customer.Address%TYPE,
  p_contact customer.Contact%TYPE)
  IS
  BEGIN
  SELECT Name, Address, Contact FROM customer;
  END;
  /
  </code></pre>
  
  <p>ERROR:
  IT SHOWS: Warning: Procedure created with compilation errors.</p>
  
  <p>What is the problem.? How to solve it.?</p>