java procedure streamingserver.naming-sql.xml

最新推荐文章于 2022-04-26 09:06:04 发布

flash8627

最新推荐文章于 2022-04-26 09:06:04 发布

阅读量1.5k

点赞数

分类专栏： oracle 文章标签： java integer parameters sql encoding

本文链接：https://blog.csdn.net/flash8627/article/details/7788300

版权

oracle 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

<?xml version="1.0" encoding="UTF-8"?>
<sqlmap xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

   <sql id="p_ibamp_streamingserver_qr" type="proc">
       <content>p_ibamp_streamingserver_qr</content>
       <parameters>
           <parameter id="str_provinceid" jdbc-type="VARCHAR"
               param-type="IN" />
           <parameter id="i_querytype" jdbc-type="INTEGER" param-type="IN" />
           <parameter id="i_curPage" jdbc-type="INTEGER" param-type="IN" />
           <parameter id="i_pageSize" jdbc-type="INTEGER" param-type="IN" />
           <parameter id="i_rowcount" jdbc-type="INTEGER" param-type="OUT" />
           <parameter id="cur_result" jdbc-type="CURSOR" param-type="OUT" />
           <parameter id="i_result" jdbc-type="INTEGER" param-type="OUT" />
       </parameters>
   </sql>

   <sql id="p_ibamp_provicename_pn_qr" type="proc">
       <content>p_ibamp_provicename_qr</content>
       <parameters>
           <parameter id="cur_result" jdbc-type="CURSOR" param-type="OUT" />
           <parameter id="i_result" jdbc-type="INTEGER" param-type="OUT" />
       </parameters>
   </sql>

   <sql id="p_ibamp_streamingserver_id_qr" type="proc">
       <content>p_ibamp_streamingserver_id_qr</content>
       <parameters>
           <parameter id="cur_result" jdbc-type="CURSOR" param-type="OUT" />
           <parameter id="i_result" jdbc-type="INTEGER" param-type="OUT" />
       </parameters>
   </sql>

   <sql id="p_ibamp_streamingserver_add" type="proc">
       <content>p_ibamp_streamingserver_add</content>
       <parameters>
           <parameter id="str_provinceid" jdbc-type="VARCHAR"
               param-type="IN" />
           <parameter id="str_ip" jdbc-type="VARCHAR" param-type="IN" />
           <parameter id="i_port" jdbc-type="INTEGER" param-type="IN" />
           <parameter id="i_loadbalance" jdbc-type="INTEGER"
               param-type="IN" />
           <parameter id="i_result" jdbc-type="INTEGER" param-type="OUT" />
       </parameters>
   </sql>

   <sql id="p_ibamp_streamingserver_mod" type="proc">
       <content>p_ibamp_streamingserver_mod</content>
       <parameters>
           <parameter id="str_provinceid" jdbc-type="VARCHAR"
               param-type="IN" />
           <parameter id="str_ip" jdbc-type="VARCHAR" param-type="IN" />
           <parameter id="i_port" jdbc-type="INTEGER" param-type="IN" />
           <parameter id="i_loadbalance" jdbc-type="INTEGER"
               param-type="IN" />
           <parameter id="i_result" jdbc-type="INTEGER" param-type="OUT" />
       </parameters>
   </sql>
   <sql id="p_ibamp_streamingserver_del" type="proc">
       <content>p_ibamp_streamingserver_del</content>
       <parameters>
           <parameter id="str_provinceid" jdbc-type="VARCHAR"
               param-type="IN" />
           <parameter id="i_result" jdbc-type="INTEGER" param-type="OUT" />
       </parameters>
   </sql>
</sqlmap>