title: Sending params to a stored procedure in JPA
body: <p>I have a stored procedure in Oracle DB which takes in an user-defined object as input. Any inputs on how to invoke this stored procedure in JPA?</p>
  
  <p>User defined object :</p>
  
  <pre><code>CREATE OR REPLACE TYPE TEST AS OBJECT 
  (
       NAME varchar2(200),
       AGE number(10,2)
  )
  </code></pre>
  
  <p>Stored procedure package :</p>
  
  <pre><code>create or replace PACKAGE TRIAL_PACKAGE 
  AS TYPE REC IS RECORD(NAME VARCHAR2(200),AGE NUMBER(10,2));
      PROCEDURE TEST_PACK(r IN REC);
  END TRIAL_PACKAGE; 
  
  CREATE OR REPLACE PACKAGE BODY TRIAL_PACKAGE AS
      PROCEDURE TEST_PACK(r IN REC) AS
      BEGIN
          -- TODO: Implementation required for PROCEDURE TRIAL_PACKAGE.TEST_PACK
  
          INSERT INTO TABLE_TEST1(NAMES, AGE) 
          VALUES(r.NAME, r.AGE);
      END ;
  END TRIAL_PACKAGE;
  </code></pre>