[
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:
velocity_scrutiny_rules_REC:
create or replace TYPE velocity_scrutiny_rules_rec AS OBJECT
(
id NUMBER(10),
is_failed CHAR(1)
)
velocity_scrutiny_rules_tab
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:
ClassWithMethod.java
Description: ClassWithMethod.java
Attachment:
jpa.log
Description: jpa.log