Results 1 to 5 of 5

Thread: Ora-00936

  1. #1
    Join Date
    Sep 2003
    Posts
    66

    Exclamation Unanswered: Ora-00936

    What shall I do with it, my code as follow:
    connStr = "Provider=OraOLEDB.Oracle.1; User ID=DM; Data Source=LXBNET; Password=REDHAT; "
    Dim query As String = "SELECT * FROM HU.TESTCASE;"
    query = query
    Try
    Dim conn As OleDb.OleDbConnection = New OleDb.OleDbConnection(connStr)
    Dim myCommand As New OleDb.OleDbCommand(query, conn)
    myCommand.Connection.Open()
    myCommand.ExecuteNonQuery()
    conn.Close()
    Catch e As Exception
    ' connection unAvailable
    MessageBox.Show(e.Message)
    Return False
    End Try
    Thanks.

  2. #2
    Join Date
    Sep 2003
    Posts
    66
    my platform: VB.net -> Oledb(ora oledb for 9i) ->Ora9i

  3. #3
    Join Date
    Sep 2003
    Posts
    66
    who can help me del this post ??

  4. #4
    Join Date
    Aug 2002
    Location
    SHANGHAI,CHINA
    Posts
    20
    search oracle 9i online document about Ora-00936 message.

  5. #5
    Join Date
    Aug 2002
    Location
    SHANGHAI,CHINA
    Posts
    20
    ORA-00936 missing expression

    Cause: A required part of a clause or expression has been omitted. For example, a SELECT statement may have been entered without a list of columns or expressions or with an incomplete expression. This message is also issued in cases where a reserved word is misused, as in SELECT TABLE.

    Action: Check the statement syntax and specify the missing component.

    No select statement in your code.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •