C# – How to get oracle long raw type value

by

Since you haven’t posted any code, I don’t know how much you know. I’m going to assume you already understand how to execute a query and get back a result set using OracleDataReader.

There is one gotcha with LONG and LONG RAW columns. You must set the InitialLONGFetchSize property of your OracleCommand to a non-zero value.

The default value of InitialLONGFetchSize is zero, which means no data will be retrieved for LONG or LONG RAW columns. If you set it to -1, all data will be retrieved . You might not want to do this for large values. If you set it to anything above zero, that’s how many bytes will be intially fetched and cached.

You should read the documentation for InitialLONGFetchSize, because there are some other details you need to know.

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. OracleCommand SQL Parameters Binding
  6. Handling ExecuteScalar() when no results are returned
  7. Calling Oracle stored procedure from C#?
  8. Can the Oracle managed driver use async/await properly?
  9. Sending an array of values to Oracle procedure to use in WHERE IN clause
  10. C# parameterized queries for Oracle – serious & dangerous bug!
  11. How to implement batch fetching with Fluent NHibernate when working with Oracle?
  12. How can I deploy a .NET application that uses ODAC without installing the whole component to the user?
  13. OracleParameter and IN Clause
  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. What is the best way to store user settings for a .NET application?
  29. How do closures work behind the scenes? (C#)
  30. How to add OpenIdConnect via IdentityServer4 to ASP.NET Core ServerSide Blazor web app?

Leave a Comment