配置文件：
<hibernate-mapping>
<class name="vo.SshPost" table="ssh_post" >
<!-- <cache usage="read-write"/>-->
<id name="postId" type="java.lang.String">
<column name="post_id" />
<generator class="native" />
</id>
<property name="postName" type="java.lang.String">
<column name="post_name" length="20" />
</property>
<property name="postNo" type="java.lang.String">
<column name="post_no" length="20" />
</property>
<filter name="myfilter" condition=":myfilterParam = post_name"/>
</class>
<sql-query callable="true" name="selectAllUsers">
<return class="vo.SshPost">
<return-property name="postId" column="POST_ID"/>
<return-property name="postName" column="POST_NAME"/>
<return-property name="postNo" column="POST_NO"/>
</return>
{ call P_TEST(?,:VPOSTNO) }
</sql-query>
</hibernate-mapping>
存储过程：
CREATE OR REPLACE PACKAGE TESTPACKAGE AS
TYPE Test_CURSOR IS REF CURSOR;
end TESTPACKAGE;
CREATE OR REPLACE PROCEDURE P_TEST(P_CURSOR OUT TESTPACKAGE.TEST_C
