locked
how can i execute multiple sql in oracle? RRS feed

  • Question

  • User-1909885141 posted

    hi, 

    I need to run 3 multi sql.

    below is my source code and there is an error because oracle database does not acccept ";".

    How can i run multi sql and put result to dataset?

    sQueryString, ="select * from people; select * from megi2;"

    Dim SQLConn As New OleDbConnection '//데이타베이스 연결
    Dim adapter As OleDbDataAdapter = New OleDbDataAdapter
    adapter = New OleDbDataAdapter(sQueryString, SQLConn)
    Dim return_dt As DataSet = New DataSet
    adapter.Fill(return_dt, "returnDataSet")

    Thursday, February 7, 2013 4:25 AM

All replies

  • User179837873 posted

    Write Procedure for multiple queries  and oldbDataReader for that and Read.NextResult() will give you second slection result.

    Thursday, February 7, 2013 4:28 AM