Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
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 18:20 Go to next message
Ashish Sathaye is currently offline Ashish SathayeFriend
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.


Re: Calling PLSQL stored procedure throws error [message #1744877 is a reply to message #1730914] Sat, 01 October 2016 07:57 Go to previous messageGo to next message
graeme kitchen is currently offline graeme kitchenFriend
Messages: 5
Registered: September 2016
Junior Member
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 15:07 Go to previous message
nivrutti shinde is currently offline nivrutti shindeFriend
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
Previous Topic:How to use EclipseLink to implement multi-tenancy
Next Topic:EclipseLink 2.7.2 release date
Goto Forum:
  


Current Time: Tue Mar 19 02:51:15 GMT 2024

Powered by FUDForum. Page generated in 0.01891 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top