Uploading & Downloading files with Oracle Forms

Noel · *nix forums addict Joined: 25 Mar 2005 Posts: 67

Użytkownik Tommy DN napisał:

Tommy DN · *nix forums beginner Joined: 10 Aug 2005 Posts: 3

Can someone explain how you can store a file such as a MS Word
document into an oracle database using Oracle Forms Builder ( 6i )?
I've tried to make a BLOB like:

"
create table test_blob
(id number primary key not null
,bestand blob);
"

Then I tried to import it with the datablock wizard and I've changed
the image item into an OLE item and I've clicked 'MS Word application'
somewhere. But I don't understand it.

I want that the user can select a file to upload to the database. And
when you look at the records, it must be possible to dowload ( or view
) the file from the database.

Can someone explain me how? I've never used files with databases.

Google