Re: Oracle Blob 4000byte limitation

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Chris Fink wrote:

> I am receiving the following error when I attempt to insert into a
> Blob field from a bytearray > 4000 bytes into Oracle 8i using OleDb.
>
> "ORA-01036: illegal variable name/number "
>
> In investigating this, it looks like ADO had a solution using the
> SPPrmsLOB parameter. How do I implement this solution in ADO.NET? or
> is there another workaround?

How about using the Oracle provider of .NET instead of OLEDB? Have you
tried that one?

Frans


--
------------------------------------------------------------------------
Get LLBLGen Pro, productive O/R mapping for .NET: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------
.

Relevant Pages

  • Re: CoInitialize has not been called
    ... >receiving this error when compiling. ... If you are creating a Dll or a Service or try to use ADO out of a Thread you ...
    (borland.public.delphi.database.ado)
  • Re: Cannot open csv file using Jet.OLEDB
    ... > I'm trying to open csv file from ado but i'm receiving the error "Could ... > here is the connection string: ...
    (microsoft.public.data.ado)
  • Cannot open csv file using Jet.OLEDB
    ... I'm trying to open csv file from ado but i'm receiving the error "Could not find installable ISAM " ... here is the connection string: ...
    (microsoft.public.data.ado)
  • Exchange 2003: How to check use activity
    ... We are investigating someone here in the office and need a list of ... addresses that this user has been sending and receiving from. ... I looked at the message tracking center however I dont think that will ...
    (microsoft.public.exchange.admin)
  • Object was open
    ... How I post a table with master/detail, with ADO and MSSQL2000, I am ... receiving an "Object was open" error. ... --- posted by geoForum on http://delphi.newswhat.com ...
    (borland.public.delphi.database.ado)