Slightly OT .Net and LOBs

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Thu, 18 Mar 2004 12:03:57 -0000
Message-ID: <CFECD6EA683C524BB5FD22C0F1F34ACB01936C5A@bristol43.audit-commission.gov.uk>

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:01:21 CST