I'm not sure this is on-topic, so my apologies if I should have answered this off-list.
You should be able to create a table with a CLOB or VARCHAR2 column and stuff the PDF file into that. If you use a CLOB, you can put the whole thing in there. I tend to use VARCHAR2 columns for portability reasons and have a set of routines that will split a text string into uniform sized chunks before putting them in the database. Bascially that routine is just a loop that uses subsr and then inserts into the database, including a column that keeps track of what order the chunks were inserted so they can be reassembled later. -dpf- ----------------------- David P. Fannin Database Administrator [EMAIL PROTECTED] UM-Rolla Computing and Information Services FAX (573) 341-4216 URL http://www.umr.edu/~dpf PHONE (573) 341-4841 ----------------------- -----Original Message----- From: Nguyen, David M [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 11:29 AM To: [EMAIL PROTECTED] Subject: How to import PDF files into oracle database using DBI Is is possible to store PDF files in oracle database to allow user accesses the files, open it and read it? If so, please advise how. I am using oracle8i with DBI running on Solaris8. Thanks, David
