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


  • Hi,

    You may take a look on String.Format() and  ResourceManager class. 

    I hope it helps.


    There are 10 type of people. Those who understand binary and those who do not.

    My Blog | Hire Me

    Monday, August 6, 2012 1:56 PM