Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » StoredProcedureCall RETURN nested table/array
StoredProcedureCall RETURN nested table/array [message #642168] Tue, 30 November 2010 08:40 Go to next message
Aki is currently offline AkiFriend
Messages: 1
Registered: November 2010
Junior Member
Hi All,

May I know whether eclipselink can support the return type (nested table or table of varchar) which is returned from storedprocedure?

If yes, any source or reference I can find?

Thanks
Re: StoredProcedureCall RETURN nested table/array [message #642785 is a reply to message #642168] Thu, 02 December 2010 16:52 Go to previous message
James Sutherland is currently offline James SutherlandFriend
Messages: 1939
Registered: July 2009
Location: Ottawa, Canada
Senior Member

You can use the PLSQLStoredProcedureCall class in EclipseLink to call stored procedures with PLSQL types.

See,
http://wiki.eclipse.org/EclipseLink/Examples/JPA/nonJDBCArgs ToStoredProcedures

http://www.eclipse.org/eclipselink/api/2.1/org/eclipse/persi stence/platform/database/oracle/plsql/PLSQLStoredProcedureCa ll.html


James : Wiki : Book : Blog : Twitter
Previous Topic:Retrieving username from JBoss for db call setting application_context in Oracle
Next Topic:Multiple TableGenerators per Entity
Goto Forum:
  


Current Time: Thu Dec 18 15:34:30 GMT 2014

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

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