AW: Re: [eclipselink-users] StoredFunctionCall with ROWTYPE as returnval

[Martin.Berner@xxxxxxxxxxxx]

Hello,
I'll take a look at it. I'm Using Eclikselink in GlassfishV3. By default Eclipselink 1.0.1 is bundled with GlassfishV3. How do I "upgrade" to EL-1.1 and configuring and letting Glassfish managing Database link/pooling?

--- Originalnachricht ---
> 
> Support for this was added in the EclipseLink 1.1 release.
> 
> See, PLSQLStoredProcedureCall in the
> org.eclipse.persistence.platform.database.oracle.plsql package.
> 
> 
> Martin.Berner wrote:
> > 
> > Hello,
> > we have a lot of StoredProcedures and StoredFunctions on the underlying 
> > Oracle 10g Database written in PL/SQL. I managed to access a Function 
> > returning a single Value of a JDBC normal Type for example by using this 
> > wrapperfunction:
> >     public <T> T executeFunction(String functionName, HashMap<String, 
> > Object> params, Class<T> returnValueClass) {
> >         StoredFunctionCall functionCall = new StoredFunctionCall();
> >         functionCall.setProcedureName(functionName);
> >         ValueReadQuery query = new ValueReadQuery();
> >         query.setCall(functionCall);
> >         List args = new ArrayList();
> >         for (String key : params.keySet()) {
> >             functionCall.addNamedArgument(key);
> >             query.addArgument(key);
> >             args.add(params.get(key));
> >         }
> >        functionCall.setResult("FUNCTION_RESULT", returnValueClass);
> >        return (T) getSession().executeQuery(query, args);
> >     }
> > 
> > 
> > But some of our Function return a row of a Table. For example:
> > FUNCTION rowGetZwParameter(pnParID IN NUMBER) RETURN
> > T_ZWPARAMETER%ROWTYPE;
> > 
> > How do I access such a Function?
> > 
> > I'm very kind of any help.
> > Berner Martin
> > 
> 
> 
> -----
> ---
> 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-tp23368567p23373257.html
> Sent from the EclipseLink - Users mailing list archive at
> Nabble.com.
> 
> _______________________________________________
> eclipselink-users mailing list
> eclipselink-users@xxxxxxxxxxx
> https://dev.eclipse.org/mailman/listinfo/eclipselink-users