The original (fixed) bug report: http://216.121.112.228/browse/NH-2027
From: Maciej Szczepanski Sent: Tuesday, July 20, 2010 8:14 PM To: [email protected] Subject: Re: [nhusers] ORACLE Package error 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 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]. 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. -- 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.
