Hello. I've been having serious problems trying to execute a Store
Procedure or a Function through nhibernate. What I need is to map a
function o SP that returns a cursor to an entity. I created a named
query like this:
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" default-
access="property" auto-import="true" default-cascade="none" default-
lazy="true">
<class xmlns="urn:nhibernate-mapping-2.2" mutable="false"
name="AgencyDocument" table="AgencyDocuments">
<id name="Id" type="System.Int64, mscorlib, Version=4.0.0.0,
Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
<property name="DocumentNumber" type="System.String, mscorlib,
Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
<column name="DOC" length="255" not-null="true" />
</property>
</class>
<sql-query name="GetEmittedDocs" callable="true">
<return class=AgencyDocument">
<return-property name="DocumentNumber" column="DOC"/>
</return>
{ ? = call GetEmittedDocs(17795,11,1,1) }
</sql-query>
</hibernate-mapping>
The function returns a rowset with column DOC.
I try to execute it like tihs:
var query = this.Session.GetNamedQuery("GetEmittedDocs");
query.List<AgencyDocument>();
When trying to execute the function I get the following error:
could not execute query
[ { :p0 = call GetEmittedDocs(17795,11,1,1) } ]
[SQL: { :p0 = call GetEmittedDocs(17795,11,1,1) }]
The type of error is ORA-0911. Invalid character.
How can I map a SP or Function that returns a cursor to an entity.
I'm using Oracle 10g and Nhibernate 2.1.0.4000.
Thanks in advance
--
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.
