does this help? http://me.isit.gd/post/NHibernate-stored-p.aspx
<http://me.isit.gd/post/NHibernate-stored-p.aspx>w:// On Mon, Nov 9, 2009 at 7:53 PM, Rui Guimaraes <[email protected]>wrote: > > Hi, > > In Hibernate it is possible to call Oracle stored function and > procedures with something like this: > > ..... > String errors = null; > Connection con = myPersistence.getSession().connection(); > try { > CallableStatement cs = null; //a "simple" CallableStatement > // now a call to the function with two parameters > cs = con.prepareCall("{? = call PKG_VALIDATIONS.FNC_VALID1 > (?,?)}"); > > cs.registerOutParameter(1,Types.VARCHAR); //the type of return > cs.setInt(2,2007); //the first param (a Int) > cs.setString(3,"Agust"); //the second param > cs.execute(); //execute the call > errors = cs.getString(1); //get the result > } > > > Is it possible to do the same with NHIBERNATE? I am not being able to > find anything, or an example or any other way to do this. Can anyone > give me a trail to follow? > > > -- Cheers, w:// --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
