0 Replies Latest reply: Sep 10, 2012 8:38 AM by 571158 RSS

    clearing Oracle Parameters to call diferent stored procs

    571158
      Sub Main

      Do While i < 3
      make_excel(i)

      i = i + 1

      Loop
      end Sub


      Sub make_excel(ByVal array As Integer)
      objCmd.Parameters.Add(New OracleParameter("p_cursor", OracleType.Cursor)).Direction = ParameterDirection.Output
      end Sub

      objCmd.Parameters.Clear()
      objCmd.Parameters.Remove("p_cursor")