what are the methods,properties and classes  i need to use in Microsoft.Practices.EnterpriseLibrary.Data.Oracle; namespace to call oracle stored procedures in my application.Please give response with an example.How to call simple stored procedure with parameters.

 You can find all what you ask in the Enterprise Library documentation / Data Access Application block section.

This is an example from the documentation:

Dim db As Database = DatabaseFactory.CreateDatabase()

Dim sqlCommand As String = "GetProductDetails"
Dim dbCommand As DbCommand = db.GetStoredProcCommand(sqlCommand)

db.AddInParameter(dbCommand, "ProductID", DbType.Int32, 3)
db.AddOutParameter(dbCommand, "ProductName", DbType.String, 50)
db.AddOutParameter(dbCommand, "UnitPrice", DbType.Currency, 8)

db.ExecuteNonQuery(dbCommand)

Dim results As String = String.Format(CultureInfo.CurrentCulture, "{0}, {1}, {2:C} ", _
  db.GetParameterValue(dbCommand, "ProductID"), _
  db.GetParameterValue(dbCommand, "ProductName"), _
  db.GetParameterValue(dbCommand, "UnitPrice"))