Stroing xls in oracle

[sainiamit25]

Hi,

I want to store one xls file in one of my tables. Requirement is that when i click on a link on some web page, this xls should get opened. Please help me doing that. A sample code will be high help. I am using 9i presently.

Cheers,
Amit

[debasisdas]

Do u want to store the file path or the entire file itself ?

[sainiamit25]

Do u want to store the file path or the entire file itself ?

Hi,

Thanks a lot for the reply. I want to store the entire file.

Cheers,
Amit

[debasisdas]

Try to use LOB fields.

[sainiamit25]

Try to use LOB fields.

I know that a LOB field be used to save but i dont know how to insert? Can you please help

Amit

[sainiamit25]

Stroing any file in oracle

can somebody give me a snippet as to how can we insert a pdf/xls file into the database??

Many Thanks,
Amit

[debasisdas]

Have you tried using LOB field.

What is the frontend that you are using ?

[osuri]

More on loading BLOB columns (what you need) in various programming languages available at http://download-east.oracle.com/docs...w.htm#g1039992.

You may need to register for a free account to view this page.

[amitpatel66]

I know that a LOB field be used to save but i dont know how to insert? Can you please help

Amit

Check for LOB details here

[amitpatel66]

Threads Merged for better management of forum

[subashsavji]

Hi,

I want to store one xls file in one of my tables. Requirement is that when i click on a link on some web page, this xls should get opened. Please help me doing that. A sample code will be high help. I am using 9i presently.

Cheers,
Amit

if you want to use LOB to load file then
example of LOB is already posted in this forum. plz. find it out.