RE: PDF's file in oracle database

From: Garry Gillies <g.gillies_at_weirpumps.com>
Date: Wed, 7 Sep 2005 14:39:57 +0100
Message-ID: <OF3D261EBA.C3A1CDF8-ON80257075.004ADB8E-80257075.004B0DB9@weir.co.uk>

In addition to Ians list, you can do it with a web browser and IAS search metalink for "cntsample" for details

                                                                           
             "Ian Cary (C)"                                                
             <Ian.Cary_at_ordnanc                                             
             esurvey.co.uk>                                             To 
             Sent by:                  <zettira_at_lycos.com>                 
             oracle-l-bounce_at_f                                          cc 
             reelists.org              <oracle-l_at_freelists.org>            
                                                                   Subject 
                                       RE: PDF's file in oracle database   
             06/09/2005 09:45                                              
                                                                           
                                                                           
             Please respond to                                             
             Ian.Cary_at_ordnance                                             
               survey.co.uk

Ah, you wouldn't be trying to load pdf files residing on a windows client into a remote (Unix based?) Oracle database would you?

If so the PL/SQL solution won't work as the directory has to be local (or appear to be) to the database and can't point to a remote filesystem.

Depending on where you wan't your process to be controlled from you'll have to try the SQL*Loader solution (client controlled) or the Java solution (either)

Cheers,

Ian

Thanks Ian,
One more question. Your script, is it working on oracle 8i? Should the directory created on server not on client?

This email is only intended for the person to whom it is addressed and may contain confidential information. If you have received this email in error, please notify the sender and delete this email which must not be copied, distributed of disclosed to any other person. Unless stated otherwise, the contents of this email are personal to the writer and do not represent the official view of Ordnance Survey. Nor can any contract be formed on Ordnance Survey's behalf via email. We reserve the right to monitor emails and attachments without prior notice.

Thank you for your cooperation.

Ordnance Survey
Romsey Road
Southampton SO16 4GU
Tel: 023 8079 2000
http://www.ordnancesurvey.co.uk

--

http://www.freelists.org/webpage/oracle-l

CONFIDENTIAL: The information contained in this email (including any attachments) is confidential, subject to copyright and for the use of the intended recipient only. If you are not the intended recipient please delete this message after notifying the sender. Unauthorised retention, alteration or distribution of this email is forbidden and may be actionable.

Attachments are opened at your own risk and you are advised to scan incoming email for viruses before opening any attached files. We give no guarantee that any communication is virus-free and accept no responsibility for virus contamination or other system loss or damage of any kind.
--

http://www.freelists.org/webpage/oracle-l Received on Wed Sep 07 2005 - 08:42:37 CDT