Unfortunately there is a bug, i think it's already fixed in the trunk, anyway here is the description and the workaround: http://nhforge.org/wikis/howtonh/calling-oracle-procedure-inside-package.aspx <http://nhforge.org/wikis/howtonh/calling-oracle-procedure-inside-package.aspx>
On Tue, Jul 20, 2010 at 3:56 PM, Frans Bouma <[email protected]> wrote: > > I am new to NHibernate, using it about 3 days. That said... > > > > When mapping a sql-query I am getting the following error if I prefix a > proc > > name with the package name like so > > > > mypackage.myproc > > > > {"ORA-06550: line 1, column 15:\nPLS-00222: no function with name > > 'mypackage' exists in this scope\nORA-06550: line 1, column 7:\nPL/ > > SQL: Statement ignored"} > > > > <sql-query name="mypackage.myproc" callable="true" > <return > class="Member"> > > </return> { ? = call mypackage.myproc () } </sql-query> > > > > Any ideas? > > Did you try: > <sql-query name=""mypackage.myproc"e;" callable="true" > <return > class="Member"> </return> { ? = call mypackage.myproc () } </sql-query> > > and with the right casing? (So specify the right casing for the package and > proc) > > FB > > ------------------------------------------------------------------------ > Lead developer of LLBLGen Pro, .NET's most advanced O/R mapping designer. > LLBLGen Pro website: http://www.llblgen.com > Blog: http://weblogs.asp.net/fbouma > Twitter: http://twitter.com/FransBouma > Microsoft MVP (C#). > ------------------------------------------------------------------------ > > > > -- > 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. > > -- . Maciej Szczepański -- 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.
