| UTL_FILE.fcopy error [message #175868] |
Mon, 05 June 2006 15:31 |
mathewjn
Messages: 1
Registered: June 2006
Location: Grafton
|
Junior Member |
|
|
I am trying to use the UTL_FILE.fcopy function to copy a file from a samba share (Windows drive) to a Linux server.
Here is the code I am trying to execute.
BEGIN
UTL_FILE.fcopy('COA', '2906181732.PDF', 'PDF_COA', '2906181732.PDF');
END;
/
where COA is the samba share directory pointing to a windows machine and PDF_COA is the destination folder where the .PDF files needs to be copied.
Here is the problem - when I create the directory (COA and PDF_COA) and enable read/write access to it, I am creating this directory on Server A (a mid tier machine)that uses a database on Server B (a database sever) as it's repository.
Is this possible - since there is no server name qualifier on the ALL_DIRECTORIES table on the database - yet the directory points to the folder on SERVER A. How does the database on SERVER B know that this folder is location on SERVER A.
BTW, the error I am getting is ORA-29283......
I have tried this on a test box that has all the layers of the architecture on a single machine and have not encountered this problem. Is this viable only on single tier architectures?
Thanks
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
