RE: Slightly OT .Net and LOBs
- From: "Niall Litchfield" <n-litchfield@xxxxxxxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 19 Mar 2004 08:45:28 +0000
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@xxxxxxxxxxxxxx
> Sent: 18 March 2004 13:00
> To: ktoepke@xxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
> 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@xxxxxxxxxxxxxxxxxxxxxxx]
> Sent: Thursday, March 18, 2004 7:04 AM
> To: oracle-l@xxxxxxxxxxxxx
> 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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
