我寫了個查詢的存盤程序：
CREATE OR REPLACE PROCEDURE QUERY_WORD
(WORD_IN IN WORD.WORD%TYPE,ID_IN IN WORD.ID%TYPE,TRANS_OUT OUT WORD.TRANSLATION%TYPE)
as trans varchar2(100);
BEGIN
SELECT translation into trans FROM WORD WHERE WORD = WORD_IN AND ID = ID_IN;
TRANS_OUT := trans;
END QUERY_WORD;
用VS2012呼叫如下：
sql.Format(_T("call QUERY_WORD('%s','%s','%s');"),word,id,translation);
TRACE(sql);
m_db.ExecuteSQL(sql);
運行錯誤是沒有系結變數，要怎樣呼叫才能向存盤程序中傳入變數translation呢
uj5u.com熱心網友回復：
string ss = DateTime.Now.ToString();string str = "Data Source=.;uid=sa;pwd=1107;Integrated Security=SSPI;database=05-08-2014;Integrated Security=True";
conn = new SqlConnection(str);
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
SqlCommand cmd = new SqlCommand("存盤程序名 '" , conn);
cmd.CommandType=CommandType.StoredProcedure;
cmd.Parameters.Add("Parm1");
cmd.Parameters["Parm1"].Direction = ParameterDirection.Input;
cmd.Parameters["Parm1"].Value = ss;
cmd.ExecuteNonQuery();
uj5u.com熱心網友回復：
要獲取回傳的結果用executereader()
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/38355.html
標籤：DataWindow
上一篇：大家好關于合并DW
下一篇：編譯成PBD報錯