Eclipse Community Forums: EclipseLink » How to handle Oracle Store Procedure call with Oracle Types as input or output using EclipseLink

Home » Eclipse Projects » EclipseLink » How to handle Oracle Store Procedure call with Oracle Types as input or output using EclipseLink (EclispeLink, Store Procedure and Oracle Types(User defined data types))

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

How to handle Oracle Store Procedure call with Oracle Types as input or output using EclipseLink [message #521208]

Tue, 16 March 2010 14:02

MAK
Messages: 4
Registered: March 2010

Junior Member

Hi,

I doing a Proof Of Concept to figure out how efficient to call a store
procedure using EclipseLink. I was able to call oracle store procedure
using EclispeLink with Scalar/primitive data types (link Integer,
varchar etc). I wanted to understand how can I handle Oracle Store
procedure from EclipseLink with collection(Oracle Types/User defined
types) as input or output parameters. I would really appreciate if
some one help me understand this with an example.

Thanks
MAK

Report message to a moderator

Re: How to handle Oracle Store Procedure call with Oracle Types as input or output using EclipseLink [message #521530 is a reply to message #521208]

Wed, 17 March 2010 18:47

Andrew Hume
Messages: 18
Registered: December 2009

Junior Member

MAK

Good luck with this. I have also been seriously considering the use of Oracle specific features such as VARRAYs and NESTED TABLES, but I think the focus of the EclipseLink project (now that it is open source, and possibly less well resourced by Oracle?) is more around the database features that are common to all databases.

I was told that the Workbench is not being actively developed, and that the focus was on Dali. If Dali is supposed to work with all JPA providers then there will be little room for Oracle specific features.

Perhaps it is best if we do stick to common SQL constructs and therefore have the greatest choice of tools? This is kind of annoying, as being able to model 1:n (where n is small) collections would be very useful.

Andrew

Report message to a moderator

Re: How to handle Oracle Store Procedure call with Oracle Types as input or output using EclipseLink [message #521740 is a reply to message #521208]

Thu, 18 March 2010 11:55

Mike Norman
Messages: 35
Registered: July 2009

Member

I've made available a simple example on gist:
http://gist.github.com/336393

Hope this helps,
--
Mike Norman | Principal Software Designer | 613.288.4638
Oracle Server Technologies | EclipseLink Product
45 O'Connor Street, Suite 400 | Ottawa, ON K1P 1A4 | (fax) 613.238.2818

Report message to a moderator

Re: How to handle Oracle Store Procedure call with Oracle Types as input or output using EclipseLink [message #522028 is a reply to message #521740]

Fri, 19 March 2010 13:12

Andrew Hume
Messages: 18
Registered: December 2009

Junior Member

Mike

Thanks for the example.

Would it be possible to show the equivalent code using JPA annotations?

I am interested to understand how much of the boilerplate code can be removed by the use of the annotations.

Cheers
Andrew

Report message to a moderator

Re: How to handle Oracle Store Procedure call with Oracle Types as input or output using EclipseLink [message #522680 is a reply to message #521740]

Tue, 23 March 2010 11:13

MAK
Messages: 4
Registered: March 2010

Junior Member

Thanks Mike!

Report message to a moderator

Previous Topic:	How to access the object created in a select clause with constructor in an order by?
Next Topic:	Unsupported Driver.getClientInfo() operation when Eclipselink 2.0.0 accesses TimesTen 11.2.1

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 20 05:13:25 EDT 2013