Re: Accessing files copied by UTL_FILE.FCOPY
Date: Mon, 29 Sep 2008 08:14:16 -0700
> Hi folks,
> I'm running into a strange (at least to me) problem. I have
> implemented a small document management system into an existing
> Oracle10g database application. DMS requires copying files from one
> folder to another. Physical files (originals as well as copies) are
> located on a mapped resource. This drive is mapped by group policy so
> SYSTEM user which oracle service is running on "sees" that resource.
> Thus, copying files with utl_file.fcopy is no problem.
> But I cannot access any copied file with it's application. An MSExcel
> file won't open at all. Error message says, network drive wasn't
> available or file was write protected. A pdf files is opened by Adobe
> Reader but showing empty pages (in correct number, by the way).
> Network drive is available and, as far as I can see, there is no lock
> on any file. Original files open without problems.
> Do you have any ideas on where to to closer examination?
No idea where to look but a lot of questions:
- What operating system?
- How are drives mapped?
- Is the file size being changed by the copying?
- Why are you doing this at all rather than storing the docs as a BLOB?
I have no problem, with the code here:
http://www.psoug.org/reference/securefiles.html (scroll down to .mpg)
storing docs and restoring them on demand in perfectly usable form. Similar code is available in all currently supported versions.
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Mon Sep 29 2008 - 10:14:16 CDT