OracleCommand SQL Parameters Binding

by

Remove single quotes around @username, and with respect to oracle use : with parameter name instead of @, like:

OracleCommand oraCommand = new OracleCommand("SELECT fullname FROM sup_sys.user_profile
                           WHERE domain_user_name = :userName", db);
oraCommand.Parameters.Add(new OracleParameter("userName", domainUser));

Source: Using Parameters

More Related Contents:

  1. The provider is not compatible with the version of Oracle client
  2. OdbcConnection returning Chinese Characters as “?”
  3. How to execute an .SQL script file using c#
  4. What is the minimum client footprint required to connect C# to an Oracle database?
  5. Handling ExecuteScalar() when no results are returned
  6. Calling Oracle stored procedure from C#?
  7. Can the Oracle managed driver use async/await properly?
  8. Sending an array of values to Oracle procedure to use in WHERE IN clause
  9. C# parameterized queries for Oracle – serious & dangerous bug!
  10. How to implement batch fetching with Fluent NHibernate when working with Oracle?
  11. How can I deploy a .NET application that uses ODAC without installing the whole component to the user?
  12. OracleParameter and IN Clause
  13. C# – How to get oracle long raw type value
  14. Connecting to Oracle Database through C#?
  15. Execute multiple queries in single Oracle command in C#
  16. ORA-01008: not all variables bound. They are bound
  17. Oracle Parameters with IN statement?
  18. OraOLEDB.Oracle provider is not registered on the local machine
  19. problem using Oracle parameters in SELECT IN
  20. Convert from Oracle’s RAW(16) to .NET’s GUID
  21. C#: Oracle Data Type Equivalence with OracleDbType
  22. How to return oracle output parameters from a stored procedure in .NET
  23. Entity Framework and multiple schemas
  24. Insert blob in oracle database with C#
  25. ODP.NET Managed library does resolve alias, but 32-bit library does
  26. Why would Oracle.ManagedDataAccess not work when Oracle.DataAccess does?
  27. Oracle Entity Framework – Generate Entity From Tables in Different Schema
  28. ORA-00911: invalid character
  29. Can’t add script component because the script class cannot be found?
  30. What is the difference between Server.MapPath and HostingEnvironment.MapPath?

Leave a Comment