News from November, 2005
November 2005
Sun Mon Tue Wed Thu Fri Sat
    1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30      

Dec 27, 2005
Oct 21, 2005

  2005/11/28
Last changed: Nov 28, 2005 23:06 by zcjsh

CREATE OR REPLACE PACKAGE "JAMES"."PKG_TEST" as
TYPE myrctype IS REF CURSOR;
end pkg_test;

CREATE OR REPLACE PROCEDURE "JAMES"."PRO_DKTPHOUSEPLANBACKTEST"
(
p_rc out pkg_test.myrctype
)
as

begin
open p_rc for select LOANMODEID,way,isvisible,isdelete from dkLOANMODE;
end;

<parameterMap id="swapParas" class="map">
<parameter property="p_rc" jdbcType="" javaType="" mode="OUT" />
</parameterMap>
<procedure id="PhouseLoan.queryTphousePlanBack" parameterMap="swapParas">

Unknown macro: {call PRO_DKTPHOUSEPLANBACKTEST(?)}

</procedure>

this pro_dkTphousePlanBack return cursor,

in .java
HashMap paraMap = new HashMap();
paraMap.put("p_rc", null);
queryForObject("PhouseLoan.queryTphousePlanBack",paraMap);
with Input parameter

Posted at 28 Nov @ 11:01 PM by zcjsh | 0 comments
Site running on a free Atlassian Confluence Open Source Project License granted to OSS. Evaluate Confluence today.
Powered by Atlassian Confluence, the Enterprise Wiki. (Version: 2.5.5 Build:#811 Jul 25, 2007) - Bug/feature request - Contact Administrators