1

I have a CLOB data type on my database and a FileUpload button on my ASP.Net. So my question is how can I insert a word document or PDF file into my Oracle database using ASP.Net?

Anyone knows how to do this? I'm a beginner. Please bear with me :)

2
  • that depends on how you access the DB... which ADO.NET provider do you use ? Commented Oct 25, 2011 at 7:37
  • duplicate see: stackoverflow.com/questions/4902250/… Commented Oct 25, 2011 at 7:59

2 Answers 2

0

You'd better separate the question in two parts (for handling file upload, for BLOB I/O) and post again to get more detail answers.

Or, you can search SO with these keywords: FileUpload, BLOB, Oracle (tag .net)

Below are my Google search result about ASP.NET BLOB read/write for Oracle provider:

Insert /retrieve an image into/ from a blob field in Oracle database using C#.Net

Writing to Oracle CLOB fields using System.Data.OracleClient

Sign up to request clarification or add additional context in comments.

1 Comment

According to MS System.Data.OracleClient is deprecated - see blogs.msdn.com/b/adonet/archive/2009/06/15/…!
0

UTFG! Search "oracle ado.net clob" in Google and check this MSDN page.

5 Comments

According to MS System.Data.OracleClient is deprecated - see blogs.msdn.com/b/adonet/archive/2009/06/15/…!
But that doesn't mean, you can't use it. Cited: System.Data.OracleClient will be available in the upcoming 4.0 release of .NET Framework; however, it will be marked as deprecated. This will have no impact to existing applications and these applications will continue to work as expected.
But it means that if you are starting something new then you should really consider avoiding it...
Ok, but the code will be almost identical - you will just use another data provider.
Not really... esp. regarding CLOB/BLOB handling there is a difference on how the different providers handle that (some offer means to optimize the memory usage for example)...

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.