Skip to main content


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
Missing name Mising name is currently offline Missing name Mising nameFriend
Messages: 16
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:(no subject)
Next Topic:(no subject)
Goto Forum:
  


Current Time: Thu Mar 28 22:25:53 GMT 2024

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

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

Back to the top