RE: Slightly OT .Net and LOBs

From: Kevin Toepke <ktoepke_at_rlcarriers.com>
Date: Thu, 18 Mar 2004 08:00:36 -0500
Message-ID: <524A8924345BD411B65600508B9A8B6505F17B48@wilmail.wilnet>

Check Metalink. There are some nice examples that actually work.

Kevin

-----Original Message-----

From: Niall Litchfield [mailto:n-litchfield_at_audit-commission.gov.uk] Sent: Thursday, March 18, 2004 7:04 AM
To: oracle-l_at_freelists.org
Subject: Slightly OT .Net and LOBs

Apologies if this is too off-topic.

So I made the mistake of commenting that our documentation was somewhat lacking. This means I get to update it. Self-harm is a terrible thing. Anyway me being me I decided to do some learning as well. I have a package that acts as a dml api for some base tables and am busy trying to write a .Net web app to allow documentation and details to be stored in these tables.

calling stored procs is easy. However I have hit something that I can't find documented anywhere.

I wish to store an arbitrary document from the client filesystem into a blob field. I can obtain the file as either a .Net stream or a Byte array, equally I have a procedure that takes a BLOB as an input argument, I'm sure that it should be easy to pass the one to the other but I can't yet figure out how. Any pointers in either c# or vb would be gratefully received.

If its a version dependent thing I am using ODP.Net 9.2.0.4 and .Net Framework 1.1

Niall Litchfield
Oracle DBA
Audit Commission
+44 117 975 7805

This email contains information intended for the addressee only. It may be confidential and may be the subject of legal and/or
professional privilege. Any dissemination, distribution, copyright or use of this
communication without prior permission of the sender is strictly prohibited.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

Received on Thu Mar 18 2004 - 06:57:34 CST