I tried with call, with exec. None of them are working. could not execute query [ call GetAgencyDocs ] [SQL: call GetAgencyDocs]
On 25 nov, 13:44, Fabio Maulo <[email protected]> wrote: > "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.
