错误:ORA-01008:不是VB.Net中绑定的所有变量 [英] Error: ORA-01008: not all variables bound in VB.Net

问题描述

我在这里需要帮助...我不太擅长在VB.Net中使用Oracle Connection.我遇到了以上错误:ORA-01008:并非所有变量都绑定.
下面是我在VB.Net中的代码.谢谢您能帮助我解决问题.谢谢.

I need help here...I''m not good in using Oracle Connection in VB.Net. I encountered the above error: ORA-01008: not all variables bound.
Below are my codes in VB.Net. Appreciate if you could help me to resolve the problem. Thank you.

Dim iRet As Integer = 0
sSql = "INSERT INTO RECIPEINFO VALUES('" & sRecipeName & _
"','" & sMcNo & "','" & sMcType & "','" & sLotNo & "','" & sDevice & _
"','" & sRecipeStatus & "','" & sEmpNo & "','" & sIndicator & "','" & sMode & "',:DateTime,:Data)"
'cmd = New SqlCommand(sSql, myConnection)
cmd = New OracleCommand(sSql, myConnection)

cmd.Parameters.Add(New OracleParameter(":Data", OracleDbType.Blob, 500, "Data"))
cmd.Parameters.Item(":Data").Value = buffer

'executing the command and assigning it to connection
iRet = cmd.ExecuteNonQuery()
cmd = Nothing
myConnection.Close()

推荐答案

您必须像为:Data所做的那样为:DateTime添加参数，或删除从您的sql

You must add a parameter for :DateTime like you''ve done for :Data, or remove :DateTime from your sql

这篇关于错误:ORA-01008:不是VB.Net中绑定的所有变量的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！