« Very simple comment spam protection | Main | Fixing ASP.NET »
October 19, 2005
Oracle BLOB/CLOB array problem
Try as I might I couldn't get .NET to work correctly with CLOB/BLOB array in Oracle. I have a stored proc that really needs a BLOB array as a parameter and I keep getting "Internal Error" (couldn't remember the code now). Google doesn't return that many suggestion either. I eneded up had to concatenate all my BLOB together, send another array to indicate the size of each chunk of the BLOB and split it in the stored proc. Thankfully we can do this quite easily using the dbms_lob.read method. It's frustrating really, but I couldn't find a single example that shows CLOB/BLOB with PL/SQL AssociativeArray working nicely with .NET.
Posted by vhadiant at October 19, 2005 11:54 PM
Trackback Pings
TrackBack URL for this entry:
http://www.hadianto.net/mov32/mt-tb.cgi/126
