RE: PDF's file in oracle database

  • From: "Ian Cary (C)" <Ian.Cary@xxxxxxxxxxxxxxxxxxxx>
  • To: <zettira@xxxxxxxxx>
  • Date: Tue, 6 Sep 2005 09:45:35 +0100

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

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

Other related posts: