Skip to main content


Eclipse Community Forums

      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
Eclipse UserFriend
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
Eclipse UserFriend
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?
(no subject) [message #722745 is a reply to message #721136] Tue, 06 September 2011 11:39 Go to previous message
Eclipse UserFriend
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 Nov 06 20:02:32 EST 2025

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

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

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly