Is "exec" something related with ORACLE ? Perhaps... In ORACLE you should use "call"... Perhaps...
-- Fabio Maulo El 22/11/2010, a las 15:03, fedehf <[email protected]> escribió: > I execute it according to the documentation: > > I got this exception: > could not execute query > [ exec GetEmittedDocsProc ] > [SQL: exec GetEmittedDocsProc] > > {"ORA-00900: sentencia SQL no válida"} > > Any ideas? > > On 21 nov, 19:03, Diego Mijelshon <[email protected]> wrote: >> For entity-returning SPs, the limitations are listed >> here:http://nhforge.org/doc/nh/en/index.html#querysql-limits-storedprocedures >> >> Diego >> >> On Sun, Nov 21, 2010 at 17:52, fedehf <[email protected]> wrote: >>> 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]<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]. > 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.
