Looking at what you had to go through and knowing your our system is configured, it looks like I may be out of luck. But I'll definitely check into the possibilities.
Thanks. ============================================ Gary L. Alford Materiel and Procurement Senior BPE Specialist, SCM Bell Helicopter Textron Phone: (817) 280-6233 Fax: (817) 278-6233 mailto:galford2@;bellhelicopter.textron.com ============================================ -----Original Message----- From: Alex Young [mailto:ayoung13@;mindspring.com] Sent: Friday, October 25, 2002 7:30 PM To: [EMAIL PROTECTED] Subject: Re: ColdFusion and Oracle Interface Gary, I did exactly this type of thing before. I had to transmit the file from the client (browser) to the web server, then from the web server to the database server, and then call an oracle PL/SQL stored procedure to load the binary file from the database server host operating system file system into the oracle table. This process had to be reversed in order to retrieve the file back to the client. Look at the cffile, cfftp, and cfcontent commands for an explaination of the whole process going each way. The version of oracle here is important if you are looking to get the file back to the client. PL/SQL does support reading a binary file into a BLOB column; however, it is only in Oracle 9i that there is a method for doing the reverse. I was using Oracle 8i so I had to use one of either (1) have a PL/SQL stored procedure call an external C program or (2) use a java stored procedure to extract the file from the blob column and write it to the file system for transmision back to the web server and then back to the browser. The Oracle portions of this issue is covered several times on Oracle technet in the database discussion forum. Hope this helps ----- Original Message ----- From: "Alford, Gary" <[EMAIL PROTECTED]> To: "DFW ColdFusion Users Group (E-mail)" <[EMAIL PROTECTED]> Sent: Friday, October 25, 2002 3:35 PM Subject: ColdFusion and Oracle Interface > Hey guys. It's great to be back on line. > > I have a ColdFusion form that inputs and updates an Oracle database table. > One of the fields in the table is set as a CLOB (BLOB may be better, but I'm > not sure). This type of field is "supposed" to allow input and storage of > binary type data such as pictures, images, and large chunks of data. > > One of my <input... boxes on my form is set to "type='file'." This "should" > allow the input of some file, whether it be MS Word, Excel, Adobe PDF, JPG, > etc., to be placed into the CLOB field in the data table. However, when I > run a CFQUERY against that field to try and output the stored file, all I > receive is the file name from the system of the location where it stored the > file on my hard drive prior to updating the table (i.e. D:\temp\acs95.tmp). > > Am I doing something wrong? Am I missing any steps? Has anyone else tried > something like this before? > > Any input would be greatly appreciated. > > ============================================ > Gary L. Alford > Materiel and Procurement > Senior BPE Specialist, SCM > Bell Helicopter Textron > Phone: (817) 280-6233 > Fax: (817) 278-6233 > mailto:galford2@;bellhelicopter.textron.com > ============================================ > > > ------------------------------------------------------------------------- > This email server is running an evaluation copy of the MailShield anti- > spam software. Please contact your email administrator if you have any > questions about this message. MailShield product info: www.mailshield.com > > ----------------------------------------------- > To post, send email to [EMAIL PROTECTED] > To subscribe / unsubscribe: http://www.dfwcfug.org > ------------------------------------------------------------------------- This email server is running an evaluation copy of the MailShield anti- spam software. Please contact your email administrator if you have any questions about this message. MailShield product info: www.mailshield.com ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org ------------------------------------------------------------------------- This email server is running an evaluation copy of the MailShield anti- spam software. Please contact your email administrator if you have any questions about this message. MailShield product info: www.mailshield.com ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org
