Skip to main content

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
[eclipselink-dev] Issue in calling stored procedure

I am trying to call an Oracle 11 stored procedure using JPA. Following is the stored procedure declaration.

The stored procedure is in a package.


procedure sp_validate_rules


    p_org_id         in org.org_id%type

    , p_rule         in out nocopy rules_tab



Whereas the type rules_rec and nested table rules_tab are at schema level and are defined as below.


create or replace TYPE rules_rec  AS OBJECT


     id         NUMBER(10),

     is_failed  CHAR(1)



create or replace TYPE rules_tab AS TABLE OF rules_rec



Code to call this SP (, the struct object (VelocityScrutinyRuleRec.jaca) and error from the logs (eclipselink.log) are attached herewith.

It seems from an error that it is being thrown from the PL SQL block in the log created by JPA internals. Is there something that I am doing wrong? I tried to debug and found that I always had the input parameter p_rule populated with one value when I called SP.


Any help is appreciated. Thanks in advance!!

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: eclipselink.log
Description: eclipselink.log



Back to the top