错误[42000] [Oracle] [ODBC] [Ora] ORA-00900：无效的SQL语句 [英] ERROR [42000] [Oracle][ODBC][Ora]ORA-00900: invalid SQL statement

问题描述

Protected Sub BTNINSERT_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles BTNINSERT.Click
        CON = New OdbcConnection("DSN=DBLOG;Driver=(Oracle in XE);UID=system;PWD=SYS;SERVER=localhost;")
        CON.Open()
        MsgBox("successfully opened")
        comm = New OdbcCommand("INSERTLOG", CON)
        comm.CommandType = CommandType.StoredProcedure
        comm.Parameters.AddWithValue("ID_", TXTID.Text)
        comm.Parameters.AddWithValue("STUDENTNAME_", TXTNAME.Text)
        comm.Parameters.AddWithValue("DEPARTMENT_", TXTDEPART.Text)
        comm.Parameters.AddWithValue("YEAR_", TXTYEAR.Text)
        a = comm.ExecuteNonQuery
        If a > 0 Then
            MsgBox("success")
        Else
            MsgBox("failed")

        End If
        CON.Close()
        MsgBox("successfully closed")

推荐答案

您好，



尝试替换：

Hello,

Try replacing:

comm = New OdbcCommand("INSERTLOG", CON)

comm = New OdbcCommand("{call INSERTLOG(?, ?, ?, ?)}", CON)

可以从 http：// support获取更多信息.microsoft.com / kb / 310130 [ ^ ] 。



问候，

More info can sought from http://support.microsoft.com/kb/310130[^].

Regards,

这篇关于错误[42000] [Oracle] [ODBC] [Ora] ORA-00900：无效的SQL语句的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！