| Re: AW: Re: [eclipselink-users] StoredFunctionCall with ROWTYPE as returnvalue |
The PLSQL support was only added to for stored procedures. For a stored function you will need to wrap it in a stored procedure, or customize your own subclass of PLSQLStoredProcedureCall. Martin.Berner wrote: > > Hello, > I replaced the following jar's in > glassfish-v3-prelude/glassfish/modules/ with the ones shipped with > "eclipselink-plugins-1.1.0.r3634.zip": > org.eclipse.persistence.core_1.1.0.r3634.jar > org.eclipse.persistence.asm_1.1.0.r3634.jar > org.eclipse.persistence.antlr_1.1.0.r3634.jar > org.eclipse.persistence.oracle_1.1.0.r3634.jar > javax.persistence_1.99.0.jar > org.eclipse.persistence.jpa_1.1.0.r3634.jar > > When Eclipselink connect to the Database at least it shows me (Eclipse > Persistence Services - 1.1.0.r3634). > > I don't know if tat dos the trick put it works at least. > Any other Idees? > > About the Problem I'm asking initially, I don't know how to use > PLSQLStoredProcedureCall with a Function returning a row. I found a > sample at (http://forums.oracle.com/forums/thread.jspa?threadID=829153) > on which a User explains how to use PLSQLStoredProcedureCall with a > RowType as IN, OUT or INOUT Parameter. But I hope I don't have to code a > wrapper-Procedure for every single Function. Can Anybody give me a > Sample for accessing a storedFunction like this one? > > FUNCTION rowGetZwParameter(pnParID IN NUMBER) RETURN > T_ZWPARAMETER%ROWTYPE; > > > ----- --- http://wiki.eclipse.org/User:James.sutherland.oracle.com James Sutherland http://www.eclipse.org/eclipselink/ EclipseLink , http://www.oracle.com/technology/products/ias/toplink/ TopLink Wiki: http://wiki.eclipse.org/EclipseLink EclipseLink , http://wiki.oracle.com/page/TopLink TopLink Forums: http://forums.oracle.com/forums/forum.jspa?forumID=48 TopLink , http://www.nabble.com/EclipseLink-f26430.html EclipseLink Book: http://en.wikibooks.org/wiki/Java_Persistence Java Persistence -- View this message in context: http://www.nabble.com/StoredFunctionCall-with-ROWTYPE-as-returnvalue-tp23368567p23387447.html Sent from the EclipseLink - Users mailing list archive at Nabble.com.