> 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="&quot;mypackage.myproc&quote;" 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.

Reply via email to