named query « Stored Procedure « JPA Q&A

1. Calling Stored Procedure using NHibernate as a Named Query with Input Parameters    stackoverflow.com

Problem Description:

2. Calling stored procedure thru named query    forum.hibernate.org

Hi, I am using Hibernate + Spring. I want to retrieve the records from DEPT table using stored procedure. Here is the stored pro: CREATE OR REPLACE PACKAGE types AS TYPE ref_cursor IS REF CURSOR; END; CREATE OR REPLACE PROCEDURE GET_DEPT_PROCEDURE ( P_DEPTS OUT types.ref_cursor ) AS BEGIN OPEN P_DEPTS FOR SELECT deptno as Id, dname as namekey, loc as Datekey ...

3. Stored Procedure Call: "Errors in named queries"    forum.hibernate.org

Is the return-alias the DTO that the result will map to? Can i assume the return-property tags are the variables in that DTO? The call has two parameters, one for the resultset and one for the input parameter. Is it implied that the setParameter() on the java side is the parameter and the return-alias is the return?

4. How to use Stored Procedure with Named Query (    forum.hibernate.org

thanx for reply.. but that link is for using function not for procedure.. there is little bit defference in calling function & procedure. I was able to use function , but can't use procedure. My requirement is to use one in parameter & one or more our parameters in procedure... plz help me...

5. Problem when calling storedprocedure via sql-named-query    forum.hibernate.org

Need help with Hibernate? Read this first: http://www.hibernate.org/ForumMailingli ... AskForHelp Hibernate version: 3.2 Mapping documents: { callsp_fe_getDpyForTask (?,?)} Full stack trace of any exception that occurs: 2007-11-22 ...