Eclipse Community Forums: EclipseLink » Calling PLSQL stored procedure throws error

Home » Eclipse Projects » EclipseLink » Calling PLSQL stored procedure throws error(Getting java.sql.SQLException: ORA-06530: Reference to uninitialized composite)

Calling PLSQL stored procedure throws error [message #1730914]

Fri, 29 April 2016 14:20

Eclipse User

We are trying to call as stored procedure from JPA code. The signature of stored procedure and a type returned it is as below. Note that stored procedure is within a package whereas the type table (IN and OUT argument "p_rule") is at schema level.

procedure sp_validate_rules
(
p_org_id in org.org_id%type,
p_rule in out nocopy rules_tab
);

The PLSQL objects in use are 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;

JPA Code to call this procedure is attached herewith.

On running this example it throws an error as seen in attached log file.

Attachment: RulesDefinitionsQueriesBean.java
(Size: 2.50KB, Downloaded 238 times)
Attachment: eclipselink.log
(Size: 7.85KB, Downloaded 195 times)
Attachment: VelocityScrutinyRuleRec.java
(Size: 0.75KB, Downloaded 227 times)

Re: Calling PLSQL stored procedure throws error [message #1744877 is a reply to message #1730914]

Sat, 01 October 2016 03:57

Eclipse User

As I am interested in you example did you ever find a complete solution?

Re: Calling PLSQL stored procedure throws error [message #1785847 is a reply to message #1730914]

Fri, 20 April 2018 11:07

Eclipse User

Hi Eclipse Team,

Could you please share the examples how oracle user define variable of stored procedure can be mapped to java objects.

Its is really frustrating that eclipse JPA does support this and no example or tutorials available for the same.

Thanks
Nivrutti

Previous Topic:	How to use EclipseLink to implement multi-tenancy
Next Topic:	EclipseLink 2.7.2 release date

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Jul 16 05:34:45 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter