0 Replies Latest reply on Sep 10, 2012 1:38 PM by 571158

    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")