Home » Developer & Programmer » Forms » Excel/File Download (form 6i)
Excel/File Download [message #671073] Tue, 14 August 2018 06:08 Go to next message
Messages: 1
Registered: October 2011
Location: Coimbatore
Junior Member

Dear All,

I am using oracle fomrs 6i, I want to move/copy a file from one location to another. I am using the following method. Win_Api_utility.copy_File('D:\PRABHA\TEST.xls','D:\',true);

I attached D2kwutil.pll in forms. it s working successfully. But files are not moving. Please help me to complete this work..

Thanks in Advance.
Re: Excel/File Download [message #671112 is a reply to message #671073] Wed, 15 August 2018 12:12 Go to previous message
Messages: 21671
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
(Just checking: did you put the PLL into Forms' \bin directory?)

COPY_FILE accepts 4 parameters:

  • OldFileName - The location and name of the file to Copy
  • NewFileNme - The new location and name for the copy of the file
  • AllowOverWrite - TRUE or FALSE(Default) If FALSE, then if the NewFileName already exists then the move will fail. If TRUE the existing file will just be overwritten.
  • RaiseExceptions - TRUE or FALSE(Default) If set to true, then if the command is not successful (e.g the file does not exist) then the explicit exception NO_DATA_FOUND will be raised.
So, what happens if you include the fourth parameter (set to "true"), i.e.

Win_Api_utility.copy_File('D:\PRABHA\TEST.xls', 'D:\', true, true);
Previous Topic: ORA-00600 when compiling when-button-pressed
Next Topic: Go to Specific Record
Goto Forum:

Current Time: Tue May 18 02:54:01 CDT 2021