How to insert document or PDF file into Oracle database using ASP.Net

Question

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 :)

that depends on how you access the DB... which ADO.NET provider do you use ? — Yahia
– Yahia, Commented Oct 25, 2011 at 7:37

9dan · Accepted Answer · 2011-10-25 07:42:47Z

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

answered Oct 25, 2011 at 7:42

9dan

4,2702 gold badges35 silver badges45 bronze badges

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

1 Comment

Yahia Over a year ago

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

Karel Frajták · Accepted Answer · 2011-10-25 07:43:34Z

0

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

answered Oct 25, 2011 at 7:43

Karel Frajták

4,4971 gold badge25 silver badges35 bronze badges

5 Comments

Yahia Over a year ago

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

Karel Frajták Over a year ago

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.

Yahia Over a year ago

But it means that if you are starting something new then you should really consider avoiding it...

Karel Frajták Over a year ago

Ok, but the code will be almost identical - you will just use another data provider.

Yahia Over a year ago

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)...

Collectives™ on Stack Overflow

How to insert document or PDF file into Oracle database using ASP.Net

2 Answers 2

1 Comment

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related