title: Calling a Procedure inside a Function PL/SQL
body: <p>I am trying to figure out how to call the following procedure from a function using Oracle 11g 11.2.0.2.0. Does anyone have some ideas? : </p>
  
  <pre><code>-- CREATES or REPLACES insert_into_table_a Procedure. 
  CREATE OR REPLACE PROCEDURE insert_into_table_a
  -- Declares variable to be inserted into tables. 
      (test_insert_a   VARCHAR2)
  IS
  -- Begins Procedure. 
  BEGIN
  -- Creates a savepoint. 
  SAVEPOINT all_or_none; 
  
  -- Inserts test_insert_a into the CONTACT_ID column of the CONTACT table. 
  INSERT INTO CONTACT (CONTACT_ID)
  VALUES (test_insert_a);
  
  -- Inserts test_insert_a into the ADDRESS_ID column of the ADDRESS table. 
  INSERT INTO ADDRESS (ADDRESS_ID)
  VALUES (test_insert_a);
  
  -- Inserts test_insert_a int the TELEPHONE_ID column of the TELEPHONE table. 
  INSERT INTO TELEPHONE (TELEPHONE_ID)
  VALUES (test_insert_a);
  
  --Commits inserts. 
  COMMIT; 
  -- Creates exception, incase any errors occur, all changes are rolled back. 
  EXCEPTION 
     WHEN OTHERS THEN
      ROLLBACK TO all_or_none; 
  -- Ends procedure.
  END;
  /
  -- Shows any errors created. 
  SHOW ERRORS
  </code></pre>