ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christopher.Mathru...@sybase.com
Subject RE: problems using stored procs on sybase
Date Thu, 24 May 2007 15:50:39 GMT
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns:o = "urn:schemas-microsoft-com:office:office" xmlns:w = 
"urn:schemas-microsoft-com:office:word"><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META boundary="----_=_NextPart_001_01C79E14.0FDC69E9" alternative; multipart 
Content-Type:>
<META Content-Type: ------_="_NextPart_001_01C79E14.0FDC69E9" html text 
quoted-printable Content-Transfer-Encoding:>
<META content="MSHTML 6.00.6000.16441" name=GENERATOR></HEAD>
<BODY lang=EN-US vLink=purple link=blue>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN 
class=500173315-24052007>First, your problem with JConnect. There is documented 
in the JConnect reference guide one sentence that you should never 
overlook.</SPAN></FONT><FONT face=Arial color=#0000ff size=2><SPAN 
class=500173315-24052007></DIV>
<DIV dir=ltr align=left><B><FONT size=4>
<P>Executing stored procedures</P>
<DIR></B></FONT><FONT face="Times New Roman,Times" size=2>
<P>&#8226;If you execute a stored procedure in a </FONT><FONT face=Arial,Helvetica 
size=1>CallableStatement </FONT><FONT face="Times New Roman,Times" size=2>object 
that represents parameter values as question marks, you get better performance 
than if you use both question marks and literal values for parameters. 
<STRONG><FONT color=#ff0000>Further, if you mix literals and question marks, you 
cannot use output parameters with a stored 
procedure.</FONT></STRONG></P></DIR></FONT></SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=500173315-24052007>Be 
certain that you are not mixing literals with the question marks when executing 
the sp. </SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN 
class=500173315-24052007></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=500173315-24052007>As far 
as BigDecimal not mapping, I currently have defined in one class a BigDecimal 
field that I am mapping in my SQLMap from a DECIMAL jdbc type without any 
issues. The database has this field defined as Money.</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff><SPAN class=500173315-24052007>
<P><FONT face=Arial><FONT size=2><FONT color=#3f7f7f>result </FONT><FONT 
color=#7f007f>column</FONT>=<FONT color=#2a00ff>"unit_price" </FONT><FONT 
color=#7f007f>property</FONT>=<FONT color=#2a00ff>"unitPrice" </FONT><FONT 
color=#7f007f>jdbcType</FONT>=<FONT color=#2a00ff>"DECIMAL" 
</FONT></FONT></FONT></P>
<P><FONT color=#008080><SPAN class=500173315-24052007><FONT face=Arial 
color=#2a00ff size=2>I would recommend looking through the JConnect Programmers 
Guide to ensure that you are mapping things correctly. There is a great deal of 
information in the guide and I can say from experience that "The Devil is in the 
details." There are many little "gotchas" in this guide that you must pay 
attention to.</FONT></SPAN></FONT></SPAN></FONT></P></DIV>
<DIV dir=ltr align=left><BR></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> "Gaer,Jeffrey J" 
&lt;jeffrey.gaer@dads.state.tx.us&gt; [mailto:"Gaer,Jeffrey J" 
&lt;jeffrey.gaer@dads.state.tx.us&gt;] <BR><B>Sent:</B> Thursday, May 24, 2007 
7:59 AM<BR><B>To:</B> user-java@ibatis.apache.org<BR><B>Subject:</B> problems 
using stored procs on sybase<BR></FONT><BR></DIV>
<DIV></DIV>
<META content="Microsoft Word 11 (filtered medium)" name=Generator>
<STYLE>@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.25in 1.0in 1.25in; }
P.MsoNormal {
	FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
	FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
	FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
A:link {
	COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
	COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
	COLOR: purple; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
	COLOR: purple; TEXT-DECORATION: underline
}
SPAN.EmailStyle17 {
	COLOR: windowtext; FONT-FAMILY: Arial; mso-style-type: personal-compose
}
DIV.Section1 {
	page: Section1
}
</STYLE>

<DIV class=Section1>
<P class=MsoNormal><FONT face=Arial size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Running java 1.4.2 and Sybase 
jconnect driver ( I think we are version 12.0 ) we had two problems running a 
particular stored proc. <o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p>&nbsp;</o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">The first was a null pointer 
exception processing the results. The proc set an output value but did not 
return a result&nbsp; set. Adding a &#8216;dummy&#8217; result set to the proc eliminated 
the problem. <o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">--------------------<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" color=blue size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: blue; FONT-FAMILY: 'Courier New'">Caused 
by: java.lang.NullPointerException</SPAN></FONT><FONT face="Courier New" 
size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" color=blue size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: blue; FONT-FAMILY: 'Courier New'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
at 
com.ibatis.sqlmap.engine.execution.SqlExecutor.handleResults(SqlExecutor.java:375)</SPAN></FONT><FONT 
face="Courier New" size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" color=blue size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: blue; FONT-FAMILY: 'Courier New'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
at 
com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQueryProcedure(SqlExecutor.java:291)</SPAN></FONT><FONT 
face="Courier New" size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" color=blue size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: blue; FONT-FAMILY: 'Courier New'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
at 
com.ibatis.sqlmap.engine.mapping.statement.ProcedureStatement.sqlExecuteQuery(ProcedureStatement.java:34)<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" color=blue size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: blue; FONT-FAMILY: 'Courier New'">-----------------------<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><o:p>&nbsp;</o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">The other occurs when using sql 
DECIMAL types. We tried using both BigDecimal and Double as the java type, but 
get the following exception. We were able to work around this by adding a string 
conversion in the proc and passing strings. I was looking for a way to set the 
precession in Ibatis, but could not find one, the precession property seems to 
be only available for .net. <o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p>&nbsp;</o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">----------------------------------<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" color=blue size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: blue; FONT-FAMILY: 'Courier New'">--- 
Cause: com.sybase.jdbc2.jdbc.SybSQLException: Arithmetic overflow during 
implicit conversion of DECIMAL value '2905.00' to a NUMERIC field 
.</SPAN></FONT><FONT face="Courier New" size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><o:p>&nbsp;</o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" color=blue size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: blue; FONT-FAMILY: 'Courier New'">Caused 
by: com.sybase.jdbc2.jdbc.SybSQLException: Arithmetic overflow during implicit 
conversion of DECIMAL value '2905.00' to a NUMERIC field .</SPAN></FONT><FONT 
face="Courier New" size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><o:p>&nbsp;</o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" color=blue size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: blue; FONT-FAMILY: 'Courier New'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
at 
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:185)</SPAN></FONT><FONT 
face="Courier New" size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" color=blue size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: blue; FONT-FAMILY: 'Courier New'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
at 
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForObject(GeneralStatement.java:104)</SPAN></FONT><FONT 
face="Courier New" size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" color=blue size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: blue; FONT-FAMILY: 'Courier New'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
at 
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:561)</SPAN></FONT><FONT 
face="Courier New" size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" color=blue size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: blue; FONT-FAMILY: 'Courier New'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
at 
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:536)</SPAN></FONT><FONT 
face="Courier New" size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" color=blue size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: blue; FONT-FAMILY: 'Courier New'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
at 
com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:93)</SPAN></FONT><FONT 
face="Courier New" size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" color=blue size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: blue; FONT-FAMILY: 'Courier New'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
at 
com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject(SqlMapClientImpl.java:70)<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" color=blue size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: blue; FONT-FAMILY: 'Courier New'"><o:p>&nbsp;</o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" color=blue size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: blue; FONT-FAMILY: 'Courier New'">------------------------<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Here&#8217;s the &nbsp;sqlMap definition, 
we tried both with and without setting the types in the result map.Thanks in 
advance for any insight.<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" color=blue size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: blue; FONT-FAMILY: 'Courier New'">-----------------------------<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" color=black size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: black; FONT-FAMILY: 'Courier New'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></FONT><FONT face="Courier New" color=teal size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: teal; FONT-FAMILY: 'Courier New'">&lt;</SPAN></FONT><FONT 
face="Courier New" color=#3f7f7f size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #3f7f7f; FONT-FAMILY: 'Courier New'">resultMap 
</SPAN></FONT><FONT face="Courier New" color=#7f007f size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #7f007f; FONT-FAMILY: 'Courier New'">id</SPAN></FONT><FONT 
face="Courier New" color=black size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: black; FONT-FAMILY: 'Courier New'">=</SPAN></FONT><FONT 
face="Courier New" color=#2a00ff size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #2a00ff; FONT-FAMILY: 'Courier New'">"bedsResult" 
</SPAN></FONT><FONT face="Courier New" color=#7f007f size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #7f007f; FONT-FAMILY: 'Courier New'">class</SPAN></FONT><FONT 
face="Courier New" color=black size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: black; FONT-FAMILY: 'Courier New'">=</SPAN></FONT><FONT 
face="Courier New" color=#2a00ff size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #2a00ff; FONT-FAMILY: 'Courier New'">"java.util.HashMap" 
</SPAN></FONT><FONT face="Courier New" color=teal size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: teal; FONT-FAMILY: 'Courier New'">&gt;</SPAN></FONT><FONT 
face="Courier New" size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" color=black size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: black; FONT-FAMILY: 'Courier New'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></FONT><FONT face="Courier New" color=teal size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: teal; FONT-FAMILY: 'Courier New'">&lt;</SPAN></FONT><FONT 
face="Courier New" color=#3f7f7f size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #3f7f7f; FONT-FAMILY: 'Courier New'">result 
</SPAN></FONT><FONT face="Courier New" size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" color=#3f7f7f size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #3f7f7f; FONT-FAMILY: 'Courier New'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></FONT><FONT face="Courier New" color=#7f007f size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #7f007f; FONT-FAMILY: 'Courier New'">property</SPAN></FONT><FONT 
face="Courier New" color=black size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: black; FONT-FAMILY: 'Courier New'">=</SPAN></FONT><FONT 
face="Courier New" color=#2a00ff size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #2a00ff; FONT-FAMILY: 'Courier New'">"total_fee" 
</SPAN></FONT><FONT face="Courier New" size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" color=#2a00ff size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #2a00ff; FONT-FAMILY: 'Courier New'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></FONT><FONT face="Courier New" size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" color=#2a00ff size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #2a00ff; FONT-FAMILY: 'Courier New'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></FONT><FONT face="Courier New" color=#7f007f size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #7f007f; FONT-FAMILY: 'Courier New'">column</SPAN></FONT><FONT 
face="Courier New" color=black size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: black; FONT-FAMILY: 'Courier New'">=</SPAN></FONT><FONT 
face="Courier New" color=#2a00ff size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #2a00ff; FONT-FAMILY: 'Courier New'">"AMOUNT"</SPAN></FONT><FONT 
face="Courier New" color=teal size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: teal; FONT-FAMILY: 'Courier New'">/&gt;</SPAN></FONT><FONT 
face="Courier New" size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" color=black size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: black; FONT-FAMILY: 'Courier New'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></FONT><FONT face="Courier New" color=teal size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: teal; FONT-FAMILY: 'Courier New'">&lt;/</SPAN></FONT><FONT 
face="Courier New" color=#3f7f7f size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #3f7f7f; FONT-FAMILY: 'Courier New'">resultMap</SPAN></FONT><FONT 
face="Courier New" color=teal size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: teal; FONT-FAMILY: 'Courier New'">&gt;</SPAN></FONT><FONT 
face="Courier New" size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" color=black size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: black; FONT-FAMILY: 'Courier New'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></FONT><FONT face="Courier New" size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" color=black size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: black; FONT-FAMILY: 'Courier New'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></FONT><FONT face="Courier New" color=teal size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: teal; FONT-FAMILY: 'Courier New'">&lt;</SPAN></FONT><FONT 
face="Courier New" color=#3f7f7f size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #3f7f7f; FONT-FAMILY: 'Courier New'">parameterMap 
</SPAN></FONT><FONT face="Courier New" color=#7f007f size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #7f007f; FONT-FAMILY: 'Courier New'">id</SPAN></FONT><FONT 
face="Courier New" color=black size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: black; FONT-FAMILY: 'Courier New'">=</SPAN></FONT><FONT 
face="Courier New" color=#2a00ff size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #2a00ff; FONT-FAMILY: 'Courier New'">"bedsCalcFeeParam" 
</SPAN></FONT><FONT face="Courier New" color=#7f007f size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #7f007f; FONT-FAMILY: 'Courier New'">class</SPAN></FONT><FONT 
face="Courier New" color=black size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: black; FONT-FAMILY: 'Courier New'">=</SPAN></FONT><FONT 
face="Courier New" color=#2a00ff size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #2a00ff; FONT-FAMILY: 'Courier New'">"bedsFee" 
</SPAN></FONT><FONT face="Courier New" color=teal size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: teal; FONT-FAMILY: 'Courier New'">&gt;</SPAN></FONT><FONT 
face="Courier New" size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" color=black size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: black; FONT-FAMILY: 'Courier New'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></FONT><FONT face="Courier New" color=teal size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: teal; FONT-FAMILY: 'Courier New'">&lt;</SPAN></FONT><FONT 
face="Courier New" color=#3f7f7f size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #3f7f7f; FONT-FAMILY: 'Courier New'">parameter 
</SPAN></FONT><FONT face="Courier New" color=#7f007f size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #7f007f; FONT-FAMILY: 'Courier New'">property 
</SPAN></FONT><FONT face="Courier New" color=black size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: black; FONT-FAMILY: 'Courier New'">=</SPAN></FONT><FONT 
face="Courier New" color=#2a00ff size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #2a00ff; FONT-FAMILY: 'Courier New'">"id_app" 
</SPAN></FONT><FONT face="Courier New" color=#7f007f size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #7f007f; FONT-FAMILY: 'Courier New'">jdbcType</SPAN></FONT><FONT 
face="Courier New" color=black size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: black; FONT-FAMILY: 'Courier New'">=</SPAN></FONT><FONT 
face="Courier New" color=#2a00ff size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #2a00ff; FONT-FAMILY: 'Courier New'">"VARCHAR" 
</SPAN></FONT><FONT face="Courier New" color=#7f007f size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #7f007f; FONT-FAMILY: 'Courier New'">javaType</SPAN></FONT><FONT 
face="Courier New" color=black size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: black; FONT-FAMILY: 'Courier New'">=</SPAN></FONT><FONT 
face="Courier New" color=#2a00ff size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #2a00ff; FONT-FAMILY: 'Courier New'">"java.lang.String" 
</SPAN></FONT><FONT face="Courier New" color=#7f007f size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #7f007f; FONT-FAMILY: 'Courier New'">mode</SPAN></FONT><FONT 
face="Courier New" color=black size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: black; FONT-FAMILY: 'Courier New'">=</SPAN></FONT><FONT 
face="Courier New" color=#2a00ff size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #2a00ff; FONT-FAMILY: 'Courier New'">"IN"</SPAN></FONT><FONT 
face="Courier New" color=teal size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: teal; FONT-FAMILY: 'Courier New'">/&gt;</SPAN></FONT><FONT 
face="Courier New" size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" color=black size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: black; FONT-FAMILY: 'Courier New'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></FONT><FONT face="Courier New" color=teal size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: teal; FONT-FAMILY: 'Courier New'">&lt;</SPAN></FONT><FONT 
face="Courier New" color=#3f7f7f size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #3f7f7f; FONT-FAMILY: 'Courier New'">parameter 
</SPAN></FONT><FONT face="Courier New" color=#7f007f size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #7f007f; FONT-FAMILY: 'Courier New'">property 
</SPAN></FONT><FONT face="Courier New" color=black size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: black; FONT-FAMILY: 'Courier New'">=</SPAN></FONT><FONT 
face="Courier New" color=#2a00ff size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #2a00ff; FONT-FAMILY: 'Courier New'">"id_service" 
</SPAN></FONT><FONT face="Courier New" color=#7f007f size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #7f007f; FONT-FAMILY: 'Courier New'">jdbcType</SPAN></FONT><FONT 
face="Courier New" color=black size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: black; FONT-FAMILY: 'Courier New'">=</SPAN></FONT><FONT 
face="Courier New" color=#2a00ff size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #2a00ff; FONT-FAMILY: 'Courier New'">"VARCHAR" 
</SPAN></FONT><FONT face="Courier New" color=#7f007f size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #7f007f; FONT-FAMILY: 'Courier New'">javaType</SPAN></FONT><FONT 
face="Courier New" color=black size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: black; FONT-FAMILY: 'Courier New'">=</SPAN></FONT><FONT 
face="Courier New" color=#2a00ff size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #2a00ff; FONT-FAMILY: 'Courier New'">"java.lang.String" 
</SPAN></FONT><FONT face="Courier New" color=#7f007f size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #7f007f; FONT-FAMILY: 'Courier New'">mode</SPAN></FONT><FONT 
face="Courier New" color=black size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: black; FONT-FAMILY: 'Courier New'">=</SPAN></FONT><FONT 
face="Courier New" color=#2a00ff size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #2a00ff; FONT-FAMILY: 'Courier New'">"IN"</SPAN></FONT><FONT 
face="Courier New" color=teal size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: teal; FONT-FAMILY: 'Courier New'">/&gt;</SPAN></FONT><FONT 
face="Courier New" color=black size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: black; FONT-FAMILY: 'Courier New'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></FONT><FONT face="Courier New" size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" color=black size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: black; FONT-FAMILY: 'Courier New'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></FONT><FONT face="Courier New" color=teal size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: teal; FONT-FAMILY: 'Courier New'">&lt;</SPAN></FONT><FONT 
face="Courier New" color=#3f7f7f size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #3f7f7f; FONT-FAMILY: 'Courier New'">parameter 
</SPAN></FONT><FONT face="Courier New" color=#7f007f size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #7f007f; FONT-FAMILY: 'Courier New'">property 
</SPAN></FONT><FONT face="Courier New" color=black size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: black; FONT-FAMILY: 'Courier New'">=</SPAN></FONT><FONT 
face="Courier New" color=#2a00ff size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #2a00ff; FONT-FAMILY: 'Courier New'">"app_action_string" 
</SPAN></FONT><FONT face="Courier New" color=#7f007f size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #7f007f; FONT-FAMILY: 'Courier New'">jdbcType</SPAN></FONT><FONT 
face="Courier New" color=black size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: black; FONT-FAMILY: 'Courier New'">=</SPAN></FONT><FONT 
face="Courier New" color=#2a00ff size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #2a00ff; FONT-FAMILY: 'Courier New'">"VARCHAR" 
</SPAN></FONT><FONT face="Courier New" color=#7f007f size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #7f007f; FONT-FAMILY: 'Courier New'">javaType</SPAN></FONT><FONT 
face="Courier New" color=black size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: black; FONT-FAMILY: 'Courier New'">=</SPAN></FONT><FONT 
face="Courier New" color=#2a00ff size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #2a00ff; FONT-FAMILY: 'Courier New'">"java.lang.String" 
</SPAN></FONT><FONT face="Courier New" color=#7f007f size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #7f007f; FONT-FAMILY: 'Courier New'">mode</SPAN></FONT><FONT 
face="Courier New" color=black size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: black; FONT-FAMILY: 'Courier New'">=</SPAN></FONT><FONT 
face="Courier New" color=#2a00ff size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #2a00ff; FONT-FAMILY: 'Courier New'">"IN"</SPAN></FONT><FONT 
face="Courier New" color=teal size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: teal; FONT-FAMILY: 'Courier New'">/&gt;</SPAN></FONT><FONT 
face="Courier New" color=black size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: black; FONT-FAMILY: 'Courier New'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></FONT><FONT face="Courier New" size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" color=black size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: black; FONT-FAMILY: 'Courier New'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></FONT><FONT face="Courier New" color=teal size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: teal; FONT-FAMILY: 'Courier New'">&lt;</SPAN></FONT><FONT 
face="Courier New" color=#3f7f7f size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #3f7f7f; FONT-FAMILY: 'Courier New'">parameter 
</SPAN></FONT><FONT face="Courier New" color=#7f007f size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #7f007f; FONT-FAMILY: 'Courier New'">property 
</SPAN></FONT><FONT face="Courier New" color=black size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: black; FONT-FAMILY: 'Courier New'">=</SPAN></FONT><FONT 
face="Courier New" color=#2a00ff size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #2a00ff; FONT-FAMILY: 'Courier New'">"total_capacity" 
</SPAN></FONT><FONT face="Courier New" color=#7f007f size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #7f007f; FONT-FAMILY: 'Courier New'">jdbcType</SPAN></FONT><FONT 
face="Courier New" color=black size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: black; FONT-FAMILY: 'Courier New'">=</SPAN></FONT><FONT 
face="Courier New" color=#2a00ff size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #2a00ff; FONT-FAMILY: 'Courier New'">"INTEGER" 
</SPAN></FONT><FONT face="Courier New" color=#7f007f size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #7f007f; FONT-FAMILY: 'Courier New'">javaType</SPAN></FONT><FONT 
face="Courier New" color=black size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: black; FONT-FAMILY: 'Courier New'">=</SPAN></FONT><FONT 
face="Courier New" color=#2a00ff size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #2a00ff; FONT-FAMILY: 'Courier New'">"java.lang.Integer" 
</SPAN></FONT><FONT face="Courier New" color=#7f007f size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #7f007f; FONT-FAMILY: 'Courier New'">mode</SPAN></FONT><FONT 
face="Courier New" color=black size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: black; FONT-FAMILY: 'Courier New'">=</SPAN></FONT><FONT 
face="Courier New" color=#2a00ff size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #2a00ff; FONT-FAMILY: 'Courier New'">"IN"</SPAN></FONT><FONT 
face="Courier New" color=teal size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: teal; FONT-FAMILY: 'Courier New'">/&gt;</SPAN></FONT><FONT 
face="Courier New" size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" color=black size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: black; FONT-FAMILY: 'Courier New'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></FONT><FONT face="Courier New" color=teal size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: teal; FONT-FAMILY: 'Courier New'">&lt;</SPAN></FONT><FONT 
face="Courier New" color=#3f7f7f size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #3f7f7f; FONT-FAMILY: 'Courier New'">parameter 
</SPAN></FONT><FONT face="Courier New" color=#7f007f size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #7f007f; FONT-FAMILY: 'Courier New'">property 
</SPAN></FONT><FONT face="Courier New" color=black size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: black; FONT-FAMILY: 'Courier New'">=</SPAN></FONT><FONT 
face="Courier New" color=#2a00ff size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #2a00ff; FONT-FAMILY: 'Courier New'">"dt_effective" 
</SPAN></FONT><FONT face="Courier New" color=#7f007f size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #7f007f; FONT-FAMILY: 'Courier New'">jdbcType</SPAN></FONT><FONT 
face="Courier New" color=black size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: black; FONT-FAMILY: 'Courier New'">=</SPAN></FONT><FONT 
face="Courier New" color=#2a00ff size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #2a00ff; FONT-FAMILY: 'Courier New'">"DATE" 
</SPAN></FONT><FONT face="Courier New" color=#7f007f size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #7f007f; FONT-FAMILY: 'Courier New'">javaType</SPAN></FONT><FONT 
face="Courier New" color=black size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: black; FONT-FAMILY: 'Courier New'">=</SPAN></FONT><FONT 
face="Courier New" color=#2a00ff size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #2a00ff; FONT-FAMILY: 'Courier New'">"java.util.Date" 
</SPAN></FONT><FONT face="Courier New" color=#7f007f size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #7f007f; FONT-FAMILY: 'Courier New'">mode</SPAN></FONT><FONT 
face="Courier New" color=black size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: black; FONT-FAMILY: 'Courier New'">=</SPAN></FONT><FONT 
face="Courier New" color=#2a00ff size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #2a00ff; FONT-FAMILY: 'Courier New'">"IN"</SPAN></FONT><FONT 
face="Courier New" color=teal size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: teal; FONT-FAMILY: 'Courier New'">/&gt;</SPAN></FONT><FONT 
face="Courier New" color=black size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: black; FONT-FAMILY: 'Courier New'"> 
</SPAN></FONT><FONT face="Courier New" size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" color=black size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: black; FONT-FAMILY: 'Courier New'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></FONT><FONT face="Courier New" color=teal size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: teal; FONT-FAMILY: 'Courier New'">&lt;</SPAN></FONT><FONT 
face="Courier New" color=#3f7f7f size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #3f7f7f; FONT-FAMILY: 'Courier New'">parameter 
</SPAN></FONT><FONT face="Courier New" color=#7f007f size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #7f007f; FONT-FAMILY: 'Courier New'">property 
</SPAN></FONT><FONT face="Courier New" color=black size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: black; FONT-FAMILY: 'Courier New'">=</SPAN></FONT><FONT 
face="Courier New" color=#2a00ff size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #2a00ff; FONT-FAMILY: 'Courier New'">"total_fee"&nbsp; 
</SPAN></FONT><FONT face="Courier New" color=#7f007f size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #7f007f; FONT-FAMILY: 'Courier New'">javaType</SPAN></FONT><FONT 
face="Courier New" color=black size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: black; FONT-FAMILY: 'Courier New'">=</SPAN></FONT><FONT 
face="Courier New" color=#2a00ff size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #2a00ff; FONT-FAMILY: 'Courier New'">"java.math.BigDecimal"&nbsp; 
</SPAN></FONT><FONT face="Courier New" color=#7f007f size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #7f007f; FONT-FAMILY: 'Courier New'">jdbcType</SPAN></FONT><FONT 
face="Courier New" color=black size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: black; FONT-FAMILY: 'Courier New'">=</SPAN></FONT><FONT 
face="Courier New" color=#2a00ff size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #2a00ff; FONT-FAMILY: 'Courier New'">"DECIMAL" 
&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;</SPAN></FONT><FONT face="Courier New" 
color=#7f007f size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #7f007f; FONT-FAMILY: 'Courier New'">mode</SPAN></FONT><FONT 
face="Courier New" color=black size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: black; FONT-FAMILY: 'Courier New'">=</SPAN></FONT><FONT 
face="Courier New" color=#2a00ff size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #2a00ff; FONT-FAMILY: 'Courier New'">"INOUT"</SPAN></FONT><FONT 
face="Courier New" color=teal size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: teal; FONT-FAMILY: 'Courier New'">/&gt;</SPAN></FONT><FONT 
face="Courier New" size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" color=black size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: black; FONT-FAMILY: 'Courier New'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></FONT><FONT face="Courier New" color=teal size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: teal; FONT-FAMILY: 'Courier New'">&lt;/</SPAN></FONT><FONT 
face="Courier New" color=#3f7f7f size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #3f7f7f; FONT-FAMILY: 'Courier New'">parameterMap</SPAN></FONT><FONT 
face="Courier New" color=teal size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: teal; FONT-FAMILY: 'Courier New'">&gt;</SPAN></FONT><FONT 
face="Courier New" color=black size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: black; FONT-FAMILY: 'Courier New'">&nbsp;&nbsp; 
</SPAN></FONT><FONT face="Courier New" size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" color=black size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: black; FONT-FAMILY: 'Courier New'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></FONT><FONT face="Courier New" size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" color=black size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: black; FONT-FAMILY: 'Courier New'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></FONT><FONT face="Courier New" color=teal size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: teal; FONT-FAMILY: 'Courier New'">&lt;</SPAN></FONT><FONT 
face="Courier New" color=#3f7f7f size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #3f7f7f; FONT-FAMILY: 'Courier New'">procedure 
</SPAN></FONT><FONT face="Courier New" color=#7f007f size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #7f007f; FONT-FAMILY: 'Courier New'">id</SPAN></FONT><FONT 
face="Courier New" color=black size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: black; FONT-FAMILY: 'Courier New'">=</SPAN></FONT><FONT 
face="Courier New" color=#2a00ff size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #2a00ff; FONT-FAMILY: 'Courier New'">"bedsCalcFee" 
</SPAN></FONT><FONT face="Courier New" color=#7f007f size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #7f007f; FONT-FAMILY: 'Courier New'">parameterMap</SPAN></FONT><FONT 
face="Courier New" color=black size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: black; FONT-FAMILY: 'Courier New'">=</SPAN></FONT><FONT 
face="Courier New" color=#2a00ff size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #2a00ff; FONT-FAMILY: 'Courier New'">"bedsCalcFeeParam" 
</SPAN></FONT><FONT face="Courier New" color=#7f007f size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #7f007f; FONT-FAMILY: 'Courier New'">resultClass</SPAN></FONT><FONT 
face="Courier New" color=black size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: black; FONT-FAMILY: 'Courier New'">=</SPAN></FONT><FONT 
face="Courier New" color=#2a00ff size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #2a00ff; FONT-FAMILY: 'Courier New'">"java.util.HashMap"</SPAN></FONT><FONT 
face="Courier New" color=teal size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: teal; FONT-FAMILY: 'Courier New'">&gt;</SPAN></FONT><FONT 
face="Courier New" size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" color=black size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: black; FONT-FAMILY: 'Courier New'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
{call proc_calculate_fee_opa (?,?,?,?,?,?)}</SPAN></FONT><FONT 
face="Courier New" size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" color=black size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: black; FONT-FAMILY: 'Courier New'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></FONT><FONT face="Courier New" color=teal size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: teal; FONT-FAMILY: 'Courier New'">&lt;/</SPAN></FONT><FONT 
face="Courier New" color=#3f7f7f size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: #3f7f7f; FONT-FAMILY: 'Courier New'">procedure</SPAN></FONT><FONT 
face="Courier New" color=teal size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: teal; FONT-FAMILY: 'Courier New'">&gt;</SPAN></FONT><FONT 
face="Courier New" color=black size=2><SPAN 
style="FONT-SIZE: 10pt; BACKGROUND: white; COLOR: black; FONT-FAMILY: 'Courier New'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></FONT><o:p></o:p></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p>&nbsp;</o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p>&nbsp;</o:p></SPAN></FONT></P></DIV></BODY></HTML>

Mime
View raw message