Home » Developer & Programmer » Forms » Problem in writing file to %userprofile% (Oracle 9i ,Oracle 6iDS)
Problem in writing file to %userprofile% [message #417721] Tue, 11 August 2009 04:50 Go to next message
jolly_makkar
Messages: 63
Registered: March 2008
Member
Quote:
PROCEDURE CREATE_FLAT_FILE IS
-- DESCRIPTION
-- Simple procedure to write to a text fille from a form
-- NOTES
-- Call this procedure from the WHEN-BBUTTON-PRESSED trigger
-- REQUIREMENTS
-- Must have access to local drives
--
--=============================================================================

in_file TEXT_IO.FILE_TYPE;
linebuf VARCHAR2(80);
your_file VARCHAR2(50) := 'C:\TEMP\your_file.dat';
text_line VARCHAR2(400);
BEGIN
in_file := TEXT_IO.FOPEN(your_file, 'W');
GO_BLOCK('YOUR_DATA_BLOCK');
FIRST_RECORD;
LOOP
IF :your_checkbox = 'Y' THEN
text_line := LPAD(:your_item1, 10, ' ')||
LPAD(:your_item2, 20, ' ')||
LPAD(:your_item3, 30, ' ')||
LPAD(:your_item4, 50, ' ');
--

TEXT_IO.PUT_LINE(in_file, text_line);
END IF;
--
exit when :SYSTEM.LAST_RECORD = 'TRUE';
NEXT_RECORD;
END LOOP;
--
TEXT_IO.FCLOSE(in_file);
EXCEPTION
WHEN NO_DATA_FOUND THEN
TEXT_IO.FCLOSE(in_file);
END;

==============================================
Procedure is working fine ,but is it possible that i can write on %userprofile% path

i tried changing
Quote:
your_file VARCHAR2(50) := 'C:\TEMP\your_file.dat';


to
Quote:
your_file VARCHAR2(50) := '%USERPROFILE%\your_file.dat';


it raised an error .how i can write in %userprofile%

Your guidance would be worth.....

Regards

Re: Problem in writing file to %userprofile% [message #417854 is a reply to message #417721] Tue, 11 August 2009 19:35 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Please use 'code' tags for code as 'quote' tags are for making a quote!

Do you know of a command that when run at the windows 'cmd' prompt will resolve '%USERPROFILE%'? If so then use it in a 'host' command, direct the output to a file, and then read that file.

David
Previous Topic: frm-40509: unable to update record
Next Topic: Copying image from one database item into another database item using Oracle Forms 10g
Goto Forum:
  


Current Time: Thu Dec 08 16:38:02 CST 2016

Total time taken to generate the page: 0.09676 seconds