Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Saving Documents on BLOB columns

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
Please, help me with this:

I created a new table:
CREATE TABLE testfile
(file blob);

and created a new Form with Ole Container Item to save document on Database.

I can insert new Word Document and edit this doing double click on the container, but, when save (commit) record on the database, I can't edit again the Word document, becuase Forms show next error:

FRM-40501: ORACLE error: unable to reserve record for update or delete

I checked all Block and Item Properties and all is Ok
Insert Allowed = Yes
Update Allowed = Yes
Delete Allowed = Yes
Locking Mode = Automatic
Key Mode = Automatic

I'm using Oracle8i Enterprise Edition Release 8.1.7.3.0
and forms 6i (Version 6.0.8.8.0)

Thanks for you help
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top