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)

Show: Today's Messages :: Show Polls :: Message Navigator

Calling PLSQL stored procedure throws error [message #1730914]

Fri, 29 April 2016 18:20

Ashish Sathaye

Messages: 1
Registered: April 2016

Junior Member

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 188 times)
Attachment: eclipselink.log
(Size: 7.85KB, Downloaded 151 times)
Attachment: VelocityScrutinyRuleRec.java
(Size: 0.75KB, Downloaded 174 times)

Report message to a moderator

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

Sat, 01 October 2016 07:57

graeme kitchen

Messages: 5
Registered: September 2016

Junior Member

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

Report message to a moderator

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

Fri, 20 April 2018 15:07

nivrutti shinde

Messages: 2
Registered: April 2018

Junior Member

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 19 07:38:28 GMT 2022

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter