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] Wed, 31 August 2011 20:06 Go to next message
Gene Turner is currently offline Gene Turner
Messages: 7
Registered: August 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 11:39 Go to previous message
James Sutherland is currently offline James Sutherland
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 11:39 Go to previous message
James is currently offline James
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: Sat Aug 30 12:46:23 EDT 2014

Powered by FUDForum. Page generated in 0.09946 seconds