"An example of such a stored function in *MS SQL Server 2000* and higher is as follows"
On Wed, Nov 24, 2010 at 9:56 AM, Diego Mijelshon <[email protected]>wrote: > And perhaps... we* should add an Oracle example to the docs... Perhaps :-) > > Diego > > *: I'll send a patch whenever I get motivated for documentation again. > > > On Wed, Nov 24, 2010 at 08:33, Fabio Maulo <[email protected]> wrote: > >> 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]> >> <nhusers%[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]<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]<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]<nhusers%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/nhusers?hl=en. > -- Fabio Maulo -- 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.
