Home » RDBMS Server » Server Administration » storing word documents in oracle
storing word documents in oracle [message #54901] Fri, 13 December 2002 21:56 Go to next message
Harish
Messages: 25
Registered: February 2001
Junior Member
i am using VB script in amy ASP pages.
How to store word documents and other large objects in oracle 8i database using VB script?
and how to retrive it?
Re: storing word documents in oracle [message #54905 is a reply to message #54901] Sat, 14 December 2002 03:24 Go to previous message
sai sreenivas jeedigunta
Messages: 370
Registered: November 2001
Senior Member
hello,
to insert a document itself u have to use a bfile data type, and some workarounds are also possible by using UTL_FILE Package.. in order to store data into lob columns...from the frontend use rs.addnew instead of using the con.execute('insert statement')

good luck
sai
Previous Topic: URGENT:Couldn't figure out why this statement fails.
Next Topic: Urgent Oracle 8i
Goto Forum:
  


Current Time: Fri Sep 20 05:36:43 CDT 2024