well i found a solution, though it's not working for me.. here it is. http://ayende.com/Blog/archive/2006/10/01/UsingSQLFunctionsInNHibernate.aspx
the only thing that different is that my function return varchar instead of number. anyway i get the next error: no persister for: system.String On Oct 22, 1:05 pm, Wayne Douglas <[email protected]> wrote: > http://gist.github.com/640347 > > AddScalarValues looks like this:http://gist.github.com/640352 > > we had to create a way to call sprocs and project the results onto a > collection > > we knew the shape of the data coming back so we could create a poco to > represent it. > > would this work for you? > > > > > > On Fri, Oct 22, 2010 at 2:54 AM, Fabio Maulo <[email protected]> wrote: > > You can register the custom function in your custom dialect > > > -- > > Fabio Maulo > > > El 21/10/2010, a las 08:46, Orbach <[email protected]> escribió: > > > > lets say i got the next oracle stored proc > > > > function giveMeNumber() return number is > > > begin > > > return 30; > > > end; > > > > can someone please tell how can i call it through nHibernate? how to > > > build my hbm mapping file? i tried all sort of things.. nothing works! > > > > -- > > > 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]<nhusers%[email protected] > > > > > . > > > For more options, visit this group at > >http://groups.google.com/group/nhusers?hl=en. > > > -- > > 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]<nhusers%[email protected] > > > > > . > > For more options, visit this group at > >http://groups.google.com/group/nhusers?hl=en. > > -- > 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.
