Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » PLSQLCollection example(need example of calling Oracle StoredFunction returning TABLE)
PLSQLCollection example [message #721136] Thu, 01 September 2011 00:06 Go to next message
Gene Turner is currently offline Gene TurnerFriend
Messages: 7
Registered: September 2011
Junior Member
I have tried the code on the PLSQLStoredFunction wiki page, but it does not have an example for TABLE and Array. Can anyone provide such?
Re: PLSQLCollection example [message #722742 is a reply to message #721136] Tue, 06 September 2011 15:39 Go to previous message
James Sutherland is currently offline James SutherlandFriend
Messages: 1939
Registered: July 2009
Location: Ottawa, Canada
Senior Member

It will be similar but use PLSQLTable instead of PLSQLrecord. The key difference is that TABLE is not mapped to a Java class, just returned as a List.

What is your TABLE and stored procedure, and what code have you tried, and what result did you get?


James : Wiki : Book : Blog : Twitter
(no subject) [message #722745 is a reply to message #721136] Tue, 06 September 2011 15:39 Go to previous message
James is currently offline JamesFriend
Messages: 272
Registered: July 2009
Senior Member
It will be similar but use PLSQLTable instead of PLSQLrecord. The key difference is that TABLE is not mapped to a Java class, just returned as a List.

What is your TABLE and stored procedure, and what code have you tried, and what result did you get?

--
James : http://wiki.eclipse.org/EclipseLink : http://en.wikibooks.org/wiki/Java_Persistence : http://java-persistence-performance.blogspot.com/
Previous Topic:Exception Description: Operation not supported: [instantiateForUnitOfWorkValueHolder]
Next Topic:(no subject)
Goto Forum:
  


Current Time: Mon Nov 24 03:07:15 GMT 2014

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

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