Slightly OT .Net and LOBs
- From: "Niall Litchfield" <n-litchfield@xxxxxxxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 18 Mar 2004 12:03:57 -0000
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.
**********************************************************************
Other related posts:
