| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Slightly OT .Net and LOBs
Cheers,
I'm rather shamefaced as the error was nothing to do with passing the byte array to the procedure, it was trying to insert a BLOB in a CLOB column :( Always check the basics first.
Niall Litchfield
Oracle DBA
Audit Commission
+44 117 975 7805
> -----Original Message-----
> From: ktoepke_at_rlcarriers.com
> Sent: 18 March 2004 13:00
> To: ktoepke_at_rlcarriers.com; oracle-l_at_freelists.org
> Subject: RE: Slightly OT .Net and LOBs
>
>
> 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.
> **********************************************************************
>
>
-- 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 Fri Mar 19 2004 - 03:17:18 CST
 |
 |