Skip to main content

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
[eclipselink-dev] StoredProcedureCall throwing exception

Hi All,


I am trying to call a PL/SQL stored procedure using JPA.


The stored procedure definition from is inside the package pkg_a and has definition as follows:


  procedure sp_validate_rules


    p_org_id         in org.org_id%type

    , p_rule         in out nocopy velocity_scrutiny_rules_tab



velocity_scrutiny_rules_tab (used as in out parameter in above stored procedure) is a TABLE OF OBJECTS (velocity_scrutiny_rules_rec ) is defined at the schema level and not the package level. The definition for OBJECT and the TABLE TYPE level are given below:



create or replace TYPE velocity_scrutiny_rules_rec  AS OBJECT


     id         NUMBER(10),

     is_failed  CHAR(1)




create or replace

TYPE velocity_scrutiny_rules_tab AS TABLE OF velocity_scrutiny_rules_rec


Attached herewith are the class containing method that calls this stored procedure and the exception I am getting in the logs.


What am I doing wrong? Does JPA need a mirror record type and table types at the package level as stored procedure?


-Ashish Sathaye



This e-mail is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Any review, dissemination, copying, printing or other use of this e-mail by persons or entities other than the addressee is prohibited. If you have received this e-mail in error, please contact the sender immediately and delete the material from any computer.


Attachment: jpa.log
Description: jpa.log

Back to the top