Hello,
I want to load a Microsoft WORD document into the database using Forms 6i.
I use Oracle Forms 6.0.8.11 and Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 installed on a HP UIX server.
I looked around and found various threads regarding this kind of problem but I can't seem to make it work.
First of all, this is what I figured out(please correct me if I'm wrong):
I want to load a Word doc into the database.
According to this thread
9282327 i have to copy the document on the server before trying to insert it into the database.
On the client machine I have Windows XP installed.
I use win_api_dialog.open_file to select the file that I want to insert into the database and win_api_utility.copy_file to copy the file from the client to the database server.
I have created a directory using:
CREATE directory temp as '/tmp/my_dir';
GRANT read/write on directory temp to userxx;
When I run the form, I manage to select the file but get an error when I try to copy it to the database server( in /tmp/my_dir as stated earlier).
Does this happens because on the client machine I have Windows XP and on the database server machine it is HP UIX?
If this is correct how can I copy the files between the 2 machines in order to insert the file in the database.
PS:
The error that I receive is:
Could not copy the file C:\Documents and Settings\user\Desktop\filename.doc to tmp/my_dir/filename.doc