title: Checking for Error during execution of a procedure in oracle
body: <pre><code>create or replace procedure proc_advertisement(CustomerID in Number,
  NewspaperID in number,
  StaffID in Number,
  OrderDate in date,
  PublishDate in date,
  Type in varchar,      
  Status in varchar, 
  Units in number) is 
  
  begin 
  
  insert into PMS.Advertisement(CustomerID, NewspaperID, StaffID, OrderDate, PublishDate, 
  Type, Status, Units) 
  values(CustomerID,NewspaperID, StaffID, OrderDate, PublishDate, 
  Type, Status, Units); 
  dbms_output.put_line('Advertisement Order Placed Successfully'); 
  end;
  </code></pre>
  
  <p>How to check for if any error has occurred during the execution of the procedure and if any error has occurred then I wish to display an error message.</p>