oracle 存储过程多表操作代码,PLSQL代码库,德仔网

代码语言
代码分类
【PLSQL】 oracle 存储过程多表操作
作者:Dezai.CN / 发布于2011/8/7/ 926
<div>
<pre><span style="color: rgb(0,0,0)">CREATE OR REPLACE Procedure P_WEB_MEMBERINFOR(      p_memberid In Varchar2,      member_Resultset In Out Pkg_Return_Resultset.Resultset, </span><span style="color: rgb(0,0,0)">--</span><span style="color: rgb(0,0,0)">返回结果集      money_Resultset In Out Pkg_Return_Resultset.Resultset, </span><span style="color: rgb(0,0,0)">--</span><span style="color: rgb(0,0,0)">返回结果集      point_Resultset In Out Pkg_Return_Resultset.Resultset, </span><span style="color: rgb(0,0,0)">--</span><span style="color: rgb(0,0,0)">返回结果集      email_Resultset In Out Pkg_Return_Resultset.Resultset </span><span style="color: rgb(0,0,0)">--</span><span style="color: rgb(0,0,0)">返回结果集)AsBegin  Open member_Resultset For       Select </span><span style="color: rgb(0,0,0)">*</span><span style="color: rgb(0,0,0)"> from T_WEB_BUYERMEMBERS Where MEMBERID </span><span style="color: rgb(0,0,0)">=</span><span style="color: rgb(0,0,0)"> p_memberid;  Open money_Resultset For       Select </span><span style="color: rgb(0,0,0)">*</span><span style="color: rgb(0,0,0)"> From DD_YWXT.T_JS_YW_CZJL Where MEMBERID </span><span style="color: rgb(0,0,0)">=</span><span style="color: rgb(0,0,0)"> p_memberid;  Open point_Resultset For       Select </span><span style="color: rgb(0,0,0)">*</span><span style="color: rgb(0,0,0)"> From T_WEB_POINT Where MEMBERID </span><span style="color: rgb(0,0,0)">=</span><span style="color: rgb(0,0,0)"> p_memberid;  Open email_Resultset For       Select </span><span style="color: rgb(0,0,0)">*</span><span style="color: rgb(0,0,0)"> From T_WEB_EMAIL Where EMAILTO </span><span style="color: rgb(0,0,0)">=</span><span style="color: rgb(0,0,0)"> p_memberid;End;</span></pre>
　　
C#调用
<div class="cnblogs_code">
<pre><span style="color: rgb(0,0,255)">public</span><span style="color: rgb(0,0,0)"> DataSet GetUserInfor(</span><span style="color: rgb(0,0,255)">string</span><span style="color: rgb(0,0,0)"> memberid)        {            OracleParameter[] parameters </span><span style="color: rgb(0,0,0)">=</span><span style="color: rgb(0,0,0)"> {                    </span><span style="color: rgb(0,0,255)">new</span><span style="color: rgb(0,0,0)"> OracleParameter(</span><span style="color: rgb(128,0,0)">"</span><span style="color: rgb(128,0,0)">p_memberid</span><span style="color: rgb(128,0,0)">"</span><span style="color: rgb(0,0,0)">, OracleType.VarChar, </span><span style="color: rgb(128,0,128)">255</span><span style="color: rgb(0,0,0)">),                    </span><span style="color: rgb(0,0,255)">new</span><span style="color: rgb(0,0,0)"> OracleParameter(</span><span style="color: rgb(128,0,0)">"</span><span style="color: rgb(128,0,0)">member_Resultset</span><span style="color: rgb(128,0,0)">"</span><span style="color: rgb(0,0,0)">, OracleType.Cursor),                    </span><span style="color: rgb(0,0,255)">new</span><span style="color: rgb(0,0,0)"> OracleParameter(</span><span style="color: rgb(128,0,0)">"</span><span style="color: rgb(128,0,0)">money_Resultset</span><span style="color: rgb(128,0,0)">"</span><span style="color: rgb(0,0,0)">, OracleType.Cursor),                    </span><span style="color: rgb(0,0,255)">new</span><span style="color: rgb(0,0,0)"> OracleParameter(</span><span style="color: rgb(128,0,0)">"</span><span style="color: rgb(128,0,0)">point_Resultset</span><span style="color: rgb(128,0,0)">"</span><span style="color: rgb(0,0,0)">, OracleType.Cursor),                    </span><span style="color: rgb(0,0,255)">new</span><span style="color: rgb(0,0,0)"> OracleParameter(</span><span style="color: rgb(128,0,0)">"</span><span style="color: rgb(128,0,0)">email_Resultset</span><span style="color: rgb(128,0,0)">"</span><span style="color: rgb(0,0,0)">, OracleType.Cursor),                    };            parameters[</span><span style="color: rgb(128,0,128)">0</span><span style="color: rgb(0,0,0)">].Value </span><span style="color: rgb(0,0,0)">=</span><span style="color: rgb(0,0,0)"> memberid;            parameters[</span><span style="color: rgb(128,0,128)">1</span><span style="color: rgb(0,0,0)">].Direction </span><span style="color: rgb(0,0,0)">=</span><span style="color: rgb(0,0,0)"> ParameterDirection.Output;            parameters[</span><span style="color: rgb(128,0,128)">2</span><span style="color: rgb(0,0,0)">].Direction </span><span style="color: rgb(0,0,0)">=</span><span style="color: rgb(0,0,0)"> ParameterDirection.Output;            parameters[</span><span style="color: rgb(128,0,128)">3</span><span style="color: rgb(0,0,0)">].Direction </span><span style="color: rgb(0,0,0)">=</span><span style="color: rgb(0,0,0)"> ParameterDirection.Output;            parameters[</span><span style="color: rgb(128,0,128)">4</span><span style="color: rgb(0,0,0)">].Direction </span><span style="color: rgb(0,0,0)">=</span><span style="color: rgb(0,0,0)"> ParameterDirection.Output;            </span><span style="color: rgb(0,0,255)">return</span><span style="color: rgb(0,0,0)"> DbHelperOra.RunProcedureCXF(</span><span style="color: rgb(128,0,0)">"</span><span style="color: rgb(128,0,0)">P_WEB_MEMBERINFOR</span><span style="color: rgb(128,0,0)">"</span><span style="color: rgb(0,0,0)">, parameters, </span><span style="color: rgb(128,0,0)">"</span><span style="color: rgb(128,0,0)">ds</span><span style="color: rgb(128,0,0)">"</span><span style="color: rgb(0,0,0)">);        } </span><span style="color: rgb(0,0,255)">public</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">static</span><span style="color: rgb(0,0,0)"> DataSet RunProcedureCXF(</span><span style="color: rgb(0,0,255)">string</span><span style="color: rgb(0,0,0)"> storedProcName, IDataParameter[] parameters, </span><span style="color: rgb(0,0,255)">string</span><span style="color: rgb(0,0,0)"> tableName)        {            </span><span style="color: rgb(0,0,255)">using</span><span style="color: rgb(0,0,0)"> (OracleConnection connection </span><span style="color: rgb(0,0,0)">=</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">new</span><span style="color: rgb(0,0,0)"> OracleConnection(connectionString)) {                DataSet dataSet </span><span style="color: rgb(0,0,0)">=</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">new</span><span style="color: rgb(0,0,0)"> DataSet();                connection.Open();                OracleDataAdapter sqlDA </span><span style="color: rgb(0,0,0)">=</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">new</span><span style="color: rgb(0,0,0)"> OracleDataAdapter();                sqlDA.SelectCommand </span><span style="color: rgb(0,0,0)">=</span><span style="color: rgb(0,0,0)"> BuildQueryCommand(connection, storedProcName, parameters);                sqlDA.Fill(dataSet);                connection.Close();                </span><span style="color: rgb(0,0,255)">return</span><span style="color: rgb(0,0,0)"> dataSet;            }        }</span></pre>
</div>
</div>
试试其它关键字
　oracle　　存储过程　
同语言下
可能有用的
Dezai.CN贡献的其它代码(4037)