Eclipse Community Forums: EclipseLink » StoredProcedureCall RETURN nested table/array

Help

Home

Home » Eclipse Projects » EclipseLink » StoredProcedureCall RETURN nested table/array

Show: Today's Messages :: Show Polls :: Message Navigator

StoredProcedureCall RETURN nested table/array [message #642168]

Tue, 30 November 2010 08:40

Aki

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

Report message to a moderator

Re: StoredProcedureCall RETURN nested table/array [message #642785 is a reply to message #642168]

Thu, 02 December 2010 16:52

James Sutherland

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

Report message to a moderator

Previous Topic:	Retrieving username from JBoss for db call setting application_context in Oracle
Next Topic:	Multiple TableGenerators per Entity

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 02:31:14 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter