Help: Oracle Parameter - Resource File RRS feed

  • Question

  • Hi, I am trying to pass a oracle parameter to a resource file.

    The query is like

    Select * from TableName where Column1 like :Param

    The column1 is a number field, and I need to pass parameter like '%123%'

    I am passing parameter this way..

    Dim db As Database = DatabaseFactory.CreateDatabase("OracleConnection")
    Dim dbCommand As OracleCommand = db.GetSqlStringCommand(_resMgrTables.GetString("Query"))
    db.AddInParameter(dbCommand, "Param", DbType.Double, ???????????)

    Please let me know how should I pass the parameter

    Monday, August 6, 2012 9:43 AM