From oracle-l-bounce@freelists.org Thu Mar 18 06:57:34 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2ICvYk22935 for ; Thu, 18 Mar 2004 06:57:34 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i2ICvWo22912 for ; Thu, 18 Mar 2004 06:57:33 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 63F68390DE4; Thu, 18 Mar 2004 07:55:33 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 18 Mar 2004 07:54:25 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from wilmail.wilnet (unknown [208.235.71.25]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6313F390D5F for ; Thu, 18 Mar 2004 07:54:24 -0500 (EST) Received: by wilmail.wilnet with Internet Mail Service (5.5.2656.59) id ; Thu, 18 Mar 2004 08:00:36 -0500 Message-ID: <524A8924345BD411B65600508B9A8B6505F17B48@wilmail.wilnet> From: Kevin Toepke To: "'oracle-l@freelists.org'" Subject: RE: Slightly OT .Net and LOBs Date: Thu, 18 Mar 2004 08:00:36 -0500 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2656.59) Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C40CE9.01380BA0" X-archive-position: 1122 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: ktoepke@rlcarriers.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l ------_=_NextPart_001_01C40CE9.01380BA0 Content-Type: text/plain Check Metalink. There are some nice examples that actually work. Kevin -----Original Message----- From: Niall Litchfield [mailto:n-litchfield@audit-commission.gov.uk] Sent: Thursday, March 18, 2004 7:04 AM To: oracle-l@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. ********************************************************************** ------_=_NextPart_001_01C40CE9.01380BA0 Content-Type: text/html Message
Check Metalink. There are some nice examples that actually work.
 
Kevin
-----Original Message-----
From: Niall Litchfield [mailto:n-litchfield@audit-commission.gov.uk]
Sent: Thursday, March 18, 2004 7:04 AM
To: oracle-l@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.
**********************************************************************
------_=_NextPart_001_01C40CE9.01380BA0-- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@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 -----------------------------------------------------------------