Oracle Stored Procedure multi-Table operations

Create or replace procedure p_web_memberinfor
(
P_memberid in varchar2,
Member_resultset in out pkg_return_resultset.resultset, -- return result set
Money_resultset in out pkg_return_resultset.resultset, -- return result set
Point_resultset in out pkg_return_resultset.resultset, -- return result set
Email_resultset in out pkg_return_resultset.resultset -- return result set
)
As

Begin
Open member_resultset
Select * From t_web_buyermembers where memberid = p_memberid;
Open money_resultset
Select * From dd_ywxt.t_js_yw_czjl where memberid = p_memberid;
Open point_resultset
Select * From t_web_point where memberid = p_memberid;
Open email_resultset
Select * From t_web_email where emailto = p_memberid;
End;

　　

C # Call

public DataSet GetUserInfor(string memberid)
        {
            OracleParameter[] parameters = {
new OracleParameter("p_memberid", OracleType.VarChar, 255),
new OracleParameter("member_Resultset", OracleType.Cursor),
new OracleParameter("money_Resultset", OracleType.Cursor),
new OracleParameter("point_Resultset", OracleType.Cursor),
new OracleParameter("email_Resultset", OracleType.Cursor),
                    };
            parameters[0].Value = memberid;
            parameters[1].Direction = ParameterDirection.Output;
            parameters[2].Direction = ParameterDirection.Output;
            parameters[3].Direction = ParameterDirection.Output;
            parameters[4].Direction = ParameterDirection.Output;
return DbHelperOra.RunProcedureCXF("P_WEB_MEMBERINFOR", parameters, "ds");
        }



public static DataSet RunProcedureCXF(string storedProcName, IDataParameter[] parameters, string tableName)
        {
using (OracleConnection connection = new OracleConnection(connectionString)) {
                DataSet dataSet = new DataSet();
                connection.Open();
                OracleDataAdapter sqlDA = new OracleDataAdapter();
                sqlDA.SelectCommand = BuildQueryCommand(connection, storedProcName, parameters);
                sqlDA.Fill(dataSet);
                connection.Close();
return dataSet;
            }
        }

　　

Loading editor...