title: Importing procedure from an oracle package using Entity Framework 5
body: <pre><code>CREATE OR REPLACE PACKAGE johns_test_pkg AS
  
    PROCEDURE test(some_parameter IN  NUMBER,
                   success_id     OUT NUMBER);
  
    PROCEDURE test_no_out_parameter(some_parameter IN NUMBER);
  
    PROCEDURE test_no_in_parameter(success_id OUT NUMBER);
  
  END johns_test_pkg;
  /
  
  CREATE OR REPLACE PACKAGE BODY johns_test_pkg AS
  
    --
    PROCEDURE test(some_parameter IN  NUMBER,
                   success_id     OUT NUMBER)
    IS
      v_app_user_session_id INTEGER;
      BEGIN
        v_app_user_session_id := 1 + some_parameter;
  
        success_id := v_app_user_session_id;
      END;
  
    --
    PROCEDURE test_no_out_parameter(some_parameter IN NUMBER)
    IS
      v_app_user_session_id INTEGER;
      BEGIN
        v_app_user_session_id := 1 + some_parameter;
      END;
  
    --
    PROCEDURE test_no_in_parameter(success_id OUT NUMBER)
    IS    
      v_app_user_session_id INTEGER;
      BEGIN
        v_app_user_session_id := 1 + 10;
        success_id := v_app_user_session_id;
      END;
  
  END johns_test_pkg;
  /
  </code></pre>
  
  <p>Given the above simple <em>Oracle</em> package with three procedures within. I have tried to add these procedures to my model using <em>Entity Framework 5</em> with no avail. I have been able to add a few <em>Oracle</em> procedures that are not in packages.</p>
  
  <p>I have been reading about this and some other questions are similar <a href="https://stackoverflow.com/questions/6058381/how-to-call-oracle-function-with-return-value-using-linq-to-entities">how-to-call-oracle-function-with-return-value-using-linq-to-entities</a> and read on from the selected answer. The person states that <code>IN OUT</code> parameters or <code>OUT</code> parameters should work, but none of my three were imported. I would have expected that <code>test_no_in_parameter</code> procedure would get loaded?</p>
  
  <p>Is it possible to load a procedure under a package?</p>