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?
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
