Problem With Clob and Blob

[Guest]

I am using .net and oracle 9i. I created one store procedure in oracle who
takes clob field as input and inserts in table. In .net I am using
OracleClient i-e system.data.oracleclient namespace class to call this store
procedure. when I call this store procedure exception occurs that data is
large. I searched on internet and found that .Net Oracle Data Access Provider
restricts data to only 32k. So no matter you are using clob or blob, but
limit is 32k, means you can insert max 32k of data from .net to oracle .....
Can anyone tell me solution of it.

 

[Paul Clement]

On Tue, 9 May 2006 02:13:01 -0700, Altaf Al-Amin Najwani

¤ I am using .net and oracle 9i. I created one store procedure in oracle who
¤ takes clob field as input and inserts in table. In .net I am using
¤ OracleClient i-e system.data.oracleclient namespace class to call this store
¤ procedure. when I call this store procedure exception occurs that data is
¤ large. I searched on internet and found that .Net Oracle Data Access Provider
¤ restricts data to only 32k. So no matter you are using clob or blob, but
¤ limit is 32k, means you can insert max 32k of data from .net to oracle .....
¤ Can anyone tell me solution of it.

See if the following helps:

How to pass a BLOB as a parameter to an Oracle package by using the .NET Managed Provider for Oracle
http://support.microsoft.com/default.aspx?scid=kb;en-us;322796


Paul
~~~~
Microsoft MVP (Visual Basic)