<database-object>
		<create>
			CREATE OR REPLACE PROCEDURE employmentsForRegion(rows OUT SYS_REFCURSOR, p_regionCode EMPLOYMENT.REGIONCODE%TYPE)
			AS
			BEGIN
			OPEN rows FOR
			SELECT EMPLOYEE, EMPLOYER, STARTDATE, ENDDATE,
			REGIONCODE, EMPID, VALUE, CURRENCY
			FROM EMPLOYMENT
			WHERE REGIONCODE = p_regionCode;
			END;
		</create>
		<drop>
			DROP PROCEDURE employmentsForRegion
		</drop>
	</database-object>

create or replace procedure Test_Procedure (cur out sys_refcursor, arg number)
as
begin
  insert into Victim
  (Id, Val)
  values
  (arg, arg);
  
  open cur for
    select * from dual;
end;

	<sql-query name="selectEmploymentsForRegion">
		<return alias="emp" class="Employment">
			<return-property name="employee" column="EMPLOYEE"/>
			<return-property name="employer" column="EMPLOYER"/>
			<return-property name="startDate" column="STARTDATE"/>
			<return-property name="endDate" column="ENDDATE"/>
			<return-property name="regionCode" column="REGIONCODE"/>
			<return-property name="employmentId" column="EMPID"/>
			<return-property name="salary">
				<return-column name="VALUE"/>
				<return-column name="CURRENCY"/>
			</return-property>
		</return>
		{ call employmentsForRegion(:regionCode) }
	</sql-query>

  <sql-query name="CallTestProcedure">
    <return alias="CallTestProcedure" class="Test.Dual, Test">
      <return-property name="Dummy" column="DUMMY"/>
    </return>
    { call aspnetuser.test_procedure(:arg) }
  </sql-query>

IQuery
	query = session.GetNamedQuery("CallTestProcedure");

query.SetParameter("arg",  99 );

Dual
	result = query.UniqueResult<Dual>();